TD-19033: Update of TEXT columns on SQLServer with ODBC

[rentz]

Hi,

if you update more than one NTEXT column via bind variable and ODBC on an SQLServer database with one update, e.g.

Code: Select all

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.

Ralf

[Kumuthini Ragavan]

Hi Ralf

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.

Thank you
Kumuthini Ragavan

[rentz]

We are using the latest SP and EMP (Version 6.1.3.35629-SP3r Build 35629).
So I don't think that this bug is already fixed.