Thanks, John, garry & Michael. I figured TRY/CATCH would be the last ditch but I thought there was some way to 'ask' the table if it had a sponsor DB.
Thank you all for the quick response! Henry -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of MB Software Solutions Sent: 2007-01-24 1:15 PM To: [EMAIL PROTECTED] Subject: Re: InDbc and Free Table [EMAIL PROTECTED] wrote: > 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 > Perhaps if you're using VFP8/9, you can wrap it in a TRY/CATCH error handling block so as to handle the error properly? -- Michael J. Babcock, MCP MB Software Solutions, LLC http://mbsoftwaresolutions.com http://fabmate.com "Work smarter, not harder, with MBSS custom software solutions!" [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.
