sql*forms question

Hi. I just discovered that I have inherited a 2000+ line file that I need
to be able to run with a command (inside an old Unix shell script) that
looks like this:
iap30 /usr/joe/joes_form.inp
Unfortunately, when the shell script hits this line it kicks out the
following message:
FRM-40011: Form was created by an old version  of SQL*Forms(Generate).

What does this mean exactly? Was the 2000 line script created by sql*forms (generate)? I really don't know much about Oracle & sql*forms. Is there anyplace on the internet where I can find a sql*forms tutorial?

Thanks,
Martin Meadows
mmeadowsAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

yesnaudCommented:
Hi,
FRM 40011: Form was created by an old version of Generate.
Cause: the FRM file was created with an old and incompatible version of Oracle Forms Generate.
Action: Regenerate the form or relink generate.

The sql*form runtime version you have on your pc/server is an older version than the one used to generate the file you inherited.
Solutions: install a new version of sql*form.
           Re-Generate the form with you older version.
           
you can find help on sql*form on one of oracle web sites.

http://technet.oracle.com

you need to subscribe but it's free.

Hope you will find the answer of your problem.

yesnaud@fdgroup.co.uk

0
mmeadowsAuthor Commented:
It may be my own fault for not making it clear that I know very little (almost nothing) about sqlforms. When the previous helper said:

> FRM 40011: Form was created by an old version of Generate.
>   Cause: the FRM file was created with an old and incompatible > version of Oracle Forms Generate.
>   Action: Regenerate the form or relink generate.

I don't have a clue how to perform this action! He/she assumes to much.

>   The sql*form runtime version you have on your pc/server is an >older version than the one used to
>   generate the file you inherited.
>   Solutions: install a new version of sql*form.
>              Re-Generate the form with you older version.
 
To some extent the helper is repeating his/her self.
             
>   you can find help on sql*form on one of oracle web sites.
>
>   http://technet.oracle.com
>
>   you need to subscribe but it's free.

Web sites? I haven't had much luck searching for one that does sqlform tutoring. Maybe that's really the biggest help you can provide: where can I find on-line sqlform tutoring? BTW, I went to technet.oracle.com & am awaiting subscription confirmation but it just looks like an on-line technical magazine to me.

>   Hope you will find the answer of your problem.
I thought that you were providing the answer to my problem. Sorry if my question was too vague.

Martin Meadows

0
yesnaudCommented:
Well what exactly do you know ?

Do you know how to generate a form with sql*form?

Do you know where your runtime is installed ?

Do you know from where you get your form ?

Do you know with which version this form has been compiled ?

Ah, technet.oracel.com, if you go to technical information link and then documentation library link, you will find all the docs you need about oracle software... included sql*form...


0
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

robnhoodCommented:
G'Day Martin;

Have you confirmed that your inherited unix script did successfully run previously?  I suspect it didn't.  iap30 accepts a compile SQL*Form file as a parameter and not a raw text input file.  I suggest you try this out:
  - locate joes_form.frm
  - replace joes_form.inp with joes_form.frm in your unix script

To locate the joes_form.frm file in unix use the find utiltity, as in:
   find / -name joes_form.frm -print

If you could not find joes_form.frm, you need to generate joes_form.inp and the output would be joes_form.frm which could then be used as a parameter for iap30.

Hope this helps.

Dutch
Standard disclaimer applies
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
mmeadowsAuthor Commented:
Well, robnhood seems to have answered my question better than yesnaud. Actually, I've learned quite a bit at this point from an oracle newsgroup. By now I can see that my original question wasn't a particulary good one. For one thing: the error message I saw wasn't on joes_form.inp it was actually on joes_form.frm and the reason I got the error message was actually because when my shell script tried to run joes_form.frm it couldn't find it.

So, bad question on my part, bad error message on oracles part. Thanks to yesnaud & robnhood for attempting to answer my question.

By the way, I get the feeling that robnhood didn't actually see my follow-up question ... or perhaps he did & he isn't required to think about it. Yesnaud at least attempted to tell me where I might find a sql*forms tutorial on-line ... although I still don't know where I can find one. I filled out a subscription for that site & never got a confirmation letter from them so I don't believe I can actually even go look at any potential sql*forms stuff.

Finally, I'm new in experts exchange & I just saw some of the history of yesnaud's answers & I see that it's not unusual to offer 5 or 10 points for the answers to a question. When I said 100 points for this question I was shooting in the dark. I guess after this I'll know better how the game is played. What use are the points that robnhood & yesnaud are accumulating?

Thanks for your assistance,
Martin Meadows

0
robnhoodCommented:
Martin;

 Do not know of any on-line SQL*Forms tutorial at the moment.  If ever you come across one would appreciate if you'd bother informing me (robnhood@mozcom.com) since I'm  still starting out with Forms.

Thanks, regards and be seeing you around.

Dutch aka robnhood
0
mmeadowsAuthor Commented:
Okay, robnhood. I've submitted that question to experts-exchange so I'll let you know if anyone comes up with anything. At the present, I don't know of any. However, I am finding that the HELP in sql*forms isn't too bad. Unfortunately, that's all the doc I currently have.

Martin
0
mmeadowsAuthor Commented:
Okay, robnhood. I've submitted that question to experts-exchange so I'll let you know if anyone comes up with anything. At the present, I don't know of any. However, I am finding that the HELP in sql*forms isn't too bad. Unfortunately, that's all the doc I currently have.

Martin
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.