Questions:
1) Please provide FireDAC environment report.
2) How many records returns your query ?
3) What is the structure of the table in result set ?
4) Are FibPlus and FireDAC return all records ?
5) If you will remove fiMeta from FetchOptions.Items, does it help ?

Read More...

FireDAC MSSQL driver is included only into Enterprise and higher SKU. If you use Professional, then it will be not available.

Read More...

Use Size property.

Read More...

Try something like TFDTable.CreateTable(False, [tpIndexes]). Or read TFDTable.CreateTable method source code and create your own custom function.

Read More...

Client index - is a client side only index. The index is built inside of and maintained by TFDDataSet. The index is used only to sort data locally on the client side, after the data was fetched from a DB.
An index create using SQL command is built inside of database and is maintained by DB server. The index is used by DB server to optimize a SQL query execution.

Read More...

ArrayDML is much more efficient.

Read More...

So, you should cast:FDSQLiteBackup1->DestDatabaseObj=(TSQLiteDatabase *)FDConnection1->CliObj;

Read More...

• Which data access component you are using ?
• Why do you think, that TFMTBCDField is limited ?

What is the error ?

Read More...

RAD Studio data access components, including FireDAC and dbExpress, do not support MySQL connectivity from Android platform. But you can consider to use DataSnap - docwiki.embarcadero.com/RADStudio/Seattl...ataSnap_Applications

Read More...

docwiki.embarcadero.com/RADStudio/XE8/en...Server_%28FireDAC%29http://www.da-soft.com/blogs/anydac-for-delphi-advantage-database-support.html

Regards,
Dmitry

Adam wrote:

As option (1) I was suggesting to use DataSet.DisableControls / EnableControls.

DataSource.Enabled = False / True probably will work too.

Adam wrote:

Yes, it is.

Regards,
Dmitry

Could you please provide us your test application, which will reproduce the issue ?
Read More...

At first, please, read:
technet.microsoft.com/en-us/library/ms34....aspx#marsins_topic9

By default FireDAC uses MARS mode and fmOnDemand. Although this:
* avoids "connection is busy" errors;
* allows "comfortably" fetch / navigate through result set
This leads to the issues, described in the article.

To optimize SQL Server application you should try:
* different FetchOptions.CursorKind values;
* to use FetchOptions.Mode=fmAll as much as possible.

I believe BDE does kind of fmAll, but with some tricks behind the scene.
Read More...

Ok, thank you for feedback. Let me discuss that with Development Team. I will reply shortly.
Read More...

Please do the following:
* add TButton;
* add empty TButton.OnClick event handler;
* move all code from TForm1.OnCreate event handler to TButton.OnClick.
Does it help / change anything ?
Read More...

john wrote: