Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
_TALLY = 0 ???
Message
From
30/12/1999 13:55:46
 
 
To
30/12/1999 13:46:07
Jorge Haro
Independent Consultant
Juarez, Mexico
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00310544
Message ID:
00310590
Views:
18
>Thanks, I wasn't aware of that, although all the others are working and also using remote views, I started using _tally recently and I hadn't detected any problems. For this particular case reccount() or !eof() will do I guess, thanks again.
>

LOCATE followed by a ! EOF(), rather than RECCOUNT(), for a number of reasons, the easiest to explain being the situation where you end up with a filtered view of a table from a SQL Select; regardless of the number of applicable number of records, RECCOUNT() returns the total number of records in the underlying table.

>>Use reccount(), NOT eof(), etc. You can not use _tally because VFP does not update this variable in this circumstance. There are too many IFs on when VFP _tally is or is not updated to go into. Generally, _Tally gets updated only when you do something locally.
EMail: EdR@edrauh.com
"See, the sun is going down..."
"No, the horizon is moving up!"
- Firesign Theater


NT and Win2K FAQ .. cWashington WSH/ADSI/WMI site
MS WSH site ........... WSH FAQ Site
Wrox Press .............. Win32 Scripting Journal
eSolutions Services, LLC

The Surgeon General has determined that prolonged exposure to the Windows Script Host may be addictive to laboratory mice and codemonkeys
Previous
Reply
Map
View

Click here to load this message in the networking platform