PureBasic Forums - English

How can I get the number of rows in a MSAccess database table (or 0 if table is empty) using the natibe PB database functions?

Thanks

You can't. You have the use the native MSAccess database SELECT command to return that value.

For example, in SQLite, it is "SELECT COUNT(*) FROM table;". The result is then retrieved by GetDatabaseLong() or GetDatabaseString(). I don't know MSAccess, so you're gonna have to do some research there. Sorry

Thanks