Menu

#1 SQLRowCount & MS Access

open
nobody
None
5
2001-03-15
2001-03-15
Anonymous
No

The SQLRowCount used by getNumRows returns the number of rows affected by an UPDATE, INSERT or DELETE query. Most drivers also returns the number of rows returned by a SELECT query, but not all (and not MS Access).

The 'simple' example provided with the Data Widget Library creates a select query on a table and displays controls to browse the records contained in the table. The controls enable / disable themselves according to the number of rows, returned by getNumRows. That leads to a problem with MS Access cause SQLRowCount returns -1.

What has to be fixed ? The example ? The whole library ? I'm open to all suggestions...

Discussion


Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.