[RBASE-L] - Re: Limit to Long Varchar or Var for Varchar

[MDRD]

Doing this from the R> I get   Warning new rows will be truncated
UPDATE ptsoap SET subj = (subj + .vadjdesc2 + 'xxxxxxxxxxxxxxx 33333333333 
')  WHERE custnum = 4545 and ptspid = 4701

So, I guess I need to make the Long Varchar bigger???
The old note field was converted to Varchar by
ALTER TABLE ptsoap ALTER subj TO subj VARCHAR

List tab shows
No. Column Name        Attributes
--- ------------------ ------------------------------------------------------
  1 CUSTNUM            Type   : INTEGER
                       Consrnt: FOREIGN KEY REFERENCES PTINFO
                       Index  : SINGLE-COLUMN
                                Comment: aa
  2 date_con           Type   : DATE
  3 spdate             Type   : DATE
                       Index  : SINGLE-COLUMN
  4 subj               Type   : LONG VARCHAR

Under Design it shows Varchar with no length

I thought Long Varchar was variable in length?


Marc


--------------------------------------------------
From: "MikeB" <mbyer...@byerley.net>
Sent: Thursday, June 25, 2009 11:44 AM
To: "RBASE-L Mailing List" <rbase-l@rbase.com>
Subject: [RBASE-L] - Re: Limit to Long Varchar or Var for Varchar

Use a RichText field with VarChar datatype and set the RichText to 
PlainText.

----- Original Message ----- 
From: "MDRD" <mdrd...@sbcglobal.net>
To: "RBASE-L Mailing List" <rbase-l@rbase.com>
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