Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Benny Thomas
  Where is Benny Thomas?
 Jeddah
 Saudi Arabia
 Benny Thomas
 To: Borislav Borissov
  Where is Borislav Borissov?
 Sofia
 Bulgaria
 Borislav Borissov
 Tags
Subject: RE: _Tally system variable
Thread ID: 416140 Message ID: 416162 # Views: 41 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Monday, December 22, 2014 9:24:49 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.

Thanks a lot Mike and Borislav.

Benny

ENTIRE THREAD

_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