>On a plain Select-SQL VFP does not alway create a new table, it sometimes (based on
>how you structured your SQL) just does a filter over the source table.
>
>To test this do:
> SELECT * FROM -tablename- INTO CURSOR fTest
> SELECT fTest
> ? DBF()
>
>-myron kirby-
>===================================
In VFP5 use the NOFILTER clause of SELECT-SQL to prevent this behavior.
...snip
Ned Ames
Ned
Reality is.