Solved

sql*forms question

Posted on 1998-03-09
8
819 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
  • 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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

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

Active Directory Webinar

We all know we need to protect and secure our privileges, but where to start? Join Experts Exchange and ManageEngine on Tuesday, April 11, 2017 10:00 AM PDT to learn how to track and secure privileged users in Active Directory.

Question has a verified solution.

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

Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.

828 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