[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Out of Memory error



Hello,

I'm getting an out of memory error when I run a report and was hoping
someone out there might be able to help.  The report works fine normally
but I run into problems when the report tries and processes a large
string.  I am passing a field from the database that can be up to 32,000
characters long into a string and running through the print routine
below to search for the carriage-return character chr(13), print the
text up until the carriage-return and then search for it again in order
to format the printed output in the same way the user has input the
data.

begin-procedure print_long_description ($ldtext, #ppos, #wpos)
        let $ldtext_print = $ldtext
        let #found = instr($ldtext_print, chr(13), 0)
        While #found > 0
                let $printtext = substr($ldtext_print, 1, #found - 1)
                let $ldtext_print = substr($ldtext_print, #found + 2,
length($ldtext_print) - #found)
                print $printtext        (+1,#ppos) wrap #wpos 5000
                let #found = instr($ldtext_print, chr(13), 1)
        End-While
                print $ldtext_print     (+1,#ppos) wrap #wpos 5000
end-procedure ! print_long_description

The data that is causing the error has a field that is 22,217 characters
long.
I am working with Workbench for Windows 95/NT and going against an
Oracle8 database.  Any thoughts on how I can get rid of the out of
memory error?  Are there any SQR settings for strings that I should look
at and modify?

Thanks,
Julie Waggoner