I started with a new DB,
ALTER TABLE ptsoap ALTER subj TO subj VARCHAR (30000)
UPDATE ptsoap SET subj = (subj + 'ddddddddddddd ') WHERE custnum = 4545 and
ptspid = 4164
Error value will be truncated
I still only get about 4k in the Varchar field
Something is Strange and the Varchar is acting like a note field even from the
R>
Marc
From: Alastair Burr
Sent: Thursday, June 25, 2009 11:49 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: Limit to Long Varchar or Var for Varchar
either use Long Varchar:
LONG VARCHAR
Same as VARCHAR, with a length of 256 MB
or
VARCHAR
· Holds alphanumeric data; you must set the maximum length
· If you set the maximum length to a value over 32,767 characters, the
limit is ignored and defaults to 256 MB
Regards,
Alastair.
----- Original Message -----
From: MDRD
To: RBASE-L Mailing List
Sent: Thursday, June 25, 2009 5: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
------------------------------------------------------------------------------
No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 8.5.374 / Virus Database: 270.12.91/2201 - Release Date: 06/25/09
06:22:00
