Hi,

I am still struggle with my insert statement with bound parameters  
that - followed step by step in the VDBE - seems to be inserted but
is not available after closing the database. (Checked with sqliteman)

I have also created a small test application using my database API  
wrappers. In this sample I could insert the data, thus I cannot recreate
the problem in a small application.

Problem:

I prepare an insert statement and bind the parameters that afterwards  
get executed with sqlite_step(). This function then returns SQLITE_DONE
and I prepare a new select statement wich let me display the just  
inserted data in my database forms (database file not closed while  
that).

I do a close of the database, have a breakpoint after that to see what  
sqliteman tells me:

The table is empty and no jornal file is opened !

How can it be, that

1.)     The insert statement succeeds (have been able to select them with  
a new statement while database is still opened) ?

2.)     The engine doesn't store these changes, even I have seen these  
changes (I do not manually start a transaction that wouldn't be  
committed) ?

Does someone have any more ideas how to narrow the problem ?
(After the insert statement until to closing of that file)

Thanks in advance,

Lothar

-- | Rapid Prototyping | XSLT Codegeneration | http://www.lollisoft.de
Lothar Behrens
Heinrich-Scheufelen-Platz 2
73252 Lenningen








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

Reply via email to