Use a RichText field with VarChar datatype and set the RichText to
PlainText.
----- Original Message -----
From: "MDRD" <[email protected]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Thursday, June 25, 2009 12:29 PM
Subject: [RBASE-L] - Limit to Long Varchar or Var for Varchar
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
