Friday, January 18, 2019
Tip of the Day: New CHKTABLE Function
Product.......: R:BASE X.5 and R:BASE X.5 Enterprise (Version 10.5)
Build.........: 10.5.1.30117 or higher
Sections......: Functions
Keywords......: Table, View, Server, Temporary, dBASE
Did you know it is now easier than ever to verify the existence of a table
or view, of any type?
A new CHKTABLE function was added 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.
A return value (0-6) is provided based upon the table/view name provided:
0 = Table/View does not exist
1 = Permanent Table
2 = Temporary Table
3 = Server (SATTACHed) Table
4 = dBASE Table
5 = Permanent View
6 = Temporary View
SET VAR vCheckTable INTEGER = (CHKTABLE('Contact'))
SHOW VAR vCheckTable
1
SET VAR vCheckTable INTEGER = (CHKTABLE('QuarterlySummary'))
SHOW VAR vCheckTable
5
Very Best R:egards,
Razzak.
https://www.rbase.com
http://www.facebook.com/rbase/
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
