Re: [sqlite] escape quote for csv import

Hi > (There is no official CSV standard, and there is no widely supported escaping > mechanism.) Refer to RFC4180 for CSV standard. Steve Martin Technical Lead NEC New Zealand Limited NEC House, Level 6, 40 Taranaki Street, PO Box 1936, Wellington 6140, New Zealand T: 043816

Re: [sqlite] Determine if UPDATE has worked.

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, w

[sqlite] Determine if UPDATE has worked.

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.

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

[sqlite] Determine if UPDATE has worked.

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