| Subject | Re: [IBO] Difference between using ib_query or ib_storedproc for a select procedure |
|---|---|
| Author | Lucas Franzen |
| Post date | 2002-10-02T09:29:15Z |
Gerhardus Geldenhuis schrieb:
SUSPEND to return multiple rows.
IB_StoredProcs are for returning ONE row (a set of fields) and the SP
shouldn't contain SUSPEND in that case.
Luc.
>TIB_Query are for returning multiple rows, so your SP must contain
> Hi
> I just want to know is there any difference in terms of
> speed/effectiveness/etc in using a ib_query to, with the following
> select * from myproc(:var1,:var2) than using a ib_storedproc component
> to do the selection.
SUSPEND to return multiple rows.
IB_StoredProcs are for returning ONE row (a set of fields) and the SP
shouldn't contain SUSPEND in that case.
Luc.