>Is it possible to access and store the actual query time from a VFP SQL query?
>
Sure,
LOCAL lnSeconds, lcCursor
lnSeconds = SECONDS()
SELECT * ;
FROM myTable ;
WHERE RECNO() < RECCOUNT ;
INTO CURSOR ltCursor
lnSeconds = SECONDS() - lnSeconds
? lnSeconds
RETURN
There's probably something fancier, but this should work to withing 1/10000 or a second or so.
regards,
Jim Edgar
Jurix Data Corporation
jmedgar@yahoo.comNo trees were destroyed in sending this message. However, a large number of electrons were diverted from their ordinary activities and terribly inconvenienced.
