Anti-Virus gets a lock.
-----Original Message-----
From: MB Software Solutions General Account
Sent: Tuesday, September 30, 2008 6:13 PM
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.
