On 24 Sep 2014, at 12:36pm, Nathaniel Trellice <napt...@yahoo.co.uk> wrote:

> The example code, below, highlights the problem I'm having. The code creates 
> a table with a bound default value for one of the two columns. The statement 
> is prepared (no syntax error warning), and the value bound successfully. But 
> upon inserting a row that requires using the default parameter, it crashes in 
> function sqlite3ExprCodeTarget(). (Inserting a row with both column values 
> explicitly set works fine.)

Can you split your program into two ?

Use your code to create the table in the first place but not do the INSERT.

Then use the SQLite shell tool to open the resulting database and look at the 
schema (perhaps use the command '.schema').  Check to see that the schema is 
what you'd expect it to be.

Then use the SQLite shell tool to INSERT some lines and see whether the shell 
tool crashes.

If the shell tool crashes we have a 100% repeatable case where the SQLite 
development team have all the source code.  It would be very easy to debug.

If the shell tool doesn't crash then the problem is probably somewhere in your 
own code rather than in SQLite.  This doesn't mean nobody will help you, but it 
makes it easier to see where the problem is.

Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to