if you update more than one NTEXT column via bind variable and ODBC on an SQLServer database with one update, e.g.
update table1 set text1 = :ls1, text2 = :ls2, text3 = :ls3, text4 = :ls4 where id = :nID
all columns after the first empty long string will be updated with an empty string. If in my example ls1, ls3 and ls4 are not empty and ls2 is empty, text1 will be filled and text3 and text4 will be empty. Using SqlSetLongBindDatatype() does not help.
The number of TEXT columns is irrelevant, it happens with 2 or more updated columns.
this is a known bug
TD-19033: When update statement has null value for a text columns, wrong columns get updated with wrong values.
already fixed in TD6.0 SP8 EMP5490 and also in 6.1 SP3r.
Please try using the SP3r or latest EMP and see if it fixes the problem.
So I don't think that this bug is already fixed.
Who is online
Users browsing this forum: [Ccbot] and 0 guests