Bruce:
To DELETE ROWS, the temp TABLE must exist first.
otherwise you will run into another -ERROR- message as follows:
-ERROR- tablename is an undefined table. (2038)
In that case, you have to first check the
existence of TEMPORARY table and then use the DELETE ROWS from that TEMP table.
Albert:
Thanks. RSyntax has a very good section: "Temporary Tables and Views",
and your DROP TABLE code is correct.
Coding aside, I'm just wondering if there are any operational advantages
to DROP or DELETE ROWS
http://www.rbase.com/support/rsyntax/rbgx/index.html
Bruce
-- Original Me
2 matches
Mail list logo
