Tarek Fathy

-------------------------------------------------- To Collapse tree nodes PROCEDURE collapse_tree IS vnode ftree.node; vhtree ITEM; vstate varchar2(30); BEGIN -- Search the tree identifiant -- vhtree := Find_Item('TREE_BLOCK.HTREE'); -- Search the root -- vnode := Ftree.Find_Tree_Node(vhtree, ''); -- Collapse all nodes -- WHILE NOT ftree.ID_NULL(vnode) LOOP vstate := Ftree.Get_Tree_Node_Property(vhtree, vnode, Ftree.NODE_STATE); IF vstate = Ftree.EXPANDED_NODE THEN Ftree.Set_Tree_Node_Property(vhtree, vnode, Ftree.NODE_STATE, Ftree.COLLAPSED_NODE); END IF; vnode := Ftree.Find_Tree_Node(vhtree, '', Ftree.FIND_NEXT,Ftree.NODE_LABEL, '', vnode); END LOOP; END; To Expand tree nodes : PROCEDURE explose_tree IS node ftree.node; htree ITEM; state varchar2(30); BEGIN -- Search the tree identifiant -- htree := Find_Item('BL_TREE.MENU'); -- Search the root --

-------------------------------------------------- 1- Open forms\server\ formsweb.cfg 2- Search for [JPI] section. This section exists by default. 3- You now will add three new parameters (jpi_download_page, jpi_classid, jpi_codebase) ------------------------------------------------- [jpi] baseHTMLJInitiator=basejpi.htm [MyApplication] baseHTMLJInitiator=basejpi.htm #archive=frmall.jar,frmall_jinit.jar,hst65.jar,icons.jar,frmwebutil.jar,jacob.jar archive=frmall.jar,frmall_jinit.jar,hst65.jar,icons.jar,frmwebutil.jar,jacob.jar jpi_download_page=http://java.sun.com/products/archive/j2se/1.4.2_09/index.html # or you may use application server URL #jpi_download_page= http://iai2.iai.org.kw:7778/forms/jinitiator/us/jinit_download.htm jpi_classid=clsid:8AD9C840-044E-11D1-B3E9-00805F499D93 jpi_codebase=http://java.sun.com/products/plugin/autodl/jinstall-1_4-windows-i586.cab#Version=1,4,0,0 ----------------------------------------- now copy this file " jre.exe " to the f

-------------------------------------------------- create Journalling tables: 1. go to http://iai2.iai.org.kw:7778/forms/frmservlet?config=hsd65_utilities 2. Productivity Boosters --> Data Layer --> Logical Database Design (DB.010) 3. click on Maintain journal tables 4. select the names of Tables to be journaled, then click on run 5. generate th journal tables from DB Admin and grant roles to ADMIN and APPROVE 6. you don't need to generate CAPI for the journal table from the utilities, just generate the table from DB admin and then generate Table API from the Server model. 7. in the properites of the table to be journalled , put Journal in the notes filed create journalling triggers: 1.go to http://iai2.iai.org.kw:7778/forms/frmservlet?config=hsd65_utilities 2. Productivity Boosters --> Business Logic Layer --> Rule Layer - CDM RuleFrame --> Standar rule patterns 3. click on Maintain Journalling Business Rules 4. Select the tables to be journaled, then click on run

-------------------------------------------------- This artical is Quoted from http://thinkoracle.blogspot.com/2005/10/rownum-and-rowid.html ROWNUM and ROWID Questions: How do I limit the number of rows returned by a query? How do I write a query to get the Top-N salaries from the employee table? How can I add unique, sequential numbers to an existing table? How can I differentiate between two completely identical rows? How can I find a faster way to retrieve a queried row? How can I find the last row processed in a big batch? There is one thing all these questions have in common: the answer involves either ROWNUM or ROWID. So what is ROWNUM and ROWID? First of all, both are covered in the SQL Reference, Basic Elements of Oracle SQL, Chapter 2: http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540.pdf They are also both referred to as pseudo-columns. That is, they are not "real" columns that will show up when you DESC a table. They don't actually exist anywh