I would check for existence first. Dan Goldberg
From: 'Karen Tellef' via RBASE-L <[email protected]> Sent: Friday, January 18, 2019 7:43 AM To: [email protected] Subject: Re: [RBASE-L] - Tip of the Day: New CHKTABLE Function This is nice!!! On a related note, what does RBTI suggestion when creating a temp table? Is it okay to do a: DROP TABLE tmpTable every time (assuming you have 2038 set off) Or is it preferable to check for the existence of the temp table first, and only drop if it exists? Thanks! Karen -----Original Message----- From: A. Razzak Memon <[email protected]<mailto:[email protected]>> To: rbase-l <[email protected]<mailto:[email protected]>> Sent: Fri, Jan 18, 2019 9:14 am Subject: [RBASE-L] - Tip of the Day: New CHKTABLE Function 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].<mailto:[email protected].> For more options, visit https://groups.google.com/d/optout. -- 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]<mailto:[email protected]>. For more options, visit https://groups.google.com/d/optout. -- 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.
