| Subject | Re: [Firebird-Architect] Fetching from a non-cursor |
|---|---|
| Author | Dimitry Sibiryakov |
| Post date | 2010-10-15T15:09:23Z |
15.10.2010 16:59, Alex Peshkoff wrote:
Jim insists that this was original design. If Jim is right, first fetch from EXECUTE
PROCEDURE must return data and subsequent ones - 100.
However, in this case one question left: what if the procedure is selectable (i.e. uses
SUSPEND)? Shouldn't in this case all records be fetched before end-of-data and EXECUTE
PROCEDURE to be effectively the same as SELECT?
--
SY, SD.
> What we started to discuss is 'Is the fact that isc_dsql_execute()And everybody except Jim agreed that this is a bug.
> agrees to work with EXECUTE PROCEDURE a bug or documented behavior?'
Jim insists that this was original design. If Jim is right, first fetch from EXECUTE
PROCEDURE must return data and subsequent ones - 100.
However, in this case one question left: what if the procedure is selectable (i.e. uses
SUSPEND)? Shouldn't in this case all records be fetched before end-of-data and EXECUTE
PROCEDURE to be effectively the same as SELECT?
--
SY, SD.