Extra SQLitening functions

[Ivan Iraola]

These 4 functions will allow you to get some Row, Table or Database info quickly.


1- slGetNumRowsFound(Query$) : It will get the number of matches found according to a SELECT, DELETE or UPDATE query without making any changes to the database.

Code Select Expand


   Query$ = "SELECT * FROM DVD-Collection WHERE [Genre] = 'Zombies'"

   Result& = slGetNumRowsFound(Query$)



2- slGetNumRowsInDatabase : Get the total of rows in the database.

Code Select Expand


   slOpen "MyDatabase.db3", "E0"

   Rows& = slGetNumRowsInDatabase



3- slGetNumRowsInTable(TableName$) : Get the number of rows in the indicated table.

Code Select Expand


   slOpen "MyDatabase.db3", "E0"

   Rows& = slGetNumRowsInTable("Projects")



4- slGetTableCount : Get the number of tables in the database.

Code Select Expand


   slOpen "MyDatabase.db3", "E0"

   Tables& = slGetTableCount



I hope you find them useful