I will add to Buddy's comments that I find the most appropriate way to run 7.x is using the -a switch. All updates and installs are done using the "server" alternative. This way, I can work with a released version for my clients, and yet still run 7.1.80.xxx without any interference. Each version sees its own files using the -a on startup.
--- "Walker, Buddy" <[EMAIL PROTECTED]> wrote: > Chuck > A few things to look for. > > 1. Check and make sure all variables are set before while loop. If you are > using while loop > within a while loop again make sure all variables are set before first while. > Do not clear any > variables within any while loop. You can set them back to null if need be. > > 2. Exit R:Base and clean up all $$$ files. > > 3. Connect to database and set scratch to a temp folder. > > 4. Make sure you have the current and only one of RBase 7.x MSG and DLL > files. > > Hope this helps > > Buddy > > ________________________________ > > From: [email protected] on behalf of [EMAIL PROTECTED] > Sent: Sun 4/3/2005 5:01 AM > To: RBG7-L Mailing List > Subject: [RBG7-L] - Insufficient Buffer Space to Process Expression (2136) > Error > > > 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]
