I'm pretty sure I've identified the issue If there was previously a cdx file, and now there isn't, it throws an error if you say "use mytable excl"
my error routine (on error) explicitly ignores this error Which is fine, but in that case, I need to re-state/repeat the line "use mytable excl" before the line that says "index on ......" S On Wed, Feb 10, 2010 at 6:04 AM, Rick Schummer < [email protected]> wrote: > >> Can anyone suggest how this could end up in error 8, No table is open in > the > current work area<< > > You did not say which line of code is causing the error so we are all > guessing. What error handling are you using, ON ERROR, or Error method? > > I have recently noticed VFP occasionally does not throw an error when > opening a table, and the table is not opened. This is happening randomly so > I cannot produce reproducible steps. You might consider wrapping the code > in > a TRY...CATCH to see of it will capture an error, or double check to see if > the table is opened after the USE statement, and if not, USE it again. > > Rick > White Light Computing, Inc. > > www.whitelightcomputing.com > www.swfox.net > www.rickschummer.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.
