Dmitry Arefiev

https://docwiki.embarcadero.com/RADStudio/Athens/en/Connect_to_Microsoft_Access_Database_(FireDAC)#Use_Cases

https://downloads.mysql.com/archives/get/p/23/file/mysql-5.7.44-win32.zip

https://docwiki.embarcadero.com/RADStudio/Athens/en/Using_SQLite_with_FireDAC#Adjusting_FireDAC_Mapping

Quote

For an expression in a SELECT list, SQLite avoids type name information. When the result set is not empty, FireDAC uses the value data types from the first record. When empty, FireDAC describes those columns as dtWideString. To explicitly specify the column data type, append ::<type name> to the column alias:

SELECT count(*) as "cnt::INT" FROM mytab

You should set TFDPhysSQLiteDriverLink.EngineLinkage to slFDEStatic. Then check your uses clauses. Application should have only single unit from these:

• FireDAC.Phys.SQLiteWrapper.FDEStat
• FireDAC.Phys.SQLiteWrapper.SEEStat
• FireDAC.Phys.SQLiteWrapper.Stat

https://docwiki.embarcadero.com/RADStudio/Athens/en/Using_SQLite_with_FireDAC#SQLite_Data_Types

... or TControlList

v_Context.FindType('FireDAC.Phys.PGDef.TFDPhysPGConnectionDefParams')

33 minutes ago, emileverh said:

The dtFloat type does not exist. I am accurate enough with this code?

Yes, it is.

Did you read about "...::type" syntax ?

https://docwiki.embarcadero.com/RADStudio/Athens/en/Using_SQLite_with_FireDAC#Adjusting_FireDAC_Mapping

What is your Windows version ?

var
  s: ssShift .. ssHorizontal;

or upgrade to Delphi 12 and use TShiftStateItem.

Can you share the URL and request ?

Please read my comment above.

https://www.postgresql.org/docs/current/sql-do.html

Quote

The code block is treated as though it were the body of a function with no parameters, returning void. It is parsed and executed a single time.

This is about Firebird, but is equally applicable to InterBase:

https://www.firebirdfaq.org/faq29/

InterBase does not support "AUTO_INCREMENT".

TStringHelper appeared in System.SysUtils in XE3. From beginning it had Split method.

What is the Delphi version ?

Please, show your code to query meta-data

Please show the code for one "procedure SetAsGuidArray(SourceItems: TArray<TGuid>); " as an example

How pp_lfopen is defined in header file ?

TStaticText ?

uses
  FireDAC.Phys.ODBCWrapper;

procedure TForm252.Button1Click(Sender: TObject);
begin
  ShowMessage(TODBCConnection(FDConnection1.CliObj).DRIVER_NAME);
end;

https://docwiki.embarcadero.com/Libraries/Athens/en/FireDAC.Comp.Client.TFDCustomConnection.CliObj

I attached the patch. If you will fail to apply it, then please go through support.

fb5_ret.patch

@VLDG, thanks ! Yes, this is the issue in FireDAC support for Firebird 5.

The issue is fixed, the changes will be included into Delphi 12 Update 1.