At 11:26 PM 15-08-01 -0700, you wrote:

>Actually, 2 questions.
>
>First, a quickie: What is the "proper" way to test for "is the result set
>empty?"
> RowsSelected, RowsAffected, EOF and BOF, try..except, or ??

Test the .IsEmpty property.

>Second,
>
>This seems to be a simple, direct TIB_DSQL, but on the 2nd execution of it
>(and thereafter), I receive:
>
>SQL Error code = -804
>SQLDA missing or incorrect version, or incorrect number/type of variables.

You cannot get a dataset back from a TIB_DSQL - it is for executing statements. Here you are calling Execute on a SELECT statement. You will also get this error from calling Open instead of Execute or ExecSQL on a statement that performs a DSQL operation.

If you want to SELECT rows, use TIB_Cursor or TIB_Query.

Regards,
Helen


All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________