I suspect RBASE checks for the temp table existence before it tries to
delete it, that's why you set the error messages off.
It's ok to check on your own prior to delete, but I believe it's
redundant and takes a few extra wasted nanoseconds.
Doug
On 1/18/2019 9:42 AM, 'Karen Tellef' via RBASE-L wrote:
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]>
To: rbase-l <[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.
---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
--
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.
