total number of records in a sqlite3 table?

[alihady]

How can I determine the total number of records in a sqlite3 table?
thanx

[reteset]

take a look at this page about SELECT COUNT

[alihady]

how to make it in sqlite3 plugin.?

[reteset]

Row = Query("SELECT COUNT(*) AS TotalRecords FROM table_name")

total = Row.TotalRecords

Query = the function that executes select query
Row = the fetched record-set (single row)

Row.TotalRecords = in above query we assign total records to an alias called 'TotalRecords'
so it becomes the first column name

and the table_name is the name of table you want count records of

[alihady]

thanks retest