_tally

The place to discuss the development of dynamic web sites and applications with PHP and MySQL. Many ProMatrix users are moving to new development technologies. This is one alternative.

_tally

Postby stecenko » Tue Sep 04, 2012 5:34 pm

Can some one confirm this for me?

In VFP if you perform a SQL select and no records are found, then _tally is zero.

However, with MySQL and MsSQL, if no records are found, there seems to be one empty record in the cursor and _tally is one.

Is this true?

Instead of testing after a select with

if _tally=0

I've been using

if empty(table.PrimaryKey)


It seems to work, but I'm just a bit nervous.
Richard Stecenko
Interactive Computer Services Inc.
Victoria, British Columbia
204.453.2052
stecenko
 
Posts: 822
Joined: Mon Jun 21, 2010 8:06 pm
Location: Saanich, British Columbia

Re: _tally

Postby DavidLeMesurier » Sun Sep 09, 2012 4:06 am

I think in vfp if you have a sum in the sql then you will get one record returned
DavidLeMesurier
 
Posts: 82
Joined: Sun Jun 13, 2010 12:43 am
Location: Dubai


Return to PHP and MySQL

Who is online

Users browsing this forum: No registered users and 1 guest

cron