[sqlite] UPDATE problem.

2009-11-22 Thread lilezek
Hi. I'm using SQLite in my own c++ aplication. Everything works except if I try to do this query: UPDATE rnc_accounts SET lastip = '127.0.0.1' WHERE name = 'lilezek'; But when I do step I got always 5 (SQLITE_BUSY). You'll think the problem is mine, but I change the query to the next one: SELE

Re: [sqlite] UPDATE problem.

2009-11-22 Thread Igor Tandetnik
lilezek wrote: > Hi. I'm using SQLite in my own c++ aplication. Everything works except if I > try to do this query: > > UPDATE rnc_accounts SET lastip = '127.0.0.1' WHERE name = 'lilezek'; > > But when I do step I got always 5 (SQLITE_BUSY). You'll think the problem is > mine, but I change the

[sqlite] Set error message within virtual table implementation?

2009-11-22 Thread WClark
Hi, Is it possible / can it be possible to set the error message (as would then be read by a call sqlite3_errmsg) from within a virtual table implementation. For example, inside the xUpdate function when some constraint violation has occurred, to give a more accurate error message than the de

Re: [sqlite] Set error message within virtual table implementation?

2009-11-22 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 wcl...@gfs-hofheim.de wrote: > Is it possible / can it be possible to set the error message (as would > then be read by a call sqlite3_errmsg) from within a virtual table Yes, see the zErrMsg member: http://sqlite.org/c3ref/vtab.html If non-null