This article from http://blog.csdn.net/hellogv/
SQLite is a lightweight embedded database that is not needed on a PC, but it plays a major role in WinCE (access stops upgrading on WinCE, SQL CE is too large ).
- Use SQLite on Lazarus for Win32
- Install SQLite for Win32: vc2005 compile SQLite, http://blog.csdn.net/hellogv/archive/2008/05/06/2399700.aspx, put the compiled sqlite3.dll under the Windows system folder; you can also directly go to www.sqlite.org to download the existing sqlite3.dll.
- Install the SQLite control of Lazarus:/Lazarus/components/SQLite/sqlite3laz. LPK
Compile the SQLite database program in Win32 and modify the compiler to generate the database program on the wince platform. This can greatly reduce cross-compilation ~ Debugging is a waste of time!
- Use SQLite on Lazarus for WinCE
- Compiled sqlite3.dll for WinCE
- Advanced Lazarus application project, add sqlite3dataset Control
- You must first set the compiler properties of the Project. Please click the menu item:Project> compiler options..., ClickPathPage, and adapt the LCL widget to wince. ClickCodePage, and change target platform to arm-wince.
- During compilation, an error such as fatal: Can't Find unit propedits used by registersqlite3 will be raised. You need to modify the code of/Lazarus/components/SQLite/registersqlite3.pas.
- Comment out propedits, componenteditors, and sqlitecomponenteditor; comment out registercomponenteditor (timer, tsqliteeditor); registerpropertyeditor (typeinfo (string), comment, 'filename', tfilenamepropertyeditor );
- Recompile to pass.
Appendix: when using a small part of data-sensitive controls such as DBGrid, even if the compilation passes, running on WinCE still raises the "access violation" error, dbedit and other data-sensitive controls can be used normally!
