Now I see. USE Table would open the DB if one is attached. You're checking before and after. Interesting ;-))
What do you think of the Try/Ctach in my other message? The test went ok. Henry -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tracy Pearson Sent: 2007-01-24 1:28 PM To: [EMAIL PROTECTED] Subject: RE: InDbc and Free Table Having a second glance at the code, this would only work if the database of the table in question was not already open. Tracy > -----Original Message----- > > This might be the long way > local nCount, lDatabases > nCount = ADatabases(lDatabases) > use table > if nCount <> ADatabases(lDatabases) > ?"table is part of a database." > endif > > Tracy > > > > -----Original Message----- > > > > INDBC() can tell me if a table is part of this database. > > > > FREE TABLE can disconnect the table from a database. > > > > How can I tell if this table has a link to a DB that I need > to remove? > > > > Issuing FREE TABLE blindly will generate an error if no DB link > > exists. > > > > There must be something obvious I'm missing. > > > > Thanks, > > > > Henry [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 ** 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.
