I am testing SQLite under WinCE. A few notes:

- When the db file is in a shared folder linked to the Emulator, it cannot be opened. Needs to becopied to an internal folder. This may have nothing to do with Lazarus, but might be a useful peace of information anyway.
- SQLite3Connection does not raise an exception when it cannot connect. Connected becomes "true" no matter what.
- Opening a SQLQuery raises Bus error or "misaligned data".
- Sqlite3Dataset: Loading a less then 2MByte dataset takes around 15 seconds in the emulator on a Centrino Dothan 1.6 CPU. Is this the speed to expect, or Sqlite3Dataset needs to be checked?

- Leslie -
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.lazarus.freepascal.org/pipermail/lazarus/attachments/20080622/8daa0b6a/attachment.html

You could document some of your findings here:

http://wiki.lazarus.freepascal.org/WinCE_Programming_Tips

The only thing that I know about sqlite and lazarus is that there are some problems with it in fpc 2.2.0, so I would try 2.2.2 if I were you.

thanks,

Op zondag 22-06-2008 om 19:41 uur [tijdzone +0200], schreef :

Hmm. That could explain somethings. I think it's somewhat different. In my experience the application made an database-file, but it coudn't be seen on the host-os. I guess there's some synchonise-issue.

- SQLite3Connection does not raise an exception when it cannot connect. Connected becomes "true" no matter what.

That's probably because messageboxes do not work. (in my experience) Place the .open in a try-except-block and catch the error message. That's how I did it.

- Opening a SQLQuery raises Bus error or "misaligned data".

Update to a recent fpc version. (2.2.2rc1 or later)

- Sqlite3Dataset: Loading a less then 2MByte dataset takes around 15 seconds in the emulator on a Centrino Dothan 1.6 CPU. Is this the speed to expect, or Sqlite3Dataset needs to be checked?

Changing folders did also take a few seconds here. Try it on a real device...

Joost.

Joost van der Sluis wrote

That's probably because messageboxes do not work. (in my experience) Place the .open in a try-except-block and catch the error message. That's how I did it.

They work if you are using subversion Lazarus.

http://wiki.lazarus.freepascal.org/Windows_CE_Development_Notes#Modal_Dialogs_and_the_OK_and_X_buttons

You could document some of your findings here: http://wiki.lazarus.freepascal.org/WinCE_Programming_Tips

I will, but first I am going to send them to the mailing list to find out their worth (I would not want to reinvent the wheel) and if they can be corrected.

The only thing that I know about sqlite and lazarus is that there are some problems with it in fpc 2.2.0, so I would try 2.2.2 if I were you.

I forgot to mention my cfg: Lazarus Snapshot 2008.06.18 with Fpc 2.2.2RC1 + the Arm-Wince snapshot from the same date.

- Leslie -

- SQLite3Connection does not raise an exception when it cannot connect. Connected becomes "true" no matter what.

if the db not found it will be created, try to use FileExists before open the db.