Using file() to check the existence of a table is not safe. Have a look at: http://www.dbmonster.com/Uwe/Forum.aspx/foxpro/4747/Command-to-check-whe ther-a-foxpro-table-exists
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Sytze de Boer Sent: donderdag 14 juli 2011 23:06 To: [email protected] Subject: Re: No table is open I think I've found the problem The error comes up with error 52, No table is open in the current work area I'm about to test this Create a table Create a cdx with this table Close the table Delete the cdx file (I think this has happened at this client site) now type use thistable On Fri, Jul 15, 2011 at 1:18 AM, Alan Bourke <[email protected]>wrote: > I think I had something similar recently but in FoxPro 2.6 - I had added > an index on a memo field which was all fine until the user ran a process > which did a PACK MEMO as part of its operations. This caused the CDX to > become corrupt and on attempting to open the table an "error 1113 - File > Is Not Open" was thrown, which is sort of in the same ballpark. > -- > Alan Bourke > alanpbourke (at) fastmail (dot) fm > > [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.
