Subject | Re: [IBO] DSQL Executing |
---|---|
Author | Lucas Franzen |
Post date | 2001-03-01T12:13:21Z |
Yagi,
TIB_Cursor instead.
Use TIB_DSQL for update statements or executing stored procedures that
return no rows.
Luc.
>TIB_DSQL components are not for fetching records, use a TIB_Query or
> 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_Cursor instead.
Use TIB_DSQL for update statements or executing stored procedures that
return no rows.
Luc.