Brain fade or other, but I'm still at a loss why this would fail
intermittently
Any suggestions anyone?
Once upon a time, you could only open a certain number of tables. Could that
be the issue?
I can't duplicate the error in my own development environment
code where lcAsk is determined
lcFile="MTH"+ALLTRIM(STR(lcAsk))+".DBF"
IF !FILE("&lcFile")
=MESSAGEBOX('Sorry, no data available from which to print statements
',0,'Sorry')
RETURN
ENDIF
SELECT 0
USE (lcfile) EXCLUSIVE ALIAS TMP
** this is where it sometimes fails with message "No table is open"
INDEX on client+trantype+DTOC(date) TAG tmp
SET ORDER to 1
GO top
--
Regards
Sytze de Boer
Kiss Software
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---
_______________________________________________
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/CAG1nNy9nytTY1TwuTePGRKTRSU6RsaTKWcO-ZC6=lt1nplt...@mail.gmail.com
** 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.
