Re: [sqlite] Open multiple Recordsets

2006-05-20 Thread Anne . Kirchhellen
Hi Dennis Thanks for your answer. You have see my problem and its solution. I look sometimes at SQLite with my "OLE-DB"-Eyes. In OLE-DB is the Recordset Reader and Writer allways at the same time. Now I consider this... and it works fine. Greetings, Anne > I think you are saying you have a

Re: [sqlite] Open multiple Recordsets

2006-05-18 Thread Dennis Cote
[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

Re: [sqlite] Open multiple Recordsets

2006-05-18 Thread John Stanton
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 ac

Re: [sqlite] Open multiple Recordsets

2006-05-18 Thread John Stanton
An Sqlite database is a single file, and it needs to be locked whenever it is being altered. That means that only one process/thread can access the database at any one time. If you open it twice you get no benefit. You have to design your application such that multiple users have some way of

[sqlite] Open multiple Recordsets

2006-05-18 Thread Anne . Kirchhellen
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