Jerry, May be an index or file corruption problem. If the table is part of a database then recreate it. If it is a free table then move it and manually create another table called purchase and try to open that. This should then open no problem and you can append into it from the "corrupted table"
Other than that there is no reason I can see for the error. Also have you got any SP's or triggers that you don't know about that are firing inadvertently. Dave C -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of jerryF Sent: 16 December 2009 04:01 To: 'ProFox Email List' Subject: RE: Alias Not Found The phrase USE PURCHASE IN 0 ALIAS MYTEST EXCLUSIVE also fails Jerry -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of MB Software Solutions,LLC Sent: Tuesday, December 15, 2009 9:57 PM To: ProFox Email List Subject: Re: Alias Not Found jerryF wrote: > Hi guys Im'having a problem with a simple statement. > > > > Both "USE PURCHASE.dbf EXCLUSIVE ALIAS TEST" and "USE PURCHASE.dbf ALIAS > TEST" > > Both return a error message Alias 'PURCHASE' is not found. > > I have loads of other files in the same folder that I open with the same > syntax. > > > > The file IS in the current folder. and the statement USE PURCHASE.dbf > EXCLUSIVE or USE PURCHASE.dbf both work.. > > It has something to do with the alias part but I don't know what it could > be. > > > > Any help would be appreciated.. > > Thanks Jerry What about this (exactly...no DBF and this specific order): USE PURCHASE IN 0 ALIAS MYTEST EXCLUSIVE Does that fail? -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 [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/341e294bd7e8464080091fbc5ea4f...@develop ** 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.
