This doesn't seem to be a D problem.  I re-implemented it in C and got the same error.

On 09/18/2013 02:00 PM, Charles Hixson wrote:
> I'm trying to use SQLite3 in D, but am getting a segmentation fault when I attempt to replace the exec statement with a prepare statement.  What am I doing wrong?
>
> If the prepare statement is commented out, and the exec statement is uncommented, the program runs successfully.  (There's no data yet in the database file.)
>
> The test program is:
>
> pragma    (lib, "sqlite3");
>
>
> import    etc.c.sqlite3;
> import    std.exception;
> import    std.stdio;
> import    std.string;
>
> /**    int function(void*, int, char**, char**) callback    */
> extern(C)
> int    callback    (void* notUsed, int argc, char** argv, char** azColName)
> {
>     for    (int i = 0;    i < argc;    i++)
>     {    printf ("%s = %s\n", azColName[i], argv[i] ? argv[i] : "null");    }
>     printf    ("\n");
>     return    0;
> }
>
> void    main()
> {    sqlite3*    db;
>     int        rc;
>     char*        zErrMsg    =    null;
>     sqlite3_stmt**    stmt;
>
>     rc    =    sqlite3_open (toStringz("data/sqlitetest.db"), &db);
>     if    (SQLITE_OK != rc)
>     {    printf ("DB create error: %s\n", sqlite3_errmsg(db) ); }
>
>     string    sql    =
>         "create table if not exists wrds (name text primary key, id int)\0";
>     rc    =    sqlite3_exec(db, sql.ptr, &callback, cast(void*)0, &zErrMsg);
>     if    (SQLITE_OK != rc)
>     {    printf ("DB create table error: %s\n", sqlite3_errmsg(db) );
>         printf    ("sql = <<%s>>\n", sql);
>     }
>
>     sql    =    "select * from wrds\0";
>     rc    =    sqlite3_prepare(db, toStringz(sql), cast(int)sql.length, stmt, null);
> //    if    (SQLITE_OK != rc)
> //    {    printf ("DB prepare statement error: %s\n", sqlite3_errmsg(db) );
> //        printf    ("sql = <<%s>>\n", sql);
> //    }
> //    rc    =    sqlite3_step(*stmt);
> //    if    (SQLITE_OK != rc)
> //    {    printf ("DB statement step error: %s\n", sqlite3_errmsg(db) );
> //        printf    ("sql = <<%s>>\n", sql);
> //    }
> //
> //    rc    =    sqlite3_exec(db, sql.ptr, &callback, cast(void*)0, &zErrMsg);
> //    if    (SQLITE_OK != rc)
> //    {    printf ("DB select error: %s\n", sqlite3_errmsg(db) );
> //        printf    ("sql = <<%s>>\n", sql);
> //    }
> //
>     rc    =    sqlite3_close    (db);
>     enforce    (rc == SQLITE_OK);
> }
>


-- 
Charles Hixson