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.
<<winmail.dat>>
