When using Inserts with auto-generated IDs i can retrieve the generated ID via out parameter in TSqlQuery. This Feature would be nice in TxDataset as i saves a lot of queries for ID generation.
Example:
SQLCommand := 'Insert into TABLE_NAME(Field01) values (''test2'') returning ID';
aparams := TParams.Create;
aparams.CreateParam(ftInteger,'ID',ptOutput);
sds := TSqlQuery.Create(nil);
try
sds.SQLConnection := FConnection;
sds.SQL.Text := SQLCommand;
sds.Params.Assign(aparams);
sds.ExecSQL();
result := sds.Params[0].AsInteger;
finally
sds.free;
aparams.free
end;
With TXDataset I get an EDatabaseError with Parameter 'ID' not found