OLEDB MS-SQL Server

General discussion forum about all databases other than SqlBase.
MSchmidt
Germany
Posts: 299
Joined: 03 Jul 2017, 09:28
Location: Germany

OLEDB MS-SQL Server

Post by MSchmidt » 29 Mar 2010, 16:00

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

Return to “General Discussion”

Who is online

Users browsing this forum: [Ccbot] and 0 guests