With a switch, naturally, to keep backwards compatibility.

>I have mixed feelings about this. It would have to be a switch if it was changed.
>
>
>>Thanks. Is it just me or does this sound like a good item to place in the wish list?
>>
>>Alex
>>
>>>You can't. If you need to do this then you will have to use the procedural way such as scan endscan.
>>>
>>>>How to perform a SQL select on a buffered table that will take into account buffered records: Does anybody have a solution that does not involve starting a transaction, tableupdating, running select and then reversing transaction?