Dennis You code seems to work but if I do this UPDATE ptsoap SET subj = (Subj + 'vvvvvvvvvvvvvvvvvvvvvvvvvv' ) WHERE custnum = 4545
Back to 4k and your stuff is deleted Marc From: Dennis McGrath Sent: Thursday, June 25, 2009 3:05 PM To: RBASE-L Mailing List 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
