Hi Mike,
The problem was that our SQL was, in some situations, not compliant with the rest of the world. So the default behavior is now to be compliant with other SQL standards. The SYS function is an acknowledgement that people will need to be backward-compatible for existing apps.
>>Have you tried putting SYS(3099, 70) in the code?
>
>With that in place it works. But, this forces me to be backward compliant. If MS decided to adapt its SQL engine to a new standard then I really want to know what I should adapt on it to make it standard to the native SQL support of the product. I don't want to start added backward compliant command where it occurs. I want to resolve it once and for all. :)
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05