(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