Hi!

_Tally will not be set for remote views. Thus it is not recommended to use _Tally for views when you plan to move to SQl Server or other database in the future. You can use following:

if requery('MyView')=1 AND reccount('MyView')>0
...
endif



>Hello,
>
>1.) When I perform a requery() on an SQL-View from the command window then _tally is updated.
>2.) If I perform a requery() from inside an EXE I seem to (sometimes) run code that is unexpected based on the _tally value.
>3.) The Hacker's Guide doesn't list requery() as one of the items that affects _tally.
>
>I guess I should switch to reccount() to determine if requery() returns and records from a view.
>
>Thanks,
>
>Kevin