My most common way to produce this error is to have an unclosed parenthesis or
a missing line
continuation + or an unclosed IF. R:Base is then confused into thinking the
whole file is a line
of data. Use R:Style to find the error.
--- [EMAIL PROTECTED] wrote:
---------------------------------
Hello all you smart people. I'm
trying to parse some
incoming text (converted from a PDF). I have imported the text into Table_1.
Each row in Table_1
contains keywords, followed by the data that I want (with variable spaces
before the keywords and
between the keyword and the data. Table_2 contains the keywords and associated
column names.
I first project a temp table to hold the result. I have set up a declare
cursor1....fetch
vKeyword...and a while loop to step through the keywords. I then use declare
cursor2...where
Field_1 contains 'vkeyword' to step through the rows. I am using lots of
functions SLEN, SGET,
ISSPACE, STRIM to parse my data. During processing I get the 'Insufficient
Buffer Space to
Process Expression (2136) Error'.
It seems loose everything and reset the buffer. It will continue processing
until the error
appears again.
Am I doing something stupid? Is there a way to make the buffer larger? Is there
a way to clear the
buffer prior to doing the next Table_1 fetch? I have found the
Microrim_Tmpmaxblk in the help
file. It talks about the buffer for temporary tables. Is this where expressions
process, or is it
a buffer for accessing/indexing the data in the temp table? I hope one of you
smart people can
point me in the correct direction.
Albert Berry
Management Consultant
RR2 - 1252 Ponderosa Drive
Sparwood BC, V0B 2G2
Canada
(250) 425-5806
(250) 425-7259
(708) 575-3952 (fax)
[EMAIL PROTECTED]
