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,
------------------------------------------------------------------------
*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
