Re: [sqlite] Trigger's actions and callbacks

2008-04-03 Thread Vladimir Volkov
D. Richard Hipp wrote: > > > SQLite is not reentrant through the update hook. > > > D. Richard Hipp > [EMAIL PROTECTED] > > Thanks a lot. I would consider using user-defined functions as callbacks with updated data in its parameters. -- View this message in context: http://www.nabble.co

Re: [sqlite] Trigger's actions and callbacks

2008-04-03 Thread Vladimir Volkov
Igor Tandetnik wrote: > > >> >> sqlite3_update_hook(db, Callback, db); >> >> and when trying to access to the db inside callback >> >> sqlite3_prepare((sqlite3*)data_arg_3, [...]) > > Show how Callback is declared. Did you really name its first parameter > dat

Re: [sqlite] Trigger's actions and callbacks

2008-04-02 Thread D. Richard Hipp
> > Thanks. But I am experiensing some problems here. When I am using > the same > connection (I store it as third parameter to callback registering > function > > sqlite3_update_hook(db, Callback, db); > > and when trying to access to the db inside callback > >

Re: [sqlite] Trigger's actions and callbacks

2008-04-02 Thread Igor Tandetnik
"Vladimir Volkov" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] >>> sqlite_update_hook() returnes rowID, but I didn't >>> find any API to use this value... > >> You just run a statement along the lines of > >> select * from dbName.tableName where rowid=? > >> You need to run this stat

Re: [sqlite] Trigger's actions and callbacks

2008-04-02 Thread Vladimir Volkov
>If you are trying to use a different connection, you would only see >changes once the first connection committed its transaction - so don't >do that. >> sqlite_update_hook() returnes rowID, but I didn't >> find any API to use this value... >You just run a statement along the lines of >select

Re: [sqlite] Trigger's actions and callbacks

2008-04-01 Thread Richard Klein
> Hi, all. > > I have the following problem: I have some processes that access the same db > file. When one of them would change some data inside the db it must notify > all other processes about change AND send them changed data (or it's unique > description). > > But I didn't find any method t

Re: [sqlite] Trigger's actions and callbacks

2008-04-01 Thread Igor Tandetnik
"Vladimir Volkov" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > I have the following problem: I have some processes that access the > same db file. When one of them would change some data inside the db > it must notify all other processes about change AND send them changed > data (

[sqlite] Trigger's actions and callbacks

2008-04-01 Thread Vladimir Volkov
Hi, all. I have the following problem: I have some processes that access the same db file. When one of them would change some data inside the db it must notify all other processes about change AND send them changed data (or it's unique description). But I didn't find any method to perform this