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

Post found bugs and possible workarounds.
rentz

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

Post by rentz » 11 Jul 2013, 10:29

Hi,

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.

Ralf

Kumuthini Ragavan

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

Post by Kumuthini Ragavan » 11 Jul 2013, 13:12

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

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

Post by rentz » 12 Jul 2013, 06:29

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.

Return to “Bug Reports”

Who is online

Users browsing this forum: [Ccbot] and 0 guests