Tx Brian Brian Abbott wrote: > The immediate answer is the DBC() command. (also be aware of OPEN > DATABASE ...). > The problem is that DBC() returns the current database BUT :
When used with a noncurrent database, the USE command opens the database automatically but does not set the database as the current database. When the table closes, the database remains open So that would not work. Unfortunately SDT is not an option Paul > But more generally if you're using DBCs I'd recommend investing in > Stonefield Database Toolkit - with it life is easy, without it you will > get hard to diagnose/fix problems like you mentioned. > > Paul Newton wrote: > >> Hi all >> >> I have always used free tables before but am now working with DBCs and >> two problems have arisen. >> >> Help says: >> >> When used with a noncurrent database, the USE command opens the database >> automatically but does not set the database as the current database. >> When the table closes, the database remains open >> >> Fair enough - but how do I identify the database that has been opened ? >> >> Secondly, I am getting 1561 errors (Database is invalid) associated with >> certain commands (DELETE TAG, INDEX ON) when/after deleting the table CDX. >> >> Can I safely ignore these errors or should I trap them and use VALIDATE >> DATABASE ... RETRY in the error handler ? >> >> Many thanks >> >> Paul Newton >> >> >> [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
