Recordcount

[BackupUser]

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

[BackupUser]

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!