Number of Rows in a Database Table

Just starting out? Need help? Post your questions and find answers here.
ClueLess
Enthusiast
Enthusiast
Posts: 360
Joined: Sun Jan 11, 2009 1:04 am

Number of Rows in a Database Table

Post by ClueLess »

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
myutopia
User
User
Posts: 91
Joined: Sat Jul 04, 2009 1:29 am

Post by myutopia »

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 :(
ClueLess
Enthusiast
Enthusiast
Posts: 360
Joined: Sun Jan 11, 2009 1:04 am

Post by ClueLess »

Thanks
Post Reply