#1 SQLRowCount & MS Access

[Anonymous]

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...