Dennis,
I was just posting when your message came in.
I tried the following;
SET VAR vOrigVarChar VARCHAR = NULL
SET VAR vupdatevarchar VARCHAR = ('iiiiiiiiiiiiiiiiiiiid')
SELECT VarCharInfo INTO vOrigVarChar INDIC ivOrigVarChar FROM VarCharTest
WHERE VarCharID = 1
UPDATE VarCharTest SET VarCharInfo = (.vOrigVarChar + .vupdatevarchar) WHERE
VarCharID = 1
When I did this I got the message that the column would be truncated.
Jan
-----Original Message-----
From: Dennis McGrath <[email protected]>
To: [email protected] (RBASE-L Mailing List)
Date: Thu, 25 Jun 2009 15:05:47 -0500
Subject: [RBASE-L] - Re: Limit to Long Varchar or Var for Varchar
Well, it is obvious that the form enter the data correctly.
It is the update command that is breaking.
Try
Set var vSubj varchar
Select subj into vSubj from ptsoap WHERE custnum = 4545
Set var vSubj = (.vSubject + 'iiiiiiiiiiiiiiiiiiiid ')
UPDATE ptsoap SET subj = .vSubj WHERE custnum = 4545
Dennis McGrath
From: [email protected] [mailto:[email protected]] On Behalf Of MDRD
Sent: Thursday, June 25, 2009 2:16 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: Limit to Long Varchar or Var for Varchar
Man this is nuts
I did
Edit all from table where custnum = 4545...
Double click the Varchar field
I pasted several paragraphs until I had 200 lines and 18326 bytes
I put 11111111111 222222222222222 3333333333 between the paragraphs I cut
and pasted
to make it easy to see what I was doing
Exit Save ...
Edit using Form, looked in form and all the data was there
UPDATE ptsoap SET subj = (subj + 'iiiiiiiiiiiiiiiiiiiid ') WHERE custnum =
4545...
edit all from ptsoap WHERE custnum = 4545
ALL data past 4k is now Lost and deleted
Then I went to RRBYW14
Contacts
added VC column Varchar repeated the same process cutting and pasting a
bunch of text to get 18 k
Update ...........
got the same results
18k dropped to 4k after the Update command
So what is the secret to get a Varchar to hold more than 4k?
Marc
From: jan johansen
Sent: Thursday, June 25, 2009 12:54 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: Limit to Long Varchar or Var for Varchar
Marc,
This is starting to sound like a structure issue.
A while back I had a table that had 4 notes in it. I started having
trouble with it as people were getting verbose in their typing.
I had to split the table into 4 seperate tables with 1 note in each
table.
In 7.6 the row length is limited to 4096.
I don't know if that is what is going on for you or not.
Jan
-----Original Message-----
From: "MDRD" <[email protected]>
To: [email protected] (RBASE-L Mailing List)
Date: Thu, 25 Jun 2009 12:39:07 -0500
Subject: [RBASE-L] - Re: Limit to Long Varchar or Var for Varchar
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
