Build of SQLite3 for WINCE ARM4

[bambamns]

Zaher,

Any chance to compile new 3.8.1 version ?

Thank you

[Zaher]

Done
http://sourceforge.net/projects/minilib/files/miniSQLViewer/

But without testing, it is your responsibility.

[swierzbicki]

Thank you !

[bambamns]

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 ?

[Zaher]

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.

[bambamns]

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.

[Zaher]

Not understand? Please give us more explain for who have the same problem (who find this topic by search).

Thanks

[bambamns]

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.

[Zaher]

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.

[bambamns]

I'll report bug.

[bambamns]

Zaher,

Any chance to compile new 3.8.4.3 version ?

Thank you

[Zaher]

Yes, and Done, please test it
Version 3.8.4.3
https://sourceforge.net/projects/minilib/files/miniSQLViewer/

[bambamns]

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

[Zaher]

Your welcome

For Arm4i

https://groups.google.com/forum/#!topic/microsoft.public.windowsce.platbuilder/RZP49NmlRmo
http://www.parmaja.com/pages/31

[swierzbicki]

Hello Zaher,

Do you plan to update your SQlite wince library ?