|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
AS 10 and hierarchical tree
Made a form which uses a hierarchical tree for navigation.
The record group for this tree is initialized in a WHEN-NEW-FORM-INSTANCE. This works fine on my laptop, where I use database 9, developer 10g. In production database 8.1.7.2 is used and AS 10. If I try to deploy my form with the application server (the production environment) the navigation tree isn't displayed. What can be the problem ? It seems to me, that the WHEN-NEW-FORM-INSTANCE trigger is not evaluated. Here is the code: ----------------------------------------------------------------- DECLARE htree ITEM; v_ignore NUMBER; rg_navi RECORDGROUP; tp_id TAB_PAGE; -- BEGIN -- Find the tree itself htree := FIND_ITEM('NAVI_BAUM.HTREE'); --Check for the existence of the record group. rg_navi := FIND_GROUP('navi'); IF NOT ID_NULL(rg_navi) THEN DELETE_GROUP(rg_navi); END IF; --Create the record Group rg_navi := CREATE_GROUP_FROM_QUERY('rg_navi', 'SELECT 1 ,level ,mytext ,NULL ,TO_CHAR(nummer) '|| 'FROM NAVIGATION '|| 'CONNECT BY PRIOR nummer = mylevel '|| 'START WITH UPPER(comment) = ''STARTELEMENT'' '); --Populate the record group with data v_ignore := POPULATE_GROUP(rg_navi); --Transfer the data from the record group to hierarchical tree and cause it to dispaly FTREE.SET_TREE_PROPERTY(htree ,FTREE.RECORD_GROUP ,rg_navi); END; ------------------------------------------------------------------- By the way another question: If the AS is used for web-deployment of a form, is it enough to have a browser installed on a "user pc" ? Or has to be installed some additional oracle software on the "user pc" ? Which one ? |
|
#2
|
|||
|
|||
|
I have seen Trees working in 10g, but only from record groups, perhaps try to use a record group and not create it from the trigger.
The code (my quick look) seems OK - and appears to fit Oracles examples. Are you sure the correct Hierarchicy exists as expected on the target database? You should only need to have a browser on the client, although it will need to download some additional bit the AppServer should be able to provide these elements. |
|
#3
|
|||
|
|||
|
Is it a problem, that the forms are developed under Windows XP and then copied to the AS - directories (under Linux). Do I have to recompile them under Linux ?? How is this done ?? I read something from f90genm.sh .
Which user should compile the forms, and how ? I made some simple forms (select on a table), copied the form also to AS-directory, form starts but the table is not selected (triggered with a WHEN-BUTTON-PRESSED), if I use the standard symbols in the menu bar, then the query is executed (and the table is selected). |
|
#4
|
||||
|
||||
|
I thought that you would have to compile the forms on UNIX if developed on Windows - but you seem to be OK just transfering the FMX (if Im reading correctly?)
but I found this: (hope it helps) Quote:
Quote:
|
|
#5
|
|||
|
|||
|
Also read this....
http://www.orafaq.com/msgboard/tools/messages/16397.htm |
![]() |
| Viewing: Dev Shed Forums > Databases > Oracle Development > AS 10 and hierarchical tree |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|
|