|Subject||Re: [Firebird-Architect] Fetching from a non-cursor|
15.10.2010 9:30, Alex Peshkoff wrote:
> On 10/15/10 00:56, Dimitry Sibiryakov wrote:What message fetch picks up when it returns 100?
>> 14.10.2010 22:45, Jim Starkey wrote:
>>> I don't understand what the problem is. A thin DSQL layer might not
>>> have any idea of what a particular SQL string might do under after the
>>> statement is executed. If it produces results, then it can use
>>> isc_dsql_fetch to get them. Expecting a command line interpreter to do
>>> a semantic analysis of a user supplied string is a little harsh...
>> isc_dsql_fetch() is supposed to get one row from result set. Result set is created by
>> SUSPEND. No SUSPEND - nothing to fetch.
> Dimitry, this is not correct logic. Fetch wants to pick up a message. As
> the result of SP execution statement has output message. Why not let
> fetch pick it up?