Subject Re: [firebird-support] FB3 returning clause and new API
Author Martin Schreiber
On Thursday 15 September 2016 10:29:27 Dimitry Sibiryakov sd@...
[firebird-support] wrote:
> 15.09.2016 10:16, Martin Schreiber mse00000@... [firebird-support]
> > And then how to get the data?
> Last two parameter of the methods is an output message where output data
> is returned in.

Signature of execute in firebird.pas is:
function execute(status: IStatus; transaction: ITransaction; inMetadata:
IMessageMetadata; inBuffer: Pointer; outMetadata: IMessageMetadata;
outBuffer: Pointer): ITransaction;
A value for outMetadata probably is available by
IStatement.getOutputMetadata(). What if one wants to use
IAttachment.execute() where no IStatement is available?

How can one know if IAttachment.execute() or IAttachment.openCursor() must be
called without having IStatement.getFlags() from a prepared statement other
than parsing the SQL statement in user code?

Does IAttachment.prepare() involve a server roundtrip?

Thanks for your patience.