Hi

Thanks for the answer.

1) Well I think he is hiding something from you. :-) The following is from
the IB6.0 API reference:

---->
isc_dsql_fetch()
Retrieves data returned by a previously prepared and executed DSQL
statement.

Description isc_dsql_fetch() retrieves one row of data into xsqlda each time
it is called. It is used in
a loop to retrieve and process each row of data for statements that return
multiple rows
in a cursor.

<----

2) My problem is that I wish to display the result of a query in a visual
control. In my case the rows of interest can be several thousands. When the
user scroll the control I need to be able to display the rows which are
visible. This is why I wish to be able to fetch a specific row from the
query. I have looked at the implementation of the InterbaseExpress
TIBDataSet component, and it looks like it handles the problem by caching
all of the rows in memory! This dosn't seem to be a good solution to me...

-
SMN
-----Original Message-----
From: Svein Erling Tysvaer
[mailto:svein.erling.tysvaer@...]
Sent: 26. maj 2003 11:01
To: ib-support@yahoogroups.com
Subject: Re: [ib-support] Absolute addressing of rows in a previously
prepared and executed DSQL statement


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:

>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.

To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/