softace/sqliteodbc

Support for Recordset type Dynaset ?

Opened this issue · 0 comments

Hello ,

Currently we are using MS Access DB and we are considering migration to SQLite using this (CH Werner's) SQLite ODBC driver.
The code base is using default Recordset type as Dynaset.
When integrated this ODBC driver, I have the following observations.

  1. Dynaset recordset type is not supported
  2. Snapshot recordset type is updatable (AFAIK, conceptually snapshot is read-only)

Is there any means to introduce Dynaset support into this ODBC driver?
With Snapshot type, any means to refresh Recordset members without explicit ReQuery?