numeric field problems

[steve745]

Ok so the code has been working for a long time until i tried something today and discovered it is not giving the full info here is a screen shot of whats happening i can send code privately due to the info that is in it.

dbaseerror.jpg

it is pulling the correct list of docs from the sql server based on the idclientd but seems to no like the value of the number, the main table stores the number correctly and fields are same type and same size numeric,19.
my sql field is bigint() but haven't had any issues on any other places.

[steve745]

I was able to work around this error by using query to dbf and just rewrote the script.