Hi vlad the poblem with this code is that if your remote view is fetch as needed
then all the records will be fetched by the reccount(). For large tables this will be a problem.
>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
Alexandre Palma
Senior Application Architect