CALL a database Function

[wlandgraf (Wagner Landgraf)]

You should just use your regular database-connection component, maybe you are using FireDAC, thus you should use TFDQuery to do so.

If you are using Aurelius, you can execute arbitrary SQL statements, it's explained in the following topics:

Using a generator for non Id fields?

Thank you for the contribution, @Weetch_Russell. Also note that there is no need to use the TFDQuery component directly, you can use Aurelius interfaces directly and thus the code is not dependent on a specific component: class function TConnectionUtils.GetNextSequenceValue(AConnection: IDBConnection; const SequenceName: string): Int64; const SQL = 'SELECT NEXT VALUE FOR %s FROM RDB$DATABASE'; var Query: IDBStatement; ResultSet: IDBResultSet; begin Query := AConnection.CreateStatement; …

IDBResultSet and stored procedures

I'm trying to get the result of a firebird stored procedure but it always returns 0.  The stored procedure gives the correct result when called directly in IBExpert.  Is there something that I am doing wrong?   var Statement: IDBStatement; ResultSet: IDBResultSet; Params : TObjectList< TDBParam >; SQLCommand : string; begin Result := 0; SQLCommand := 'SELECT UNIT_PRICE FROM CALCULATE_UNIT_PRICE(:COMMODITY_ID, :ACCOUNT_ID)'; //SQLCommand := 'execute procedure CALCULATE_UNIT_PRI…

Multiple requests to xdata server to run a regular query

You have three options. Use the connection pool normally, and execute queries using the Aurelius interfaces, this way: For UPDATE/INSERT/DELETE: uses {...}, Aurelius.Drivers.Interfaces; var Statement: IDBStatement; Statement := Manager.Connection.CreateStatement; Statement.SetSQLCommand(TheSQLStatement); Statement.Execute; for SELECT: var Statement: IDBStatement; ResultSet: IDBResultSet; Statement := Manager.Connection.CreateStatement; Statement.SetSQLCom…