This command has no error:
update art_anz set anz = anz where artnr = 'xxxxxxx'
declare @.artnr as varchar(10)
set @.artnr = ?
But this command has an error:
--update art_anz set anz = anz where artnr = 'xxxxxxx'
declare @.artnr as varchar(10)
set @.artnr = ?
The difference is the first line. When you use parameters (?) in the OLE DB-Command, the very first line has to be a Non-Select SQL-Statement.
The SQL-Statement do nothing!
When you have no parameters, you can write normal T-SQL-Code and you get no error.
I think, this is a bug!!
It certainly sounds like it could be a bug. Could you log it at the feedback centre: http://lab.msdn.microsoft.com/productfeedback/default.aspx
-Jamie
