Solved

sql*forms question

Posted on 1998-03-09
8
779 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
 

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

 

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

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.

Join & Write a Comment

Suggested Solutions

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…
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

758 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now