OLEDB MS-SQL Server

[MSchmidt]

inside a function we make an SQL update for 18 columns.

the bind variables have a special form

update TABLE set Column1 = :hWnd.nNumber1, column2 = :hWnd.nNumber2.... , column18 = :hWnd.number18

so the variables nNumberX are local frm variables. The handle of the form we send as parameter to the function.

the sql Update works fine with ODBC Connection

with OLE DB the function only works with 17 columns

divided in two parts the sql update works fine with the same values
columns in the database: decimal(7.2) null
all variables have a value (zero or greater and less than decimal 7)

failure message:
Ungültiger Zeichenwert für Konvertierungsangabe.; (conversion not valid)

win 7 64 prof German SQLServer 2008