Number of records in a SQL-table

[Marc Vanzegbroeck]

Hello,

Does anyone know how to return the number of records in a SQL-table. Something like reccount() in xHarbour.

Thanks,
Marc

[anserkk]

Code: Select all  Expand view

SELECT COUNT(*) AS NumberOfRecords FROM <TableName>

Regards
Anser

[Marc Vanzegbroeck]

Thanks,

But when I do

Code: Select all  Expand view

oQry := oSQL:Execute( "select count(*) AS NumberOfRecords from factui" )

it return True.
Where can I find the result?

Marc

[Carles]

Mark,

Code: Select all  Expand view

oQry := oSQL:Query( "select count(*) AS NumberOfRecords from factui" )

[Marc Vanzegbroeck]

Charles,

If I use

Code: Select all  Expand view

oQry := oSQL:Query( "select count(*) AS NumberOfRecords from factui" )

and shows oQry, it is an Object

Regards,

Marc

[Carles]

Marc,

Try

Code: Select all  Expand view

    oRs := oSQL:Query( "select count(*) AS NumberOfRecords from factui" )

    IF oRs:nRecCount > 0
        MsgInfo( oRs:NumberOfRecords )
    ENDIF
 

[ADutheil]

I do this way:

Code: Select all  Expand view

oQry := oSQL:Execute( "select count(*) AS NumberOfRecords from factui" )
msginfo( oQry:NumberOfRecords)

The term AS in the query create an alias for the result. You can write things like this:

Code: Select all  Expand view

oQry := oSQL:Execute( "select concat(firstname,lastname ) AS Name from mytable where id=nnn" )
msginfo( oQry:Name)
 

[Marc Vanzegbroeck]

Hi,

Thank you for the support.
I'am using the xHarbour and the library http://www2.zzz.com.tw/phpbb2/viewforum ... 99265acf02.
I finaly found how to do it with this library.

I have to use

Code: Select all  Expand view

oQry := oSQL:Execute( "select count(*) AS NumberOfRecords from factui" )
msginfo( oQry:data[1,1])

What type of library do you use?

Regards,
Marc

[ADutheil]

I use TDolphin with MySQL.

[ShumingWang]

(x)Harbour +Fwh+harbour\contrib\Tmysql.prg

oquery:=oserver:query("select ifnull(count(*),0) count from atable ")
? oquery:count
or ? oquery:fieldget(1)

oquery:end()

If you use Mysql server innodb storage engine, you'd better avoid use count(*) function ,that will get slower , for there is no a real count to recoder innodb table ,Mysql must do count every records /rows.

Regards!
Shuming Wang