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.
