PureBasic Forums - English

Posted: **Wed Apr 02, 2003 11:55 am**

Restored from previous forum. Originally posted by Bernard.

I'am looking for how to get the recordcount after a DataBaseQuery

Thanks for yours answers

BDu

Posted: **Wed Apr 02, 2003 12:39 pm**

Restored from previous forum. Originally posted by Fangbeast.

id is the record number in database
mydata is the table

Code: Select all


  qry.s = "Select Count(id) as totalrecs from mydata;"
  
  If DatabaseQuery(qry.s)
    While NextDatabaseRow()
      totalrecords = 0
      totalrecords = GetDatabaseLong(0)
    Wend
  EndIf


We are Dyslexic of Borg, prepare to have your ass laminated!

PureBasic Forums - English

Recordcount