From: none@none.com   
      
   Hi. I'm implementing a web deployment using 9i. I have a table for STOCK,   
   which has one or more PURCHASES, which have one or more PURCHASE_ITEMS.   
      
   When a purchase item is INSERTED, I'd like the web module component to   
   update the relevant grandparent record of STOCK, and when UPDATED, to   
   remember the previous level and adjust accordingly.   
      
   I'm sure that this can probably be done in PL/SQL, but don't have a clue   
   how - all books and tutorials I have found take a 'PHP-style' approach or   
   use servlets and don't seem to use web modules.   
      
   I am mostly familiar with Design Editor. Can anyone help? Thanks.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)