ParamTypes of UpdateStatements

[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

[AlexP]

Hello,

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

[Nilss]

Thank you for the quick reply and solving of the problem.

[AlexP]

Hello,

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

[MarkM]

Hi Alex,

Are you still planning to release a fix this week?

Thanks,

[AndreyZ]

We plan to release SDAC at the beginning of the next week.