9.5 (64) -Bob
----- Original Message ----- From: "Albert Berry" <[email protected]> To: "RBASE-L Mailing List" <[email protected]> Sent: Thursday, May 7, 2015 11:42:23 AM Subject: [RBASE-L] - Re: SRPL function followup Are you using 9.5 (64) or 9.5 (32) -- just a thought. Albert On 5/7/2015 10:38 AM, [email protected] wrote: I have also tried the following in a temp table : R>list traw Temporary Table: traw No. Column Name Attributes --- ------------------ ------------------------------------------------------ 1 file_content Type : LONG VARCHAR Current number of rows: 1 R>set var x = (slen(file_content)) in traw R>sho var x 60192 R>update traw set file_content = (SRPL(File_Content,.vFind,.vReplace,0)) <WARNING> New value will be truncated. (2570) Columns have been updated in 1 row(s) in traw R>set var x = (slen(file_content)) in traw R>sho var x 4092 I also find I cannot add two long varchar variables together that are 30,000+ characters. R>set var x = (slen(.vsrpl)) R>sho var x 30000 R>set var y = (slen(.vhold)) R>sho var y 32768 R>set var z long varchar = null R>set var z = (.vsrpl + .vhold) <WARNING> New value will be truncated. (2570) R>set var x = (slen(.z)) R>sho var x 32768 A long varchar is stated to be 256mb. Is there something I am missing? Thanks, ----- Original Message ----- From: "Bob Thompson" <[email protected]> To: "RBASE-L Mailing List" <[email protected]> Sent: Thursday, May 7, 2015 10:48:32 AM Subject: [RBASE-L] - SRPL function Is there a limit on the SRPL function in terms of length? I have a long var char variable that is 60,000 characters in length. I perform a SRPL function on it and it gives a message that "new value will be truncated". The resulting variable is then 32768 characters long. The resulting variable is a long varchar type as well. Version 9.5 64 Bob Thompson LaPorte, IN 219-363-7441 Sent from my iPod -- A democracy ..." can only exist until the majority discovers it can vote itself largess out of the public treasury." Attributed to Alexander Fraser Tytler 1747-1813
