ParamTypes of UpdateStatements

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Nilss
Posts: 11
Joined: Thu 27 Jun 2013 12:23

ParamTypes of UpdateStatements

Post by Nilss » Thu 27 Jun 2013 12:38

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
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: ParamTypes of UpdateStatements

Post by AlexP » Mon 01 Jul 2013 13:49

Hello,

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

Nilss
Posts: 11
Joined: Thu 27 Jun 2013 12:23

Re: ParamTypes of UpdateStatements

Post by Nilss » Tue 02 Jul 2013 07:30

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

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: ParamTypes of UpdateStatements

Post by AlexP » Tue 02 Jul 2013 07:53

Hello,

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

MarkM
Posts: 1
Joined: Fri 28 Jun 2013 13:37

Re: ParamTypes of UpdateStatements

Post by MarkM » Tue 09 Jul 2013 18:08

Hi Alex,

Are you still planning to release a fix this week?

Thanks,

AndreyZ

Re: ParamTypes of UpdateStatements

Post by AndreyZ » Thu 11 Jul 2013 07:56

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

Post Reply