Please enable JavaScript to view this site.

R:BASE 11 Help

Navigation: Function Index > C

CHKTABLE

Scroll Prev Top Next More

(CHKTABLE('tblview'))

 

Checks to see if a table/view exists. The function returns a value based upon the permanent or temporary nature of a table or view, and if a table is attached as a server or dBASE table.

 

Return Value

Status

0

table/view does not exist

1

permanent table

2

temporary table

3

server table

4

dBASE table

5

permanent view

6

temporary view

 

Examples:

 

Example 01:

SET VAR vCheckTable INTEGER = (CHKTABLE('Contact'))

SHOW VAR vCheckTable

1

 

Example 02:

SET VAR vCheckTable INTEGER = (CHKTABLE('QuarterlySummary'))

SHOW VAR vCheckTable

5