Incorrect values within SQLDA structure.

[inageib]

Hi,
I was trying to execute an insert statement and assign a parameter like that:

Code: Select all

<TIBCSQL>.parameterbyname('para1').assingle := table1.fieldbyname('f2').assingle;

and I get this error when I try to execute the statement

Dynamic SQL ErrorSQL error code = -804Incorrect values within SQLDA structure.

also before that error I was getting this error message after trying to assign many parameter "assingle"

Unknown data type

After long time of investigation I found the filed 'f2' is null. Is that because of the null values or something else ? the error messages are not clear.

thanks

[AndreyZ]

Hello,

Thank you for the information. We have reproduced the problem and investigation of the problem is in progress. As soon as we have any results we will let you know.

[inageib]

glad to help.

[AndreyZ]

We have fixed this problem. This fix will be included in the next IBDAC build.

[inageib]

Great.

[AndreyZ]

If any other questions come up, please contact us.