Re: [sqlite] Cannot we reuse an sqlite3_stmt to insert multiple rows ?

Pyramide-Ingenierie Developer List wrote: Hello, I am using SQLite 3.3.8 library on Mac OS X using XCode 2.4.1 (gcc 4.0)... I try to compile only once an SQL instruction like "INSERT INTO Book (author_fk,title,date,time,price,created) VALUES (?,?,?,?,?,?);" and insert multiple rows through

[sqlite] Cannot we reuse an sqlite3_stmt to insert multiple rows ?

Hello, I am using SQLite 3.3.8 library on Mac OS X using XCode 2.4.1 (gcc 4.0)... I try to compile only once an SQL instruction like "INSERT INTO Book (author_fk,title,date,time,price,created) VALUES (?,?,?,?,?,?);" and insert multiple rows through a (sqlite3_bind_xxx /