We've got a client in the field who runs a report and it creates an
oddball error, one that no one else is apparently getting....and the
best part---it doesn't always happen, and it happens on multiple
machines if I heard her right. It's legacy code from eons ago so it's
not like we just introduced a bug recently with new code in that area of
the program.
The code is as follows, copied exactly as it is in the source:
SELE *,000000.00 AS AmtUsed;
FROM TRANSACT;
WHERE inqnum = nInq;
AND Amount != 0;
INTO DBF (Temppath + "csrTrans.dbf")
INDEX ON Transdate TAG Transdate
The Temppath variable holds a LOCAL location that's generated by the app
(e.g., C:\Symplcty\SymPrefs\TempSym\_2GN0NJO2Z).
I've checked the values in the Transdate column in that table: 1 record
with a crazy date back in the year 0120, 2 records where it was 0220, 1
from 1901 and the rest appear to be normal. And these goofy records
aren't even the ones in the query result.
If I were rewriting the code today, I'd change it to use a local CURSOR
output, but apparently the original developers either didn't have
CURSORS available to them or didn't understand how to use them OR just
preferred to have local DBFs so they could check data as they debugged
from other Fox windows. (I knew a legacy guy who practiced the
latter...may he RIP.)
Can anyone give a reason as to why the INDEX ON Transdate TAG Transdate
line would throw an Error 1705 File access is denied on the CDX file?
It's worthy of noting too that my colleague and I went to the folder to
see the files, and the DBF and FPT were there, but NO CDX was present.
WEIRD!!!
Any advice appreciated...thanks!!!!
--Michael
_______________________________________________
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.
