>One method that works for me is to check the value of _TALLY against the RECCOUNT() of the cursor immediately after a SQL Select, if they are not the same, and there's a WHERE clause that should eliminate some set of records from the table it's a filtered view...more to the point, if the table name returned by DBF() matches the table name of the alias selected from, then the result is a filtered view:
>
>USE MyTable ALIAS Foo
>SELECT * FROM Foo INTO BAR
>? DBF('Bar') == DBF('Foo')
Quite so, I just discovered this technique too...
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.