Hi I have a form with a Varchar field for notes. I can only get about 4k in the varchar field I use this code in a EEP that adds paragraphs to the end of the Varchar field. It works great up to a point then quits working as if I hit a limit like 4k for a note field.
No errors on Trace. I knew at one time the Property command in 7.5 was limited to I think 1500 characters So I had to use this Update method but it looks like I hit another limit some where but I do not know what? This is the major request we have, larger notes SET VAR vadjdesc varchar = NULL SELECT spdesc INTO vadjdesc FROM soapcode + WHERE spcode = .vscode AND COUNT = .vsprad ORDER BY spver SET VAR vadjdesc2 varchar = NULL SET VAR vadjdesc2 = (SRPL((SRPL((SRPL(.vadjdesc, + '[fname]',.vfname,0)), '[heshe]',.heshe,0)),'[himher]', .himher,0)) UPDATE ptsoap SET subj = (subj + .vadjdesc2 + ' ') + WHERE ptspid = .vptspid PROPERTY table ptsoap 'refresh' Thanks Marc
