How to Handle Inserts & Updated to CLOB Field > 4000 chars
Posted: Tue 07 Dec 2010 17:30
I am using the following Statement it works fine if the comments are less then 4000 characters, buit fails with error String litral too long, when using more then 40000 characters.
Dim Qry As String = String.Format("UPDATE PTS.LLW_T_LLW SET C_LL24_COMMENT='{0}', Updatedby_security_ID_FK={1} WHERE LLW_ID_PK={2}", LLW.LLW24_Comments, LLW.Updatedby_security_ID_FK, LLW.LLW_ID_PK)
Dim irowsAffected As Integer = Me.ObjectContext.ExecuteStoreCommand(Qry)
I would additinally also like to know, if this will also be a problem when using entities from entity model.
Dim Qry As String = String.Format("UPDATE PTS.LLW_T_LLW SET C_LL24_COMMENT='{0}', Updatedby_security_ID_FK={1} WHERE LLW_ID_PK={2}", LLW.LLW24_Comments, LLW.Updatedby_security_ID_FK, LLW.LLW_ID_PK)
Dim irowsAffected As Integer = Me.ObjectContext.ExecuteStoreCommand(Qry)
I would additinally also like to know, if this will also be a problem when using entities from entity model.