[sqlite] Segmentation fault in sqlite 2.8.15 under windows XP

A simple program like the bellow, gives a SIGSEGV when running with gdb: handle = sqlite_open("testc.db",0,NULL); sqlite_exec(handle,"Create Table Test (Code Integer , Memo Text);",NULL,NULL,NULL); printf("Created Simple Table\n"); sqlite_close(handle); return 0; backtrac

[sqlite] How to retrieve ROWID without explicite request

I'm doing a wrapper of sqlite to freepascal compiler which caches the requested data and uses _ROWID_ to identify the row, so i can properly update the changes made in cached data to the database. The problem with this approach is that the user must explicitely put the _ROWID_ in the field list