Recent

Author Topic: Build of SQLite3 for WINCE ARM4  (Read 33176 times)

bambamns

  • Full Member
  • ***
  • Posts: 223
Re: Build of SQLite3 for WINCE ARM4
« Reply #30 on: November 12, 2013, 05:28:33 am »
Zaher,

Any chance to compile new 3.8.1 version ?

Thank you
Lazarus 1.8.4 + FPC 2.6.4 x86 (rebuild) and Lazarus 2.0, Windows 7 x64, unless otherwise specified

Zaher

  • Hero Member
  • *****
  • Posts: 593
    • parmaja.com
Re: Build of SQLite3 for WINCE ARM4
« Reply #31 on: November 12, 2013, 09:37:51 am »
Done :)
http://sourceforge.net/projects/minilib/files/miniSQLViewer/

But without testing, it is your responsibility.

swierzbicki

  • Full Member
  • ***
  • Posts: 177
Re: Build of SQLite3 for WINCE ARM4
« Reply #32 on: November 12, 2013, 06:32:16 pm »
Thank you !
Lazarus 1.6.2
fpc 3.0.0
wince/win32/win64
delphi berlin

bambamns

  • Full Member
  • ***
  • Posts: 223
Re: Build of SQLite3 for WINCE ARM4
« Reply #33 on: November 17, 2013, 07:15:08 am »
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 ?
« Last Edit: November 17, 2013, 07:21:48 am by bambamns »
Lazarus 1.8.4 + FPC 2.6.4 x86 (rebuild) and Lazarus 2.0, Windows 7 x64, unless otherwise specified

Zaher

  • Hero Member
  • *****
  • Posts: 593
    • parmaja.com
Re: Build of SQLite3 for WINCE ARM4
« Reply #34 on: November 17, 2013, 07:55:00 am »
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

  • Full Member
  • ***
  • Posts: 223
Re: Build of SQLite3 for WINCE ARM4
« Reply #35 on: November 19, 2013, 12:48:59 am »
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.
« Last Edit: November 19, 2013, 01:34:45 am by bambamns »
Lazarus 1.8.4 + FPC 2.6.4 x86 (rebuild) and Lazarus 2.0, Windows 7 x64, unless otherwise specified

Zaher

  • Hero Member
  • *****
  • Posts: 593
    • parmaja.com
Re: Build of SQLite3 for WINCE ARM4
« Reply #36 on: November 19, 2013, 03:00:12 pm »
Not understand? Please give us more explain for who have the same problem (who find this topic by search).

Thanks :)

bambamns

  • Full Member
  • ***
  • Posts: 223
Re: Build of SQLite3 for WINCE ARM4
« Reply #37 on: November 22, 2013, 05:29:56 am »
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.
Lazarus 1.8.4 + FPC 2.6.4 x86 (rebuild) and Lazarus 2.0, Windows 7 x64, unless otherwise specified

Zaher

  • Hero Member
  • *****
  • Posts: 593
    • parmaja.com
Re: Build of SQLite3 for WINCE ARM4
« Reply #38 on: November 22, 2013, 04:30:25 pm »
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

  • Full Member
  • ***
  • Posts: 223
Re: Build of SQLite3 for WINCE ARM4
« Reply #39 on: November 23, 2013, 03:55:43 am »
I'll report bug.
Lazarus 1.8.4 + FPC 2.6.4 x86 (rebuild) and Lazarus 2.0, Windows 7 x64, unless otherwise specified

bambamns

  • Full Member
  • ***
  • Posts: 223
Re: Build of SQLite3 for WINCE ARM4
« Reply #40 on: April 09, 2014, 07:32:46 pm »
Zaher,

Any chance to compile new 3.8.4.3 version ?

Thank you
Lazarus 1.8.4 + FPC 2.6.4 x86 (rebuild) and Lazarus 2.0, Windows 7 x64, unless otherwise specified

Zaher

  • Hero Member
  • *****
  • Posts: 593
    • parmaja.com
Re: Build of SQLite3 for WINCE ARM4
« Reply #41 on: April 09, 2014, 07:44:27 pm »
Yes, and Done, please test it :)
Version 3.8.4.3
https://sourceforge.net/projects/minilib/files/miniSQLViewer/

bambamns

  • Full Member
  • ***
  • Posts: 223
Re: Build of SQLite3 for WINCE ARM4
« Reply #42 on: April 09, 2014, 08:05:43 pm »
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
Lazarus 1.8.4 + FPC 2.6.4 x86 (rebuild) and Lazarus 2.0, Windows 7 x64, unless otherwise specified


swierzbicki

  • Full Member
  • ***
  • Posts: 177
Re: Build of SQLite3 for WINCE ARM4
« Reply #44 on: March 12, 2015, 07:19:49 am »
Hello Zaher,

Do you plan to update your SQlite wince library ?
Lazarus 1.6.2
fpc 3.0.0
wince/win32/win64
delphi berlin

 

TinyPortal © 2005-2018