DatabaseRows()

[Flype]

About Database functions, in PHP language we can do :

Code: Select all

$nbresult = mysql_num_rows($result)

A native DatabaseRows() function could be useful for counting the number of rows after a DatabaseQuery(). DatabaseColumns() exists so why not for Rows.

Code: Select all

Procedure.l DatabaseRows()
  Protected i
  i=0
  While NextDatabaseRow()
    i+1
  Wend
  ProcedureReturn i
EndProcedure

If DatabaseQuery("select * from test;")
  Debug DatabaseRows()
Else
  Debug DatabaseError()
EndIf

[Manol]

Code: Select all

#Database=0
Name$="You DataBase Name"
InitDatabase()
OpenDatabase(#Database, Name$, User$, Password$)
DatabaseQuery("select COUNT(*) from test;")
If DatabaseError()
Debug "Error"
Else
NextDatabaseRow() 
  Debug GetDatabaseLong(0)
EndIf 
  

[Flype]

thank you man.
but i need to count lines by myself on some special sql request where COUNT(...) doesn't work as wanted.