On Feb 13, 2006, at 1:35 PM, Me wrote:

I'm guessing you're using sqlite3_step(sqlite3_stmt*);

Yes, with SQLite3ProfessionalPlugin you have full access to the underline sqlite virtual machine.

Can you iterate through a query and update the same table at the same time?

Yes, sure.

In other words, is the table locked to prevent writes until the query is done?

No, it is unlocked.

---
Marco Bambini
http://www.sqlabs.net
http://www.sqlabs.net/blog/


----- Original Message -----
If you are interested in how to perform blazing fast queries with RB and your sqlite 3 database, I have posted some information about this new upcoming technology in my blog: http:// www.sqlabs.net/blog/

I am sure it can be quite useful to someone.
---

_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>

Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>

Reply via email to