Yes, that user was myself. I did add also that this can't be reproduced with sqlite3.exe. Thank you Ralph for your assistance and explanation! Regards, R.Antloga----- Original Message ----- From: "Delphi Inspiration" <delphi@xxxxxxxx>
To: <yunqa@xxxxxxxxxxxxx>; <yunqa@xxxxxxxxxxxxx> Sent: 1. junij 2009 12:21 Subject: [yunqa.de] Re: SQLite metadata
At 14:14 31.05.2009, Delphi Inspiration wrote:At 16:06 30.05.2009, Radovan Antloga wrote:I use descendent from TDISQLite3Database because I have properties like CreateIfNotExists, PageSize, Pragma, etc. Only difference I see that my component execute pragmas after connect. So I modified your test. I just execute pragma synchronous=full. I know default is full but it can change so this should not be problem.I can confirm your findings in both Delphi and C code. This makes me believe that it is probably a bug in SQLite.I sent bug ticket to the SQLite developers and will keep you posted on any responses.As it stands now, the chief SQLite3 developer (drh) does not regard this as a bug. See his explanation athttp://www.sqlite.org/cvstrac/tktview?tn=3890Please also note that at least one other SQLite user sees the current behaviour as problemeatic. Please feel free to add your opionions and arguments to the discussion!Ralf
_______________________________________________ Delphi Inspiration mailing list yunqa@xxxxxxxxxxxxx //www.freelists.org/list/yunqa