A note on prepared statements. They are actually a complete Sqlite
virtual machine context, so you can have many of them current at any
time. You just have to execute them serially.
JS
[EMAIL PROTECTED] wrote:
Hi to all
...meet another problem... ;-)
Is it possible to open more than one active Recordset connect
to a single-opened Database? This means, that I want to open
the Database one times in a initial Function of the App. And
then followed, i want to open more as one Recordset connected to
this openend Database at the same time (...to read and write and
manipulate the Data-Tables and after work close the Recordsets).
The actual problem is, first I opened my Database, then open a
Table-Recordset to fill in a View. Then I Execute a "Delete from...."
to the Database used by the primary Database-Connection, but create
a new/another (temporary) sqlite3_stmt *pExecRecordset to perform
it. I think, that the primary Recordset is not Dynamic,
also it don't know this Delete. Okay, thats not the problem.
It doesn't work. How is the error? If I perform the Delete
separately without a "concurrent" Recordset it works well.
Have I open allways a Database-Connection for each Recordset?
I think, that cannot be. In a Dialog-App a User performs permanet
changes to the fieldvalues of the present recordset and sends
permanent a SQL-Update to the DB.
Many Thanks for help and Greetings
Anne
