mmeadows
asked on
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
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
ASKER
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
> 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
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...
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...
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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
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
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
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
ASKER
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
Martin
ASKER
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
Martin
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