Page 1 of 1

Incorrect values within SQLDA structure.

Posted: Fri 10 May 2013 03:13
by 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

Re: Incorrect values within SQLDA structure.

Posted: Mon 13 May 2013 10:52
by 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.

Re: Incorrect values within SQLDA structure.

Posted: Tue 14 May 2013 16:31
by inageib
glad to help.

Re: Incorrect values within SQLDA structure.

Posted: Mon 20 May 2013 05:17
by AndreyZ
We have fixed this problem. This fix will be included in the next IBDAC build.

Re: Incorrect values within SQLDA structure.

Posted: Mon 20 May 2013 10:48
by inageib
Great.

Re: Incorrect values within SQLDA structure.

Posted: Mon 20 May 2013 12:48
by AndreyZ
If any other questions come up, please contact us.