Deploying an application that uses SQLite requires you to manually include the SQLite open source library.
This topic has earned its right to have a page of its own in this reference being the subject of many question in Basic4ppc forum on the web. Follow the steps carefully. The required files differs from one version 6.5 and earlier of Basic4ppc to the latest ones.
Latest Basic4ppc version:
There are three .dll files for SQLite:
1. For a Desktop only application, copy the file named "System.Data.SQLite.DLL" and deploy with your application.
2. For a Device only application, copy the files:
a. System.Data.SQLite.Device.DLL
b. SQLite.Interop.060.DLL - note that the "060" may change in future versions. Use the latest: for example if you have SQLite.Interop.070.dll, use this rather than the 060.
3. For a dual (desktop/device) application, use all three files.
Basic4ppc version 6.5 and earlier:
"System.Data.SQLite.DLL"
Note: there are two libraries with the same name - a device library and a desktop library. They differ from one another. It is the developer responsibility to make sure he deploys both with the compiled application. You can distinguish them from one another using their size: the device library's size is 450K, whereas the desktop one is 568K.
Where to find these files:
Both files are located at Basic4ppc Desktop\Libraries\SQL Native under either Desktop or Device:
Typical location of System.Data.SQLite.DLL
A message indicating what should be copied will appear after compiling. Note, there is no indicating as to which of the two files to copy. Try it out on your device before you deploy...:
Next page: Some common error messages