>Hi all,
>
>I think I'm missing something simple here, so feel free to slap me:
>
>In VFP 6 SP5 (and VFP7), I found out that if SET('ANSI') = ON and SET('EXACT') = ON then a SQL Select will return a result set that contains all of the records in the called table, but you can only "see" the ones that match the WHEN condition. Is this for real? This must be by design but could someone tell me why? I would image that you'd only want the result set to contain the records that matched the WHERE condition...
>
>Thanks,
>
>- Brian

Brian,
When you don't have a true cursor (nofilter clause) SQL might simply set a filter on records (with ANSI on or off). Was that what you mean ?
Cetin