Re: [sqlite] Determine if UPDATE has worked.

2009-07-22 Thread Steve Martin
Simon Slavin wrote: >On 22 Jul 2009, at 12:40am, Steve Martin wrote: > > > >>$ fred testdb "create table bob(p1 text PRIMARY KEY, p2 text)" >>SQLITE_DONE: 101 : unknown error >> >> > >You do know this, and all your subsequent commands, will fail if you >still have your data in here from

[sqlite] Determine if UPDATE has worked.

2009-07-22 Thread Steve Martin
Hi List, I am new to sqlite and having trouble determining if an update has worked. I am using the C/C++ API. For an update, when sqlite3_step is executed it returns SQLITE_DONE when a record is updated or if a record does not exist. I have not found an answer by reading and searching the

Re: [sqlite] Determine if UPDATE has worked.

2009-07-21 Thread Steve Martin
Pavel Ivanov wrote: >Did you look into this: http://www.sqlite.org/c3ref/changes.html ? > >Pavel > >On Tue, Jul 21, 2009 at 7:57 PM, Steve Martin wrote: > > >>Hi List, >> >>I am new to sqlite and having trouble determining if an update has worked. >> >>I am using the

Re: [sqlite] Determine if UPDATE has worked.

2009-07-21 Thread Pavel Ivanov
Did you look into this: http://www.sqlite.org/c3ref/changes.html ? Pavel On Tue, Jul 21, 2009 at 7:57 PM, Steve Martin wrote: > Hi List, > > I am new to sqlite and having trouble determining if an update has worked. > > I am using the C/C++ API. > > For an update, when

[sqlite] Determine if UPDATE has worked.

2009-07-21 Thread Steve Martin
Hi List, I am new to sqlite and having trouble determining if an update has worked. I am using the C/C++ API. For an update, when sqlite3_step is executed it returns SQLITE_DONE when a record is updated or if a record does not exist. I have not found an answer by reading and searching the