Roger,

I've got a sqlda error when I try to do this

- create a TIB_DSQL with params in select clause; prepare it once
- go through a loop; change params and execute TIB_DSQL to get a single
value from a table

This pseudo code was working until nov. 2000. Then Jason changed something
behind the scene to avaoid a known Interbas bug.

Then my pseudo code was running only once; running second time in loop
caused a sqlda error.

I solved this problem by using TIB_Cursor instead of TIB_DSQL and this error
disappears to me.

Mit freundlichem Gruss & Best Regards

Andreas Pohl
apohl@...
http://www.ibp-consult.com

-----Ursprüngliche Nachricht-----
Von: "Roger Webb" <RWebb@...>
An: "Ibo-List (E-mail)" <ibobjects@egroups.com>
Gesendet: Montag, 8. Januar 2001 19:49
Betreff: [IBO] SQLDA error not in a Stored Proc

> I've got an IB_Query that looks like this...
>
> The SQL is 'Select * from Items where Item_ID = :ItemId'
>
> The Code :
>
> try
> ibqList.ParamByName( 'ItemID' ).AsInteger := 7;
> ibqList.Open;
> ibqList.Close;
> Except
> on E:Exception do
> BuildString := E.Message;
> end;
>
> Buildstring ends up containing this info :
> Dynamic SQL Error SQL error code = -804 Incorrect values within SQLDA
> structure
>
> Any ideas... am I missing any info that would help?
>
> - Roger
>
>
>
>
>