[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 862
  • Last Modified:

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
0
mmeadows
Asked:
mmeadows
  • 4
  • 2
  • 2
1 Solution
 
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
Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

 
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
 
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

Featured Post

Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

  • 4
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now