Forms :: How To Bind Hierarchy Tree Items To Text And Other Items
Jan 31, 2012
I have already done a hierarchy tree. Now I'd like to make it bind to text items. When i click a node, it should automatically be bound to text items.
My tree is about sections of students, now when i click a specific section to view its corresponding subjects it would be displayed on text items.
For example:
+Sections
+First Semester
+LM2
+LM3
+Second Semester
+LM4
+LM5
When i would click on LM2 node, its subjects should appear immediately.
View 1 Replies
ADVERTISEMENT
Dec 24, 2012
I want add a text item at run time depending on the number of values retrieved i want to change the number of text items. Is it possible at run time to add a text item?
View 1 Replies
View Related
Nov 24, 2010
I am working on form 6i.
i need to write validation on text fields like first name,last name,phone no,email id
i have to not allow special char.
View 3 Replies
View Related
Jan 21, 2003
I need to find all "report to" supervisors in a hierarchical chain. A binary search won't work, as each level may contain > 2 supervisors. Example:
1
2 3 4
5 6 7 8 9
10
10 reports to 9
9 reports to 4
5 and 6 report to 2
7 and 8 report to 3
2, 3 and 4 report to 1
Result for all reporting to 1 would be a table containing 2, 3, 4, 5, 6, 7, 8, 9, 10 (order is unimportant!).
I think I need to use recursion. I can do this in C; need code for PL/SQL??? (I can't get the "tree" to display well!)
View 4 Replies
View Related
Oct 4, 2010
I'm facing a strange problem with one of my client.
Sometimes the application hangs when they are typing in text item defined with 2000 or 4000 char long.
The application needs to be close manually.
The first time we faced the problem, we tought it was due to database locks but the DBA confirmed that everything was OK.
The OAS admin also tried to log the application but nothing special. So we tried to run the application using JRE instead of JINITIATOR and the problem disappeared.
So, my question is, is there known bug about using large text item in Forms 10G? and especially with JInitiator? I tried to find informations on metalink but found nothing.
View 1 Replies
View Related
Dec 30, 2011
I have created the Textitem with five instances.
i am trying to assign column values to text item through query.
if my table contain one record,it shown in textitems.But if my table contains more records it is showing ora-1422 err.how to solve it.
View 1 Replies
View Related
Feb 21, 2013
On a tabular form I have 50 columns each an input box , (basically 50 weeks of the year)
in these boxes I want to make them numbers only and max length 2
currently I have in the ELEMENT ATTRIBUTES for each column
OnFocus="javascript:this.maxLength=2"; onKeyPress="return numbersonly(this,event)";
( I have a function called numbers only in page 0 )
what I would like to do , to make it more maintainable is to remove all the calls in the element attributes of each column
and put it in 2 dynamic actions how would I go about this ?
I have tried using jquery selector of input:text to call javascript code on both events , Get focus and Key Press for every text box but its not working .
View 5 Replies
View Related
Apr 8, 2009
i have created a tree hierarchy....when the user clicks on any node,that particular form will open....But there is some problem...i click on form A,it opens.,...then i exit that form via a exit button on the toolbar....and then I click on form B on the tree....but first the form A only opens...and then again i exit form A, then form B will open..
i have written the following code in when_tree_node_selected trigger :
if condition then
call_form(path,no_hide,do_replace);
View 3 Replies
View Related
Jun 12, 2012
I have a hierarchy tree menu look like this
+GL
Accounts
Inform
+Export
Export Entry Form
+Security
New User Entry
when i click Gl==>Accounts, accounts form opens and i want call my forms and reports through nodes.
View 1 Replies
View Related
Jul 6, 2010
is there any way or loop to go through all items in a form and check them with a condition ???
View 5 Replies
View Related
Oct 12, 2010
when i am selecting a record from a LOV which is associated with a button on a tab page of a tabbed canvas; all the items on the tab page getting invisible. But when i navigate to another tab page and then come back to the former tab page all items reappearing.
What could possibly be the reason for this and how to restrict items from disappearing?
View 4 Replies
View Related
Jun 7, 2010
there are 3 radio buttons and 1 list item
i want different options to appear in the list item when choosing different radio buttons.
i've tried to compile the codes and there are no errors.
I dunno what went wrong.
B_DEV IS THE BLOCKNAME
LIST_ITEM IS THE NAME OF THE LIST ITEM
SEVEN_ELEVEN, MANNINGS, GNC ARE THE RADIO BUTTONS NAMES
FOR_BANNERS IS THE RADIO GROUP NAME
the following is my
DECLARE
[Code]....
View 2 Replies
View Related
Apr 21, 2011
I want to create two list items. one is for deptno and another is for empno in a single form.
Based on the selected deptno value from first list item i want to populate corresponding empno from second list item. I tried with the fallowing code, it's work fine but the second list is not clears with the existing empno's.
Code for Deptno List item
declare
cursor c is select deptno from dept;
cnt number := 1;
begin
clear_list('LI_DEPTNO');
[Code]...
Code for Empno list item in when_list_changed trigger for deptno list item
declare
cursor c is select empno from emp where deptno = :LI_DEPTNO;
cnt number := 1;
begin
it_id := Find_Item('LI_EMPNO');
clear_list(it_id);
for i in c loop
add_list_element('LI_EMPNO',cnt,i.empno,i.empno);
cnt := cnt + 1;
end loop;
end;
View 3 Replies
View Related
Apr 12, 2010
I've got a colleague that is trying to populate a list box item with a group of numeric values that represent highway route numbers.
The database view defines the route as a "number".
How can we create a numeric list box? The built-in functions populate_group, and populate_list both expect to get varchar2 parameters.
View 1 Replies
View Related
Feb 2, 2013
how can I have queries on long/lob items in form.
View 1 Replies
View Related
Jun 28, 2011
I have created two control items like organization and location and both items contains lovs.here i have to make location lov is dependent on organization.one org contains multiple locations. how to make this change?
View 1 Replies
View Related
Jan 24, 2012
May i know the triggers in forms 6i, which is applicable to all items,blocks and form.
View 9 Replies
View Related
Sep 25, 2010
my question is this that i have tlist items like
example:
A
B
C
D
E
F
G
H
how to save tlist items in database.
View 6 Replies
View Related
Dec 28, 2010
I am coming across a requirement wherein a databse cloumn is shred by 2 fields..( need to append the value to the data-base column for the 2nd field.
I dint test it yet but the form compiled with warning FRM-30431: Warning: Duplicate column name in same block...is it ok to further go or its not allowed at all?
View 3 Replies
View Related
Dec 8, 2010
My form has two list boxes and two buttons add and remove. As and when i click add button, the selected value from left hand side list item should get populated to right hand side list item. And When I click Remove button, it should do vice versa.
View 10 Replies
View Related
Apr 27, 2010
My technical envirment is Winxp, dev9i AS vers9.0.2, Jinit vers1.3.1.9, OracleDB9i.
i want to create a form conatining a BEAN item through which i want to insert and select a BLOB movie from a Table in a database.
View 3 Replies
View Related
Aug 21, 2010
I have build a form based on a table with 2 columns,one of which isprimary key. I have created a Button with name "Quit".For that i used when-button-pressed trigger with built in "exit_form". But when I run the form,with out any execution of query or any action if I press "Quit" button,it is not working
The error message is "FRM-40202 : Field must be entered" Then I used a trigger to the item with primary key.when-new-item-instance:
set_item_instance_property('CUTOMER.CUSTID',CURRENT_RECORD,REQUIRED,PROPERTY_FALSE);
While using this,the error is "unable to resolve reference to item customer.custid" Cutomer is block name & custid is textitem with primary key. canvas used is Tab canvas with 3 tab pages with master detail relation b/w thwm. The primary key is required compulsory at the time on inserting.
View 1 Replies
View Related
Aug 3, 2010
How to disable the Default Menu Items like (Edit - copy,Paste) in oracle Forms 10g.
View 1 Replies
View Related
May 14, 2011
Enable / Disable menu items for different users.
how to create different users give in demo files i am using 10gforms.
View 1 Replies
View Related
Feb 12, 2012
I want to ask what's wrong with my multi-record block.
When i click a node on my tree, it should display the records on it. For example, my root node is Sections, the parents are 1st sem and 2nd sem. In each sections in 1st sem, whenever i click a child node, it should display on display items. I have set its number of items displayed to 9. Since each sections have 9 subjects. The problem when i run it is that it displays many rows.
View 35 Replies
View Related
Jan 6, 2011
I have a requirement to select multiple values from a list item and do some manipulations with those values. I tried by integrating the LOV with a text item, but couldn't able to select multiple items. Is there a way to do multiple selection in a list item ?
View 1 Replies
View Related
Apr 8, 2013
In one of my form , there is some code "next_record;" in the key-next-item trigger of one field.Here before going to next record, it is executing the WHEN-VALIDATE-TRIGGER of all the items in that record.Is it the default behavior of oracle forms?Can we override this?
View 3 Replies
View Related
Nov 24, 2010
I have three blocks in my form , header,activity and item.One header can have many activities and one activity can have many items.I need to keep track of item value totals in header from items under each activity.
View 1 Replies
View Related
Aug 20, 2011
how to count how many items present in a particular data block in oracle forms 10g.whether it is a text_item or display_item or list_item etc is there any method to do this.
i have written this when-button pressed but the problem is how to get the next item name in the block
DECLARE
V_COUNT NUMBER:=0;
V_FIRSTITEM VARCHAR2(100):='';
BEGIN
GO_BLOCK('BLOCK_ITEMCOUNT');
V_FIRSTITEM := GET_BLOCK_PROPERTY('BLOCK_ITEMCOUNT', FIRST_ITEM);
LOOP
[code]....
View 3 Replies
View Related
Apr 4, 2012
i have (ship_master-ship_detail) receive material form.when open the form all the master items appears except receiver name and receiver id. when i select the receiver name and id thru lov...all the items (with send information)in ship_detail also comes up expect rec_qty.i put the rec_qty and save from.
now i want to insert(ship_detail) information in another table apart from ship_detail table. if that particular matrial already exist in table it shud only update receive quantity column with +. if i am receiving the material first time then it should just insert a record with ship_detail items.
so where should i write the insert and update.
View 1 Replies
View Related
