Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Borislav Borissov
  Where is Borislav Borissov?
 Borislav Borissov
 To: Benny Thomas
  Where is Benny Thomas?
 Saudi Arabia
 Benny Thomas
Subject: RE: _Tally system variable
Thread ID: 416140 Message ID: 416146 # Views: 59 # Ratings: 3
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Monday, December 22, 2014 3:58:26 PM         

> _Tally system variable is supposed to hold the number of recrods affected by the most recently executed table command, including SELECT SQL
> However,
> ? SQLEXEC(oConna, 'Select * from glaccount','mycurs') && selects 172 records
> ? _tally && does not show 172
> SELECT * FROM mycurs
> ? _tally && shows 172
> Why after SQLEXEC _Tally does not work? If it does not work, is there a way to know if the command SELECTed any reocrds?
> Thanks.
> Benny

_TALLY works only on VFP SELECT, not with SQL* functions.
You can use the last parameter of SQLEXEC()?

Borislav Borissov

Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.


_Tally system variable Posted by Benny Thomas @ 12/22/2014 3:31:19 PM
RE: _Tally system variable Posted by Mike Yearwood @ 12/22/2014 3:45:14 PM
RE: _Tally system variable Posted by Borislav Borissov @ 12/22/2014 3:58:26 PM
RE: _Tally system variable Posted by Benny Thomas @ 12/22/2014 9:24:49 PM