Subject | Re: [IBO] Problem-DSQL-with-singleton-select |
---|---|
Author | Daniel Rail |
Post date | 2004-08-17T10:26:44Z |
Hi,
At August 17, 2004, 06:57, Mihai Chezan wrote:
If you want to execute a singleton select and also be able to check if
the result-set is empty, use TIB_Cursor.
TIB_DSQL expects the return of at least one row if it is a singleton
select.
--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)
At August 17, 2004, 06:57, Mihai Chezan wrote:
> Hi,Just an added note.
> If I use a TIB_DSQL and an sql that returns an empty result set I get
> this error when I execute the dsql:
If you want to execute a singleton select and also be able to check if
the result-set is empty, use TIB_Cursor.
TIB_DSQL expects the return of at least one row if it is a singleton
select.
--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)