Dmitry Arefiev

https://docwiki.embarcadero.com/Libraries/Alexandria/en/FireDAC.Stan.Option.TFDBottomResourceOptions.PersistentFileName

':D' is not supported by TClientDataSet ...

Could you please report this on https://quality.embarcadero.com. Then I will investigate. Thanks and regards, Dmitry

https://docwiki.embarcadero.com/RADStudio/Alexandria/en/Unique_Identifying_Fields_(FireDAC)

Latest Firefox / Win7 (clean cache, disable plugins, what ever ...) - does not work Safari / macOS - works well Done.

Not doable for me ... After clicking on the link I see the running circle forever ...

Did you use the steps from below ? https://docwiki.embarcadero.com/RADStudio/Alexandria/en/Connect_to_MySQL_Server_(FireDAC)

Go to https://downloads.mysql.com/archives/c-c/, select macOS, etc, download archive, extract lib\libmysqlclient.18.dylib

> 1 FDWaitxxxx > 1 FDPHYSxxxFB (firebird) Long time are not required ...

I saw this post in German Delphi-Praxis: https://www.delphipraxis.net/209869-firedac-moeglichkeit-die-abfrage-schneller-zu-machen-delphi.html So, anybody, who have account on both forums can answer there ... "Normally" constants vs parameters slowness is due to bad query execution plan when the parameters are in use. For example, Oracle (and not only) will stop to use indexes, when a parameter data type is not the same as a field one in a WHERE clause. This is because a type conversion is required, even if it looks "obvious". For example, a field is VARCHAR2 and a parameter is defined as ftWideString (eg, assigning it using Value / AsWideString instead of AsAnsiString). There are more examples ... From Oracle doc (https://docs.oracle.com/cd/B19306_01/server.102/b14211/ex_plan.htm#i3305): PS: As always, a Delphi version will be good to know ...

Did you read and fully follow to the comment at: <demos>\Object Pascal\Database\FireDAC\Samples\DBMS Specific\MSSQL\QueryNotify\Unit1.pas Most of these are SQL Server "limitations" / "requirements".

At moment ftTimeStampOffset is not supported by FireDAC

For Update: INT128 NUMERIC with precision 19..38 TIME WITH TIME ZONE, TIMESTAMP WITH TIME ZONE (limited) DECFLOAT(16/34) native statement timeout More later, because all other will be "interface breaking changes". So, not for Update.

Delphi 11 Update 1 will support Firebird 4.

Why you dont want to change the REST.Client.pas unit ?