Oracle Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Dev Shed ForumsDatabasesOracle Development

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
  #1  
Old December 6th, 2004, 05:46 PM
hudo hudo is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Sep 2003
Posts: 97 hudo User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 2 h 23 m 19 sec
Reputation Power: 6
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 ?

Reply With Quote
  #2  
Old December 10th, 2004, 04:52 PM
beunique beunique is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Nov 2004
Posts: 50 beunique User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 5
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.

Reply With Quote
  #3  
Old December 10th, 2004, 05:37 PM
hudo hudo is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Sep 2003
Posts: 97 hudo User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 2 h 23 m 19 sec
Reputation Power: 6
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).

Reply With Quote
  #4  
Old December 18th, 2004, 01:21 PM
beunique beunique is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Nov 2004
Posts: 50 beunique User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 5
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:
Execution Environment:
Windows command prompt, UNIX shell

Access Privileges:
Requires write privileges in the destination directory and read privileges in the source directory.

Instructions:
When copying the script be aware to remove line feeds in the list of parameters for the executables.
Please note that if you are FTPing this script from a Windows machine please do it in ASCII mode.

PROOFREAD THIS SCRIPT BEFORE USING IT! Due to differences in the way text
editors, e-mail packages, and operating systems handle text formatting (spaces,
tabs, and carriage returns), this script may not be in an executable state
when you first receive it. Check over the script to ensure that errors of
this type are corrected.





Quote:
For Windows

Forms/Reports 6i

REM WINDOWS COMPILE FORMS
::compile_forms.bat
cls
Echo compiling Forms....
for %%f IN (*.fmb) do ifcmp60 userid=scott/tiger@v817 module=%%f batch=yes
module_type=form compile_all=yes window_state=minimize
ECHO FINISHED COMPILING

REM WINDOWS COMPILE REPORT
::compile_report.bat
cls
Echo compiling Report .....
for %%f IN (*.rdf) do RWCON60 userid=scott/tiger@v817 batch=yes source=%%f
stype=rdffile DTYPE=REPFILE OVERWRITE=yes logfile=log.txt
ECHO FINISHED COMPILING
Forms/Reports 9.0.X

REM WINDOWS COMPILE FORMS
::compile_forms.bat
cls
Echo compiling Forms....
for %%f IN (*.fmb) do ifcmp90 userid=scott/tiger@v817 module=%%f batch=yes
module_type=form compile_all=yes window_state=minimize
ECHO FINISHED COMPILING

REM WINDOWS COMPILE REPORT
::compile_report.bat
cls
Echo compiling Report .....
for %%f IN (*.rdf) do rwconverter userid=scott/tiger@v817 batch=yes
source=%%f stype=rdffile DTYPE=REPFILE OVERWRITE=yes logfile=log.txt
ECHO FINISHED COMPILING
For UNIX

Forms/Reports 6i

#UNIX Forms Compile
#compile_forms.sh
for i in `ls *.fmb`
do
echo Compiling Form $i ....
f60genm userid=scott/tiger@bs817 batch=yes module=$i module_type=form
compile_all=yes window_state=minimize
done

#UNIX COMPILE REPORTS
#compile_rep.sh
for i in `ls *.rdf`
do
echo Compiling Report $i ...
rwcon60 userid=scott/tiger@bs817 batch=yes source=$i stype=rdffile
dtype=repfile overwrite=yes
done
Forms/Reports 9.0.X

#UNIX Forms Compile
#compile_forms.sh
for i in `ls *.fmb`
do
echo Compiling Form $i ....
f90genm userid=scott/tiger@bs817 batch=yes module=$i module_type=form
compile_all=yes window_state=minimize
done

( For 10g = forms 9.0.4.x, you can use f90gen also)

#UNIX COMPILE REPORTS
#compile_rep.sh
for i in `ls *.rdf`
do
echo Compiling Report $i ...
rwconverter.sh userid=scott/tiger@bs817 batch=yes source=$i
stype=rdffile dtype=repfile overwrite=yes
done


Reply With Quote
  #5  
Old December 18th, 2004, 02:02 PM
beunique beunique is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Nov 2004
Posts: 50 beunique User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 5
Also read this....

http://www.orafaq.com/msgboard/tools/messages/16397.htm

Reply With Quote
Reply

Viewing: Dev Shed ForumsDatabasesOracle Development > AS 10 and hierarchical tree


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump

 Free IT White Papers!
 
How to Present Effectively Online
This white paper offers practical and actionable advice on the key steps that any presenter should consider as they plan and execute a Webinar or online meeting.

 
Open Source Security Myths
Open Source Software (OSS) is computer software whose source code is available to the general public with relaxed or non-existent intellectual property restrictions (or arrangement such as the public domain), and is usually developed with the input of many contributors.

 
Power and Cooling Capacity Management for Data Centers
This paper describes the principles for achieving power and cooling capacity management.

 
Scalable, Fault-Tolerant NAS for Oracle - The Next Generation
For several years NAS has been evolving as a storage alternative for Oracle databases, and for good reason: NAS is quite often the simplest, most cost-effective storage approach for Oracle. Learn about the benefits that HP's approach to scalable NAS brings to Oracle environments in this comprehensive white paper.

 
Understanding Web Application Security Challenges
This white paper discusses many common threats and preventive measures for Web application security, and explains what you can do to help protect your organization.

 

Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 6 hosted by Hostway
Stay green...Green IT