Databases
StackOverflow2013
Postsdbo
POPreparing statements in SQLite3 using the C++ API always fails
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POPreparing statements in SQLite3 using the C++ API always fails
    primarykey
    data
    text
    <p>Preparing a SQL stament using <code>sqlite3_prepare_v2()</code> always returns error code <code>SQLITE_MISUSE</code>. Although I read my code about a thousand times, I couldn't find any error. Here's a MWE. </p> <pre><code>#include &lt;sqlite3.h&gt; int main() { int rc = sqlite3_initialize(); sqlite3 *db = NULL; // Constant name of the database. const char* dbName = "symplectic.db"; // We open the database file and initialize the pointer to it. int errorCode; errorCode = sqlite3_open_v2(dbName, &amp;db,SQLITE_OPEN_READWRITE,NULL); errorCode = sqlite3_exec(db, "CREATE TABLE IF NOT EXISTS TBIntegrators \n" "(" "IndexIntegrator INTEGER PRIMARY KEY AUTOINCREMENT, \n" "INTDescription CHARACTER(8), \n" "INTOrder INTEGER, \n" "INTStepsizeType INTEGER \n" "); \n" "INSERT INTO TBIntegrators (INTDescription, INTOrder, INTStepsizeType) VALUES ('RK4',4,0);\n" "INSERT INTO TBIntegrators (INTDescription, INTOrder, INTStepsizeType) VALUES ('SIFS4',4,0);\n" "INSERT INTO TBIntegrators (INTDescription, INTOrder, INTStepsizeType) VALUES ('SIFS8',8,0);\n" "INSERT INTO TBIntegrators (INTDescription, INTOrder, INTStepsizeType) VALUES ('SIVS4-1',4,1);\n" "INSERT INTO TBIntegrators (INTDescription, INTOrder, INTStepsizeType) VALUES ('SIVS8-1',8,1);\n" "CREATE TABLE IF NOT EXISTS TBSimuInstance\n" "(" "IndexSimuInstance INTEGER PRIMARY KEY AUTOINCREMENT,\n" "SIMIndexIntegrator INTEGER REFERENCES TBIntegrators (IndexIntegrator));\n" "CREATE TABLE IF NOT EXISTS TBData\n" "(" "IndexData INTEGER PRIMARY KEY AUTOINCREMENT,\n" "DATIndexSimuInstance INTEGER REFERENCES TBSimuInstance (IndexSimuInstance),\n" "DAT_TimeInPeriods UNSIGNED BIG INT,\n" "DATPosX DOUBLE,\n" "DATPosY DOUBLE,\n" "DATMomX DOUBLE,\n" "DATMomY DOUBLE \n" ")", NULL, NULL, NULL); rc = sqlite3_prepare_v2(db, "INSERT INTO TBSimuInstance (SIMIndexIntegrator) VALUES (:int)", -1, &amp;insertInstance, NULL); return 0; } </code></pre> <p>The last <code>rc</code> always comes back as <code>SQLITE_MISUSE</code>, but the SQL is legal (I tested it in the command line interface). I also removed any <code>_</code> characters, thinking that my SQL command strings were not properly escaped. </p> <p>Anyhow, am I missing something stupid?</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USJoey Dumont
    1. USJoey Dumont
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POPreparing statements in SQLite3 using the C++ API always fails
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POPreparing statements in SQLite3 using the C++ API always fails
      1. This table or related slice is empty.
      1. VTModeratorReview
    1. COI'm not entirely sure but maybe try to escape your statements. If you use ' without escape you can run into trouble. Maybe sqlite3_exec is doing that by default but if not I remember there is a method which can do this and works similar to printf.
      singulars
      1. POPreparing statements in SQLite3 using the C++ API always fails
      1. This table or related slice is empty.
    2. COMWE? Did that actually even compile with no `errorcode` defined? Or is your definition of MWE slightly different to mine? :-) In addition, I'm not certain NULL is a valid db handle.
      singulars
      1. POPreparing statements in SQLite3 using the C++ API always fails
      1. USpaxdiablo
    3. CO@paxdiablo I corrected it. It was copy-pasted from my real code. Technically, the `sqlite3_open()` makes the pointer `sqlite3 *db = NULL` point to the database. I followed the syntax used in the O'Reilly book on SQLite.
      singulars
      1. POPreparing statements in SQLite3 using the C++ API always fails
      1. USJoey Dumont
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload