Subject Re: [IBO] Problem-DSQL-with-singleton-select
Author Daniel Rail

At August 17, 2004, 09:17, Mihai Chezan wrote:

>> TIB_DSQL expects the return of at least one row if it is a singleton
>> select.
> If this is how it's supposed to work then the help files should at
> least mention this and the error message should be more explicit like:
> "Error: the select didn't returned any rows!" and not:
> ISC ERROR CODE:335544374
> attempt to fetch past the last record in a record stream

> This tells me that ibo sends the queries to the server and if there is
> an error it retunrs that error to the user even if the error is
> because of a limitation in the ibo or an error that ibo should deal
> with.

It's not a limitation in IBO. The error that you mention above comes
from the server. It's just for TIB_DSQL, IBO uses an API call that is
not meant to fetch more than one row and at the same time expects to
have one row returned if the statement passed is an SELECT statement.

I agree that the error message could be better, but IBO only returns
the error message that is coming from the server in this case.

And, I also agree that this should be documented in IBO's help.

Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (
ACCRA Med Software Inc. (