len (memofield.text) error when length exceeds 2036 characters
Posted on 2003-03-12
In a procedure(click-event) I store text from a frm-textbox into a table-memofield using an sql-update.
When len(frm-textbox.text) exceeds 2036 characters(including spaces) following error occurs:
"could not update; currently locked by another session on this machine"
The frm-interface closes, record gets not updated.
When first creating the record there is no problem in storing more then 2036 characters into record/table-memofield.
But after creation edits are no longer possible. Deleting characters in the table-memofield, so len < 2037 makes editting possible again, without errormessage.
Any ideas on limitation/errormessage on length memofields, and how to overcome these?
I don't want to use Solution like tbxverslag_on change (too much triggeroverhead)
if len(me.tbxverslag.text)>2036 then
msgbox "You've reached max.size of textbox"