Missing Long Bind before write Long

[sliddle]

We are getting the following error (ERR00001.QRP ) when inserting into a table ( Sql Server 2000 ) using Centura application. The insert statement is shown below and contains 2 long string variables :mlSECURITY_PREFTEXT, :mlSECURITY_PREFSQL
The insert problem occurs intermittently as described in the user fault log.

ErrorReport.txt

[Jean-Marc Gemperle]

Hi,

You are using TD 5.1 SP3 right ? What is the database attribute for the column, is it TEXT?

Can you please make sure before the insert you are using a LONG STRING ( this is required for any attribute > 255) and you are calling SqlSetLongBindDatatype() to 22 Text for the bind variable used (the default long string bind is TEXT but you might have changed it).
There is an issue though with TD 5.1

Cheers
Jean-Marc