Solved

re-write 6i code in 11g forms

Posted on 2015-01-30
5
140 Views
Last Modified: 2015-02-06
hi how can i re-write this code in 11gR2 as set_input_focus is absolute
procedure PROC_FLD is
BEGIN
  if name_in('system.current_field') = 'SCR_NOHLP_FIRST_FIELD' then
     set_input_focus (menu);
  end if;
END;

Open in new window

0
Comment
Question by:chalie001
[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
  • 2
  • 2
5 Comments
 
LVL 35

Expert Comment

by:johnsone
ID: 40579698
I managed to find a copy of the Forms 6i documentation here -> http://download.oracle.com/otn_hosted_doc/forms/forms/A73074_01.pdf

According to that documentation:

/*
** Built-in: SET_INPUT_FOCUS
** Example: Directs the users input focus to the Menu when
** used with the only support parameter, MENU.
** Only has an effect on character-mode or
** block-mode devices.
*/

As this is cross posted in web development and java areas, I'm guessing your forms are not being run in character mode.  I believe that you can just remove the call to the function without changing functionality.

That is backed up by the last comment in this post -> https://community.oracle.com/thread/943276
0
 
LVL 22

Expert Comment

by:Helena Marková
ID: 40583402
As an addition to johnsone's answer you can also use Migration Assistant - frmplsqlconv.bat (it is a part of Forms installation).
0
 

Author Comment

by:chalie001
ID: 40583708
i did i replace it with null but how can i replace as it is absolute and how can  i do batch compile of library and forms
0
 

Author Comment

by:chalie001
ID: 40583994
am geting this error when i run migration assistance
Log written into File - C:\MigrationLog\logliib20922
processing ....
Log - C:\migrationform\CALMAIN.FMB touched : Mon Feb 02 14:55:46 CAT 2015
ERROR opening C:\migrationform\CALMAIN.FMB :oracle.forms.jdapi.JdapiException: FRM-10102: Cannot attach PL/SQL library LSPL_SET_LOV_VALID_USER_UNIT. This library attachment will be lost if the module is saved.
FRM-10102: Cannot attach PL/SQL library LGNL0001. This library attachment will be lost if the module is saved.
Check subclass and library dependencies
Log - C:\migrationform\CALMAIN.FMB released : Mon Feb 02 14:55:47 CAT 2015


------------------------------------------------------------
[End of Log]
0
 
LVL 22

Accepted Solution

by:
Helena Marková earned 500 total points
ID: 40585602
There is problem with path there. One option is putting all libraries to the directory where *.fmb are located.
0

Featured Post

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

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

Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This video shows how to recover a database from a user managed backup
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

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