Hi John,

Does this mean that VFP8, without "SYS(3099, 70)", will forevermore cease and desist from using a filtered result set as the return for simple Select-SQL statements?

Additionally, does this apply to VFP's engine in general or only to the SQL 'engine'?

Thanks


>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. :)