Problems in connecting with FIREDAC and SQLite under XE7

Delphi sublimation, in the direction of XE, has achieved the Android and Apple Mobile cross-platform, so only need a code, can command two mobile phone platforms, is indeed an efficient approach and saving strategy.

With xe connected to SQLite, the mainstream use of FIREDAC, that is, drag 4 control, you can achieve data connection and extraction.

1. FDPhySQLiteDriverLink1

2. FDGUIxWaitCursor1

2.fdconnection1

3. FDQuery1

The most important is in the Fdconnetion parameter definition section, first is the SQLite database, to store data in UTF8, so that OpenMode is set to CreateUTF8, in order to display Chinese characters, you want to set StringFormat to Unicode. Basically, you can.

Problems in connecting with FIREDAC and SQLite under XE7