Subject Re: [IBO] DSQL Executing
Author Lucas Franzen
Yagi,

>
> I use TIB_DSQL with te following statement:
>
> SELECT NUMER
> FROM STANOWISKA
> WHERE NIECZYNNE = 0 AND STANOWISKA.ADRES = :ADRES
>
> In my source code i'v got something like this
>
> ibdsqlCM->Prepared = true;
> ibdsqlCM->ParamByName("ADRES")->AsString = adres;
> ibdsqlCM->Execute();
>
> now, if SELECT statement returns no records (adres parameter is wrong) then
> i got an error on ibdsqlCM.Execute():
>
> Am I doing something wrong?

TIB_DSQL components are not for fetching records, use a TIB_Query or
TIB_Cursor instead.

Use TIB_DSQL for update statements or executing stored procedures that
return no rows.

Luc.