Microsoft KB Archive/70841

From BetaArchive Wiki

PRSQL9103021: Dbmoretext() GP-Faults with a Pointer to a Null ID Number: Q70841

1.10 OS/2 buglist1.10

Summary:

PROBLEM ID: PRSQL9103021

SYMPTOMS Using dbmoretext() with a pointer to a null text value causes the server to GP-fault.

CAUSE The SQL Server txtptr statement returns a NULL pointer on an image or text value inserted as NULL.

RESOLUTION Update the NULL value with the following UPDATE statement:

  UPDATE table SET textcol = NULL