Re: Undocumented SQL*Forms error FRM-40900 ???

Thus spake saimun_at_ncb.gov.sg (Saimun Julia):

>In article <930823165332.2081c172_at_bfsec> AMEBAN_at_bfsec.bt.co.uk (ALAN MEBAN (0232) 894313) writes:
>>The following error occurred on Friday afternoon:
>>
>> "FRM-40900 Unable to allocate record buffer. Clear form."
>>
> -------- <Stuff Deleted> ----------------------------------------------
 

>I am having the same problem, so far I have no idea how to solve it as well.
>I am running under NOS Vines 4.11(5).
 

>It seems like not enough buffer to hold all the query if you have a large recordto be retrieved d

I have had the same problem too, running on IBM compatible (MSDOS, Novell-net)

The client workstation can't hold all the records fetched in memory.

You should set a variable in you config.ora file I can't remember the details and I don't have them handy, but it is something like 'SET TMPDIR=<path>' (migth be TEMPDIR). Furthermore you should in SQL*Forms (design) set the number of Buffered records to a resonably amount. That is more than the number displayed.

Contact oracle support, they will tell you (They told me). Especially as some details will depend on the OS!

Anders Harder

| Anders Harder (harder_at_daimi.aau.dk) I learn mostly from my failures...      |
| Comp. Sci. Dept.| Private address:  it isn't that I don't learn from my     |
| Aarhus Univ.    | Ydunsvej 12       successes...                            |
| DK-8000  Aarhus | DK-8230 Aabyhoj   but I have more failures than successes!|
| Denmark         | Denmark           (Rune T. Kidde)                         |
-------------------------------------------------------------------------------