| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: sql*forms question from a newbie
This can be a bit confusing. The trick to Form3 is that you can save your form (source) in two ways and what's happening here is that the two methods are confusing you.
You can either store your forms as a UNIX flat file. This is the .INP file you started with. Alternatively you can store your form (source) away to database tables as well or instead of. Most people I know do not store forms in database tables unless you need to reference an object in the form into another one - then you have to. Most I know work from 'source' files (.INP). The follwing menu items from the designer are usefull.
LOAD - read in a source (.INP) file as the current form. OPEN - select and read a form from the database tables source. SAVE - Save the current form to the database tables source.GENERATE - Fromteh current form. Write the source file (.INP) to the UNIX fiel system and also generate the 'executable' runtime file (.FRM) to the UNIX file system.
So, if you are using .INP files then you want to LOAD, modify and GENERATE in that order to maintain your source. And if using the forms tables repositary you need to OPEN (then you get the select list), modify, GENERATE (only for the purposes fo getting the runtime (.FRM) out, and then SAVE. Be very careful of using the two forms of source at the same time. It's easy to get confused.
Hope that clarifies things a bit.
Alan
-- Alan D. Mills To email remove NOSPAM from address. Martin Meadows <mmeadows_at_indy.net> wrote in article <350C2332.7817_at_indy.net>...Received on Mon Mar 16 1998 - 00:00:00 CST
> Which guru among you can explain sqlforms30 Open, Load & Help/List
> Forms?
>
> Here's what I know: if I have "the_screen.inp", for example, file in a
> unix dir and I cd to that directory, and then run sqlforms30, I can not
> use help/list form to see the name of the thing & I also cannot Open the
> thing. I can, however, load it. Once I've loaded it, I know I can use
> image/painter & work with it. This I learned without the benefit of
> tutorial or text.
>
> After I made a change to the_screen.inp I saved it. I then exited
> sqlforms30 and restarted it to see what I could see. I now have
> "the_screen" in my help/list forms
> output & can select it ... but I'm not sure what selecting it actually
> does. I can now
> also "open" the_screen but again, I'm not sure what this is doing.
> Finally, when I "load" the_screen & use image/painter it shows me my
> original screen without the changes I made earlier.
>
> Where did my new version of the_screen go? How do I save the_screen.inp
> over the top of the_screen.inp file that's in the unix directory that
> I'm in?
>
> Thanks for your assistance,
> Martin Meadows
>
 |
 |