Try this
; Use database from help
Query$ = "select * from food where weight > 7 "
; Get count of rows
Rowcount.i = 0
If DatabaseQuery(0, "select count(*) as rowscount from (" + Query$ + ") as myRowsCount")
NextDatabaseRow(0)
Rowscount = GetDatabaseLong(0, 0)
FinishDatabaseQuery(0)
EndIf
Debug ...
Search found 1 match
- Tue Jun 07, 2022 12:38 am
- Forum: Feature Requests and Wishlists
- Topic: DatabaseRows()
- Replies: 10
- Views: 3674