Re: runform windows for FORMS3

John Peat <john_at_peatj.demon.co.uk> wrote:
>
> In article: <1995Jul10.110930.2134_at_pat.uwe.ac.uk> lm-gardn_at_uwe.ac.uk (LM Gardner) writes:
> >
> > Hi
> >
> > Does anyone know if there is a RUNFORM for MS Windows that
> > works with SQL*FORM 3 .inp/.frm files?
> >
 

> There is one, as the other replies state, but it will only work against a LOCAL kernal (e.g. DOS
> ORACLE or PO7) in Standard Mode. It works over SQL*NET under 3.11 etc. fine!
>

We just recently implemented RUNFORM 3 under Windows Enchanced Mode. It took us 3 different attempts (NOT a fun or easy task) and finally with a LOT of trial and error, got it to work. Of course our 1st attempt was the Standard Mode approach which kind of 'worked' but was slow and very unstable. The setup running under enchanced mode seems to work very well. I'll try to outline what we did and hopefully, I can remember it all.

1. The version of RUNFORM we are using is 3.0.16.9.5 for Windows.
2. We are running DOS 5.0 or higher
3. The amount of conventional memory reported while in the DOS box on my machine is
4. I don't know what the minimum amount of coventional memory required is, but I do know that you need quite a bit. We spent a LOT of time trying to put as much stuff into HIGH and EMS memory so as to free up enough conventional memory. (A lot of trial and error.).
5. These 2 lines must exist in the CONFIG.ORA file:

		DYNAMIC_MEMORY=3000
		MACHINE_TYPE=J

5. I have the following lines in my CONFIG.SYS file:                 

		DEVICE=C:\WINDOWS\HIMEM.SYS
		DOS=HIGH,UMB
		DEVICE=C:\WINDOWS\EMM386.EXE 2048 RAM

6. My PATH statement contains the following (in order):
		C:\ORACLE6\PBIN;C:\ORACLE6\BIN

7. Before starting WINDOWS, run SQLDNT only. (Do NOT run SQLPME).

8. Once in Windows, you must start RUNFORM by specifying the EXE!!  (ie. runform.exe formname). If you don't, then the RUNFORM.COM might be picked up and this won't work under windows.

I hope I remembered everything. This setup is a little touchy, so if it doesn't work the first time, keep trying. Because it does work. Good luck!!

Feel free to e-mail if you need any more help.

Ruth Whitis
whitisr_at_isco.purdue.edu

P.S. I can run RUNFORM under DOS or Windows without changing anything in my setup. Received on Fri Jul 21 1995 - 00:00:00 CEST