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<mailto:[email protected]> Sent: Thursday, June 25, 2009 12:54 PM To: RBASE-L Mailing List<mailto:[email protected]> 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<mailto:[email protected]> Sent: Thursday, June 25, 2009 11:49 AM To: RBASE-L Mailing List<mailto:[email protected]> 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<mailto:[email protected]> To: RBASE-L Mailing List<mailto:[email protected]> 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
