Greetings all
I have a form that reads a access memo field. I can query the database to
get the info in the memo field without a problem...but when i try to update
the data i get a exception. The text in the memo field can be large. It
seens to throw the exception only when large amounts of data is being
updated. The following is the update code : rtNotes is a richtext textbox..
any help will be appreciated
Dim mNotes As String = rtNotes.Text & String.Empty ''
sqlStatement = "update master set Cust_Notes = ' " & mNotes & " ' where
str(trim(Master Id)) = " & _
"' " & Trim(glbLookup) & " '"
SetUpDataBase()
Try
cmd.ExecuteNonQ uery()
Catch Ex As Exception
MsgBox(Ex.ToStr ing)
End Try
btnSave.Enabled = False
With Label6
..Text = "Locked"
..ForeColor = Color.Black
End With
I have a form that reads a access memo field. I can query the database to
get the info in the memo field without a problem...but when i try to update
the data i get a exception. The text in the memo field can be large. It
seens to throw the exception only when large amounts of data is being
updated. The following is the update code : rtNotes is a richtext textbox..
any help will be appreciated
Dim mNotes As String = rtNotes.Text & String.Empty ''
sqlStatement = "update master set Cust_Notes = ' " & mNotes & " ' where
str(trim(Master Id)) = " & _
"' " & Trim(glbLookup) & " '"
SetUpDataBase()
Try
cmd.ExecuteNonQ uery()
Catch Ex As Exception
MsgBox(Ex.ToStr ing)
End Try
btnSave.Enabled = False
With Label6
..Text = "Locked"
..ForeColor = Color.Black
End With