Solved

sql*forms question

Posted on 1998-03-09
8
836 Views
Last Modified: 2010-05-18
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
Comment
Question by:mmeadows
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
  • 2
8 Comments
 
LVL 1

Expert Comment

by:yesnaud
ID: 1082591
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
 

Author Comment

by:mmeadows
ID: 1082592
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
 
LVL 1

Expert Comment

by:yesnaud
ID: 1082593
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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Accepted Solution

by:
robnhood earned 100 total points
ID: 1082594
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
 

Author Comment

by:mmeadows
ID: 1082595
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
 

Expert Comment

by:robnhood
ID: 1082596
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
 

Author Comment

by:mmeadows
ID: 1082597
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
 

Author Comment

by:mmeadows
ID: 1082598
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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows how to recover a database from a user managed backup

717 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question