ParamTypes of UpdateStatements
Posted: 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
			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