| record groups [message #86092] |
Tue, 31 August 2004 03:30  |
revathi
Messages: 6
Registered: July 2000
|
Junior Member |
|
|
hai
how to create& populate the non-query record groups.
i want to create lov based on the non query record group and assign it to text item at runtime thanks in advance
|
|
|
|
|
|
| Re: record groups [message #86094 is a reply to message #86093] |
Tue, 31 August 2004 03:54  |
madhumitha
Messages: 2
Registered: August 2004
|
Junior Member |
|
|
hai vamsi
thanks for your response
but how to assign create record group to an text item as lov at run time
can u please write the complete code for that
bye madhumitha
|
|
|
|
| Re: record groups [message #86124 is a reply to message #86094] |
Thu, 02 September 2004 00:42 |
 |
vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH
|
Senior Member |
|
|
hi madhu,
i found a partial solution.
u have to create a lov and record group at design time.
and u can over wirte the record group in the lov dynamically. but the number, datatypes of the columns in the record groups, which are created at design time and run time muct be same.
u can use the following functions
create_group_from_query
populate_group
set_lov_property
ex:-
i have created a record group with some other name at design using the query, select empno,ename from vamsi_emp1.
in runtime we can change the record group
declare
vamsi_rg_id recordgroup;
x number;
begin
vamsi_rg_id := create_group_from_query('vamsi_rg','select empno,ename from vamsi_emp2');
x:= populate_group('vamsi_rg');
set_lov_property('lov5',group_name,'vamsi_rg');
end;
|
|
|
|
| Re: record groups [message #86129 is a reply to message #86124] |
Thu, 02 September 2004 04:01 |
madhumitha
Messages: 2
Registered: August 2004
|
Junior Member |
|
|
Hai Vamsi
Now it' comming perfectly
Thanks a lot.
one more doubt please
how to impement the key function triggers
just i want to write some code in key function like
key-F1 trigers . i tried ,but it's performing F1 actual functionality.how to override the code
please help me
thanks in advance
|
|
|
|
| Re: record groups [message #86131 is a reply to message #86129] |
Thu, 02 September 2004 06:18 |
|
vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH
|
Senior Member |
|
|
hi madhu,
i got this from forms builder help.
You can attach Key-Fn triggers to 10 keys or key sequences that normally do not perform any Form Builder operations. These keys are referred to as Key-F0 through Key-F9. Before you can attach key triggers to these keys, you or the DBA must use Oracle Terminal to map the keys to the appropriate functions.
1. The key description shown in the default menu's HelpKeys menu will always be for the form-level trigger defined for that key. If there are any lower-level triggers (e.g., block-level triggers) that are also defined for the key, their descriptions will be shown when focus is in the lower level (e.g., the block) and [[Show Keys]] is pressed, but they will not be displayed in the default menu's HelpKeys menu.
2. Not all keys can be remapped on certain operating systems. For example, the Microsoft Windows operating system always displays the Windows Help System when F1 is pressed, and attempts to close the application window when Alt-F4 is pressed.
Key mappings are done in following Resource files:
Client/Server FMRUSW.RES
Web mode FMRWEB.RES
i don't know how to put an entry in those files.
by
vamsi
|
|
|
|
| Re: record groups [message #86144 is a reply to message #86131] |
Fri, 03 September 2004 03:51 |
Friend
Messages: 33
Registered: January 2002
|
Member |
|
|
hai vamsi,
what u send regarding record groups is for
"Query record group"
at design time ur giving one query and at run time ur changing that.
but in case of "non query record group"
the structure has to create & change at runtime
pls can u give any example on this
thanks in advance
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
