Lazarus
Announcements => Third party => Topic started by: Zaher on August 25, 2010, 03:31:36 am
-
We uploaded a Dll build of SQLite3 for WINCE ARM4
sqlite3-3.6.23.1-wince-arm.zip
sqlite3-3.7.0.1-wince-arm.zip
http://www.parmaja.com/pages/31
-
Is there any chance to build sqlite 3.7.11 for WinCE ?
Thank You
-
Check
http://www.parmaja.com/downloads/sqlite3/
Oh, 11, there has been new version recently!, I will try to build it soon.
Check also
http://www.parmaja.com/pages/31
-
New file uploaded, I have not tested it, please download and test.
-
A lot of thanks - I'll try it.
-
Hi Zaher,
I'd tested latest build (3.7.11) you make and it is working ok - thx, again.
Is there any chance to build sqlite 3.7.12 for WinCE ?
Thank You
-
Sure :)
http://www.parmaja.com/downloads/sqlite3/
Test it please.
-
I also uploaded new file sqlite3.7.12.1-arm-wince.zip check it.
-
Thank you a lot - keep good work.
-
Hi Zaher,
I'm using latest build you posted 3.7.12.1 and it is working ok.
Is there any chance to build latest sqlite 3.7.13 for WinCE ?
Thank You
-
Done, please test it.
I'm using latest build you posted 3.7.12.1 and it is working ok.
Good to hear that :D, because i my customers not upgraded yet, so i cant test it, i will do that soon.
sqlite3.7.13-arm-wince.zip (http://www.parmaja.com/downloads/sqlite3/)
-
Hi Zaher,
You can guess ;)
Can you upload a 3.7.14.1 version ?
Thank you
-
Yep, but i have some troubles to connect my PC to the internet this days, you can wait ;-)
-
Please test the new version in the same download directory, have fun :)
http://www.parmaja.com/downloads/sqlite3/
-
Thank you Zaher,
I've already put it on test on few devices and it working just fine.
Keep good work.
-
Hi Zaher,
When you manage to spare some time, it will be very nice to build latest SQLite (3.7.15.2).
Thx
-
Why not :D
Try it
http://www.parmaja.com/downloads/sqlite3/
-
Thx for latest build SQLite (3.7.16.1).
-
I have problems using 3.7.16.1 - did you tried ?
-
no yet, what problems?
-
i have tested it with Windows mobile 6 in SQLViewer only "select" statments.
Maybe more details can help me.
-
I have problems with SQL update - same exe work with SQLIte 3.7.15.2.
Do you use locate to find data in SQLQuery ?
I've noticed there is a problem with it on WInCE.
-
try it in Win32, use last SQLITE dll
and u can send me your SQL statment and your data to procdure it,
From my side, i just compiled it to WINCE nothing else, but let us find where the problem.
-
I know you just compiled it - Thank you.
I'll debug it and report what is the problem (maybe I have bug in my code and it works with old sqlite versions).
Major thing I have noticed till today, is if you use Locate method on SQLQuery with PacketRecords property set to default (10) it sometimes have problems to locate data.
Workaround is to change PacketRecords property to -1 (load all data).
-
Zaher,
Any chance to compile new 3.7.17 version ?
Thank you
-
Yes, check it here
http://sourceforge.net/projects/minilib/files/miniSQLViewer/
-
@Zaher,
Please, make a note about builds - what is the version difference :
sqlite3-3.7.17-arm.dll
sqlite3-3.7.17-arm4i.dll
Thx
-
Hello Zaher,
First, thank you for your work and thank you for sharing your compiled DLLs.
I've a question : multiple TSQlite3Connection has to connect to my SQLite Database (1 connection in my main thread), the other connection from a worker thread.
I tried to use the WAL mode but still get "Database is locked" error.
Is your library compiled to be thread safe ? : http://www.sqlite.org/threadsafe.html
Thank you for your answer
-
I think "No" the answer :(
Please check it by call sqlite3_threadsafe()
Start-time selection of threading mode
Assuming that the compile-time threading mode is not single-thread, then the threading mode can be changed during initialization using the sqlite3_config() interface. The SQLITE_CONFIG_SINGLETHREAD verb puts SQLite into single-thread mode, the SQLITE_CONFIG_MULTITHREAD verb sets multi-thread mode, and the SQLITE_CONFIG_SERIALIZED verb sets serialized mode.
Than mean i must compile it with threadsafe, but what must i choose
SQLITE_THREADSAFE=1 or 2?
for testing i compiled it with SQLITE_THREADSAFE=1 try it
download "sqlite3-3.7.17-arm-wince-ts.zip" from
http://sourceforge.net/projects/minilib/files/miniSQLViewer/
-
Thank you for this really fast answer ;)
I'll test your DLL tomorrow afternoon and I'll give you some feedbacks. Thank you again !!!
-
Zaher,
Any chance to compile new 3.8.1 version ?
Thank you
-
Done :)
http://sourceforge.net/projects/minilib/files/miniSQLViewer/
But without testing, it is your responsibility.
-
Thank you !
-
Hi,
My testing shows that every version since 3.7.16.1 have problem with TDataSet.Edit and TDataSet.Locate - latest test with 3.8.1 shows that it have it, too.
Version 3.7.15.2 and priors does not have this issue.
Any clue ?
-
Is the problem exists in win32 too, please try it, if yes i think it is bug in Lazarus, if not send me an example to reproduce it.
-
Zaher,
Problem is not in Lazarus win32 applications (I test it), it is only present in wince applications and it is with TCustomBufDataSet.Locate (eg. SQLQuery1.Locate).
If you have any database with few thousand records try to do locate specific record with any new sqlite dll (any from 3.7.16.1) - it just don't work - it works with small amount of records.
If you try with 3.7.15.2 or any older version, locate works with any number of records.
Problem is that until version 3.7.15.2 SQLQuery works without update sql query, but new version need it.
I changed it and now it works.
-
Not understand? Please give us more explain for who have the same problem (who find this topic by search).
Thanks :)
-
OK,
If you use TSQLQuery on WinCE with Edit and Post to update data with SQLite dll versions older then 3.7.16.1 , you can use them without writing an TSQLQuery.UpdateSQL.Text property.
If you wont to use on WinCE newer SQLite dll versions since 3.7.16.1 you have to write TSQLquery.Update.Text property.
It is interesting that TSQLQuery.Insert.Text still can remain empty and TSQLQuery with Insert and Post works with no problem.
-
That is strange, i am not used TSQLQuery, I tho you need to fill al UPdate and Insert to get work, it may have a bug in SQLQuery, would you ask Lazaurs/fpc developers.
-
I'll report bug.
-
Zaher,
Any chance to compile new 3.8.4.3 version ?
Thank you
-
Yes, and Done, please test it :)
Version 3.8.4.3
https://sourceforge.net/projects/minilib/files/miniSQLViewer/
-
Zaher,
WOW - this was very fast.
Could you , please explain difference in versions :
sqlite3.8.4.3-arm4i-ts.dll
sqlite3.8.4.3-arm4-ts.dll
Thx
-
Your welcome :)
For Arm4i
https://groups.google.com/forum/#!topic/microsoft.public.windowsce.platbuilder/RZP49NmlRmo
http://www.parmaja.com/pages/31
-
Hello Zaher,
Do you plan to update your SQlite wince library ?
-
Hi,
@swierzbicki: if you want you can use my version that I`m building occasionaly.. in case of special requirements I can compile special edition for you :D (e.g. if U need thread safety, some specific IFDEFs during compile time etc).
Please see: http://itm8.sk/sqlite3ce/
-
Oh yes, I will do it, tomorrow.
-
check it, and confirm if it is work fine, because i have not tested it.
https://sourceforge.net/projects/minilib/files/miniSQLViewer/