Page 1 of 1

ParamTypes of UpdateStatements

Posted: Thu 27 Jun 2013 12:38
by Nilss
Hello,

we recently upgraded from version 6.6.11 of SDAC to 6.7.13. Changes to the way default ParamTypes of update statements are assigned cause problems now.

In version 6.6.11 parameters were defaulted to type ptInput, now the paramters of the same statements are ptInputOutput. This affects our project, as we sometimes set paramters of type ptInput to be un-bound. Some update statements are failing with an error:

"Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
Parameter[0] :A - invalid ParamType (Status = 1h)."

This seems to be related to fields of type XML.


Is this an intentional change we need to handle on our own or can we expect this to be changed back to the way it was in version 6.6.11?

Thanks

Re: ParamTypes of UpdateStatements

Posted: Mon 01 Jul 2013 13:49
by AlexP
Hello,

We have already fixed this problem. This fix will be included in the next build, that will be released next week.

Re: ParamTypes of UpdateStatements

Posted: Tue 02 Jul 2013 07:30
by Nilss
Thank you for the quick reply and solving of the problem.

Re: ParamTypes of UpdateStatements

Posted: Tue 02 Jul 2013 07:53
by AlexP
Hello,

If you have any other questions, feel free to contact us.

Re: ParamTypes of UpdateStatements

Posted: Tue 09 Jul 2013 18:08
by MarkM
Hi Alex,

Are you still planning to release a fix this week?

Thanks,

Re: ParamTypes of UpdateStatements

Posted: Thu 11 Jul 2013 07:56
by AndreyZ
We plan to release SDAC at the beginning of the next week.