Subject Re: [Firebird-Architect] Fetching from a non-cursor
Author Dimitry Sibiryakov
18.10.2010 14:18, Alex Peshkoff wrote:
> On 10/18/10 13:54, Dimitry Sibiryakov wrote:
>> 18.10.2010 11:48, Alex Peshkoff wrote:
>>> If I use it with output SQLDA, I will have to each time check - may be
>>> there some more data to fetch?
>> No, in this case you'll get "multiple rows in singleton select" error. No further check
>> is required.
> Well, but how do I know (when parsing unknown SQL operator) what form
> (with or wihout output SQLDA) to use?

In this case, if you have no idea about SQL operator and its expecting results, you
have no choice but always use call without SQLDA and then fetch till error or end of data.