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 80]

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 239]

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.

[FrancM 0]

Thank you, everyone! Delphi required a reinstallation, and after that, the old code started working without any issues.

 

BTW, The Professional version is apparently practically the same as CE?

[DelphiUdIT 187]

25 minutes ago, FrancM said:

Thank you, everyone! Delphi required a reinstallation, and after that, the old code started working without any issues.

 

BTW, The Professional version is apparently practically the same as CE?

Here will be all features for the various RAD Studio Editions (included CE): https://www.embarcadero.com/docs/rad-studio-feature-matrix.pdf

[PeterBelow 239]

9 minutes ago, FrancM said:

Thank you, everyone! Delphi required a reinstallation, and after that, the old code started working without any issues.

 

BTW, The Professional version is apparently practically the same as CE?

Yes, apart from the licence restriction re yearly revenue.

[DelphiUdIT 187]

8 minutes ago, PeterBelow said:

Yes, apart from the licence restriction re yearly revenue.

And all the features about 12.2 Release. The CE edition is like the 12.1.

Edited November 18 by DelphiUdIT