If WHERE clause of select statement is optimazable and only fields from the table is requested, foxpro opens FROM table with AGAIN clause and ALIAS . If subset of the fields is requested than SET FIELDS command used to show only those fields. ? DBF() will return original table name in this case. There's NOFILTER clause that forces foxpro to create cursor as temporary table.
>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