Many thanks to you both, Ed and Dave Having only worked with free tables I have never come across this problem - and the task I am working in is refactoring some code that was originally written for FPD !
So, I won't ever, ever do it again - I promise ! BUT it raises two questions: 1. What happens if a CDX gets accidentally deleted outside of VFP ? 2. More importantly - can there ever arise a type of data corruption whereby DELETE TAG ALL and recreating index tags does not work ? Thanks Paul Newton Dave Crozier wrote: > Paul, > Never Ever delete the index from outside VFP as there is incex link info > held inside the DBC container which will be corrupted. > > Use Delete Tag all > > To remove index tag information then create the indexes from scratch. > > Dave Crozier > > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf > Of Paul Newton > Sent: 27 September 2007 13:59 > To: [email protected] > Subject: Re: How to find DBC for a table > > Many thanks, Ed - now all I need is the answer to the second question in > my post ! > > Paul Newton > > Ed Leafe wrote: > >> On Sep 27, 2007, at 8:24 AM, Paul Newton wrote: >> >> >> >>> 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 ? >>> >>> >> USE MyTable ALIAS Foo >> dbc = CURSORGETPROP("Database", "Foo") >> >> -- Ed Leafe >> -- http://leafe.com >> -- http://dabodev.com >> >> >> >> >> [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.
