FIREDAC - Auto Generate SQL

[Lajos Juhász 293]

Hi,

 

Usually I like to use TFDUpdateSQL to generate SQL's to update the database. Now I have a case where it would be easier to let FD generate the insert statement. However I fail to see how to customize the SQL.

 

For some reason for Informix:

 

function TFDPhysInfxMetadata.GetNameParts: TFDPhysNameParts;
begin
  Result := [npCatalog, npSchema, npBaseObject, npObject];
end;
 

In case of informix npCatalog that's makes no sense as it is the database name. npSchema is the user and that is a big no. I have a database with multiple users and rights.

 

Is there a way to customize to generate the table name without prefixes? (When ApplyUpdates generates the insert or update statement.)