Delphi 12CE and SQLite

[FrancM 0]

Hi,

 

Does Delphi 12 Community Edition have any limitations when using SQLite with FireDAC in an Android application? When compiling the program, I get an error message: 'file not found FireDAC.Phys.SQLiteWrapper.pas.

 

-FM-

[gkobler 38]

i'm not sure, but FireDAC are not available in CE edition

https://www.embarcadero.com/products/rad-studio/firedac

[Serge_G 87]

To answer @gkobler

On page 21 of RAD Studio 12 Feature Matrix 
 

Quote

Support for local databases, including Microsoft Access database, SQLite and MariaDB
database, IBToGo / IBLite, InterBase on localhost, MySQL Embedded, MySQL Server
on localhost, Advantage Database local engine, PostgreSQL on localhost, Firebird
Embedded, Firebird on localhost

There are no limitations noted for a "classic" usage of SQLite .
But, I can't test Community version to answer @FrancM

[Patrick PREMARTIN 68]

Hi

Is FireDAC.Phys.SQLiteWrapper added somewhere in your code by the IDE or is it used by FireDAC itself ? What happen when you remove it (in the first case).

Is TFDPhysSQLiteDriver component used somewhere in the program ?

Did you tried to change the driver type ("native" SQLite or FDE) ?

[PeterBelow 238]

On 11/12/2024 at 10:42 AM, FrancM said:

Hi,

 

Does Delphi 12 Community Edition have any limitations when using SQLite with FireDAC in an Android application? When compiling the program, I get an error message: 'file not found FireDAC.Phys.SQLiteWrapper.pas.

 

-FM-

You do not have the source (pas) for the unit and you should never set up a project to have the source files for Delphi RTL etc. units on its search path. You should have the precompiled FireDAC.Phys.SQLiteWrapper.dcu, though, and the path to its folder should be on the IDE library path for the target platform in question.