Thanks Dennis for your reply.
I would like to avoid triggers for performance reasons.
I haven't found an official solution so I am implementing my own
sqlite3_update_notify API that is executed before the operation takes
place.
---
Marco Bambini
http://www.sqlabs.net
http://www.sqlabs.net/bl
Marco Bambini wrote:
with sqlite3_update_hook I can get the rowid of the row AFTER it has
been INSERTed, DELETEd or UPDATEd.
Is there a way to get the rowid of a row BEFORE it is DELETEd or
UPDATEd ?
If not, can someone suggest a good approach to this problem?
Marco,
You can use a "before
Make the hook queue a GUI update transaction and execute those
transactions following the COMMIT. Discard the list of GUI update
transactions on a ROLLBACK.
Jef Driesen wrote:
I was planning to use the sqlite3_update_hook function to notify my GUI
about changes. The idea was that every part o
Jef Driesen <[EMAIL PROTECTED]> wrote:
>
> I think that approach should work. But the function sqlite3_commit_hook
> is marked experimental in the documentation. What does that means? Is it
> safe to rely on it?
>
"Experimental" means that we reserve the right to change it in
future releases o
On Mon, 2007-03-12 at 10:51 +0100, Jef Driesen wrote:
> I was planning to use the sqlite3_update_hook function to notify my GUI
> about changes. The idea was that every part of the GUI can update itself
> when a database change is detected. But during testing, I encountered
> some problems with thi
A wise computer scientist once told me "In Computer Science every
problem can be solved by yet another level of indirection". Your
problem is no exception.
JS
Cameron Tofer wrote:
The rowid of the table's record in the sqlite_master table would be
great, but really any unique integer that I c
Cameron Tofer wrote:
The rowid of the table's record in the sqlite_master table would be
great, but really any unique integer that I can later use to get the
table's name would be fine.
Cameron,
Then you should be able to execute the following SQL query in your
sqlite3_update_hook handler
The rowid of the table's record in the sqlite_master table would be
great, but really any unique integer that I can later use to get the
table's name would be fine.
Dennis Cote wrote:
Cameron Tofer wrote:
Hi,
I'd like to modifiy sqlite3_update_hook so the callback returns
the table's id
Cameron Tofer wrote:
Hi,
I'd like to modifiy sqlite3_update_hook so the callback returns the
table's id instead of the table's name. I'm not worried about
proposing any official changes to the spec but rather a small
customization for myself. Can anyone point me in the right direction
f
9 matches
Mail list logo
