Zeoslib Portal

Posted: **28.04.2010, 15:03**

HI all

I have bizarre issue with zeos 7-sqlite3 and delphi 2009 :
I use TZTABLE to populate data, but i can't insert or update data, when i run the exe and add some data all show fine in data control, but when i close the exe all data inserted is lost.
i try to use start transact, commit but the same issue
so what is the solution ?
this is sql log
You remark last line the data is insert in the table,but all is lost when i shatdown this program

Code: Select all

2010-04-28 01:14:22 cat: Execute, proto: sqlite-3, msg: PRAGMA  table_info('userprofile')
2010-04-28 01:27:03 cat: Connect, proto: sqlite-3, msg: CONNECT TO "./data/mustpost.db3" AS USER ""
2010-04-28 01:27:03 cat: Execute, proto: sqlite-3, msg: BEGIN TRANSACTION
2010-04-28 01:27:03 cat: Execute, proto: sqlite-3, msg: SELECT * FROM forum_link

2010-04-28 01:27:03 cat: Execute, proto: sqlite-3, msg: PRAGMA  table_info('forum_link')
2010-04-28 01:27:03 cat: Execute, proto: sqlite-3, msg: SELECT * FROM forum_categorie

2010-04-28 01:27:03 cat: Execute, proto: sqlite-3, msg: PRAGMA  table_info('forum_categorie')
2010-04-28 01:27:03 cat: Execute, proto: sqlite-3, msg: SELECT * FROM Post

2010-04-28 01:27:03 cat: Execute, proto: sqlite-3, msg: PRAGMA  table_info('Post')
2010-04-28 01:27:03 cat: Execute, proto: sqlite-3, msg: SELECT * FROM settings

2010-04-28 01:27:03 cat: Execute, proto: sqlite-3, msg: PRAGMA  table_info('settings')
2010-04-28 01:27:03 cat: Execute, proto: sqlite-3, msg: SELECT * FROM userprofile

2010-04-28 01:27:03 cat: Execute, proto: sqlite-3, msg: PRAGMA  table_info('userprofile')
2010-04-28 01:27:33 cat: Execute, proto: sqlite-3, msg: [rainbow][bcolor=#FF4000]INSERT INTO userprofile (Id,UserLogin,UserPassword,UserEmail,Usersign,Usersignimag,Lastdatused,avatare,signate) VALUES (NULL,'mustdev','Pmma66','mustdev@menara.ma',NULL,NULL,NULL,NULL,NULL)
2010-04-28 01:27:34 cat: Execute, proto: sqlite-3, msg: COMMIT TRANSACTION[/bcolor][/rainbow]

thanks for any quick speed

Posted: **01.05.2010, 21:06**

Reading this log I would say : impossible

But as I asume most users are sane, we'll have to search deeper.

Have you tried to select the inserted line after the commit, but before the connection is closed?

Mark

Posted: **04.05.2010, 00:02**

thanks for replay
and excuse me for my late to answer, yes i have tried this , and th inserted data show in program (grid and edit components for all this project i use registered last tms pack my customer like it) but when i close the program and lunch my sqlite admin program ( i use sqlite2009 pro and sqlitestudio-1.1.1) i find that all inserted data has disparate, also i have last sqlite library in my windows path, i spend this 4 day with this issue without any success,there is no idea about this issue, i don't like to change zeos for any other sqlite library, i use zeos in all my project with Mysql and i have no problem with it first time i use it for sqlite database.
thanks

Posted: **12.05.2010, 20:43**

es i have tried this , and the inserted data show in program

Does this mean 'Table.close;table.open' and then the data is still visible? So in the log after the commit a new select is executed and retrieves the inserted data?

In that case my only remaining idea is that the file consulted using 'sqlite2009 pro' is a different one as the one used by your program. Which is very possible as I see you're using a linux like path on windows and I don't know how that behaves exactly.

Do you have a simple sample project (source + sqlite dll) you can send me (or attach to this post)?

Mark

Zeoslib Portal

ZEOS 7 AND SQLITE3 DON'T POST DATA

ZEOS 7 AND SQLITE3 DON'T POST DATA