| Subject | Re: [ib-support] Absolute addressing of rows in a previously prepared and executed DSQL statement |
|---|---|
| Author | Svein Erling Tysvaer |
| Post date | 2003-05-26T09:01:07Z |
Hi Svend!
Using IBObjects I have no knowledge about the API, but your question does
seem strange to me on two accounts.
1) I thought a DSQL were for execution, not selection, and that it returned
only one row. Using fetch several times to a dsql doesn't sound sensible,
rather I would expect a cursor to be what you want (though maybe it is just
Jason hiding things from us IBOers).
2) You should limit yourself to only return rows of interest - i.e. if you
are interested in one particular row, then change the where clause so that
only this row is returned.
HTH,
Set
At 22:57 25.05.2003 +0200, you wrote:
Using IBObjects I have no knowledge about the API, but your question does
seem strange to me on two accounts.
1) I thought a DSQL were for execution, not selection, and that it returned
only one row. Using fetch several times to a dsql doesn't sound sensible,
rather I would expect a cursor to be what you want (though maybe it is just
Jason hiding things from us IBOers).
2) You should limit yourself to only return rows of interest - i.e. if you
are interested in one particular row, then change the where clause so that
only this row is returned.
HTH,
Set
At 22:57 25.05.2003 +0200, you wrote:
>Is it possible to perform absolute addressing of rows in a previously
>prepared and executed DSQL statement?
>
>As far as I can see I need to call isc_dsql_fetch X times if I whish to get
>data for record number X.