Hi!
These settings are reset to default values for each private data session. Is that query runs in private data session?
I have no more idea. If you can send mew these data and code, I can try to test it here and figure out where is a problem. Contact me by EMail.
>Hi Vlad,
>
>>Some more questions:
>>- Are data different in different runs (local/remote)?
>
>It's the same data (for local testing I made a copy from the live production database in my local hard disk).
>None of the tables are included on the EXE, and I do not get any error messages when running the program neither with local or production data.
>I have also tried combinations with SET ANSI, SET NEAR, SET EXACT and SET DELETED with no results.
>
>Thanks for helping,
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.