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<steve.mar...@nec.co.nz> 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 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 documentation and searching the >>internet >> >>This is the same for the command line tool. >> >>Using code based on "http://www.sqlite.org/cvstrac/wiki?p=SimpleCode"; >> >>$ fred testdb "create table bob(p1 text PRIMARY KEY, p2 text)" >>SQLITE_DONE: 101 : unknown error >>$ fred testdb "insert into bob (p1, p2) values('foo', 'sue')" >>SQLITE_DONE: 101 : unknown error >>$ fred testdb "insert into bob (p1, p2) values('foo', 'sue')" >>Error: 19 : constraint failed >>$ fred testdb "update bob set p2 = 'fred' where p1 = 'foo'" >>SQLITE_DONE: 101 : unknown error <-- update ok >>$ fred testdb "update bob set p2 = 'fred' where p1 = 'fo1'" >>SQLITE_DONE: 101 : unknown error <-- update fail >>$ fred testdb "select count(*) from bob" >>count(*) = 1 >>SQLITE_DONE: 101 : unknown error >>$ fred testdb "select * from bob" >>p1 = foo >>p2 = fred >>SQLITE_DONE: 101 : unknown error >>$ >> >>When using the command line tool. >>SQLite version 3.6.16 >>Enter ".help" for instructions >>Enter SQL statements terminated with a ";" >>sqlite> create table bob(p1 text PRIMARY KEY, p2 text); >>sqlite> .header on >>sqlite> .show >> echo: off >> explain: off >> headers: on >> mode: list >>nullvalue: "" >> output: stdout >>separator: "|" >> width: >>sqlite> update bob set p2 = 'fred' where p1 = 'foo'; >>sqlite> insert into bob (p1, p2, p3) values('foo', 'sue', 'todd'); >>SQL error: table bob has no column named p3 >>sqlite> insert into bob (p1, p2) values('foo', 'sue'); >>sqlite> select * from bob; >>p1|p2 >>foo|sue >>sqlite> update bob set p2 = 'fred' where p1 = 'foo'; >>sqlite> select * from bob; >>p1|p2 >>foo|fred >>sqlite> update bob set p2 = 'fred' where p1 = 'fo1'; >>sqlite> >> >> >>Thanks >>Steve >> >> >> >> Hi Pavel,
Thanks for the info, that works for me. Steve _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
