Marc, I agree with Mr. Byerley.
You will not be able to do a simple concantenation because it resets to 4096. You will need to try his method or have the people actually use the RTF editor tool. -----Original Message----- From: "MDRD" <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Thu, 25 Jun 2009 15:35:06 -0500 Subject: [RBASE-L] - Re: Limit to Long Varchar or Var for Varchar Jan Could you try UPDATE VarcharTest SET VarcharInfo = (VarcharInfo + 'vvvvvvvvvvvvvvvvvvvvvvvvvv' ) WHERE ....... and see what happens Thanks Marc From: jan johansen Sent: Thursday, June 25, 2009 2:52 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Limit to Long Varchar or Var for Varchar Marc, I just did a test in V8. I created a simple table. CREATE TABLE `VarCharTest` + (`VarCharID` INTEGER , + `VarCharInfo` LONG VARCHAR ) I created a simple form with 1 DB Rich-Edit I copied and pasted a document into the Rich-Edit and saved and exited. The row then had info in the varchar with a lenth of about 8k. I then copied and pasted the document 9 more times and ended up with the row having a varchar with a lenth of about 80k. Looks fine to me. Check to make sure you are using the right objects and that your column is set properly. Jan -----Original Message----- From: "MDRD" <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Thu, 25 Jun 2009 14:16:18 -0500 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
