


                             5

 
         뢠  ᭮  ⨯  ⮢  䥩
   SQL*Forms(Design).    ⭮,  ᬠਢ ᫥騥 :
   - ।०
   - ४⥫
   - ஫쭮 
   -  
   - 
   - ଠ
   - ᯨ᮪ 祭
   - 
   - ப ᮮ饭
   -  ஫஢
   - ⠡ ࠬ஢ ( spread table )
   - ப ﭨ

    ⢠  ⤥묨  ⠬  䥩  (  ⨯   Field
      Edit Object ) 頩  ࠪ⨢ help-⥬
   SQL*Forms(Design).   祭 ଠ樨      ⢨
   㭪樮  襩   ⠬  䥩  ᬮ    7,
   "㭪樮 ".

   砭:
     뢠  䥩 ⠪,    㭪樮  
   ।  ᨬ쭮  ०.   㣨 ।     ᥡ
   -㣮.  ,   ⢨  ⨬ ⠬  
   ࠧ.  ᫨    ᯮ  SQL*Forms(Design)    ।  ⮢
   ⮡ࠦ, ⠩ ᥪ "। ⮢ ⮡ࠦ".

   ⢥ ⥬:   । ⮢ ⮡ࠦ
                       㭪樮 

।०

   ।० -  ,  ஥   । ࠭, ४-
   뢠    ⥪饣  뢮     ࠭.   ।० ᮮ
     ᫮, ஥  - 襣 ᫥ ⢨. 
   ⠢  ॠ஢   ᫮.

   ।०  ᮤন  ,  ⥪⮢  ᮮ饭    
   ⨯  ⢨.   ⪠   砥   ஢   쥧 ।०
        ᫥:

   CAUTION   뢠,  ।० ᮤন ।-
             饥   .

   NOTE      뢠,  ।० ᮤন ଠ樮
             ᮮ饭.
   STOP      뢠,  ।० 㪠뢠  쥧  ஡.

   ⮢  ᮮ饭  ⥪ ,   뢠
   ।०.  ⢨   롮 - ।,   ⢨
     믮  SQL*Forms,    ⢥न ਭ⨥ ᮮ饭.  
    롥 㦭 ⢨ ( १ [Select]  ), ।०  祧
     SQL*Forms  믮 ᮮ⢥饥 ⢨.


                                    -- 65 --



   㭮 5-1 뢠 ।०, ஥ ,   
   롨ࠥ  Quit   Action.

 5-1ਬ ।०
        Ŀ
          Action  foRm  Block  Trigger  Procedure  Image  Help  Options 
          SQL*Forms  
                                                                        
                 Ŀ              
                  STOP                                                
                                                                      
                  Modified form will be lost! Continue?               
                                                                      
।⥳                                                              
pĳ>  ( Yes )   ( No )                                    
                                                                      
                               
                                                                        
          
         Frm:  ORDER_ENTR   Blk:  ORDERS   Fld:       Frg:       <Rep>  
                                                                        
        

४⥫

 ४⥫     ⥪⮢ ⪨  ᪮.   
 롨ࠥ ४⥫ ( १ [Select]  ),  SQL*Forms  뤠 ᯨ᮪
 㯭 権   .

 -  ᫨    ᯨ᮪,       롨,      ⨢묨,
    㭪⮢ ⮣ ᯨ᪠.    [Accept],   SQL*Forms
 ६  ࠭    롮   㭪⮢ ᯨ᪠  ᯨ᮪ 祧.

 -  ᫨      ,      
 ஫ .    [Accept],  SQL*Forms ६ ࠭
    ࠭   ࠪ⨪       祧.

 㭮 5-2 뢠 ४⥫  Select  Attributes    ଥ Field
 Definition  易   ᯨ᮪ ਡ⮢.

 5-2
         Ŀ
ਬ     Action  foRm  Block  Trigger  Procedure  Image  Help  Options 
४-   Field Definition  
⥫                                                                     
                                                                         
            Ŀ   
             Field Name:        ORDID                                  
             Sequence Number:  1             ( Select Attributes )     
             Field Number:     6             ^ Display Length:  6      
४-     Screen Position:  X: 28                                  
⥫                          
             Default Value:  Ŀ              
             Hint: Enter val  [ x ] Base Table         |              
             Format mask:     [   ] Primary Key                      
             Valid Range: Lo  [ x ] Displayed                        
             Enforce Key Fro  [ x ] Required                         
             List of Values:  [ x ] Input Allowed         X:   Y:    

                                    -- 66 --



               [   ] Update Allowed        ĳ 
                  [   ] Update if Null           
                              [ x ] Query Allowed                    
                              [   ] Uppercase                        
                              [ x ] Echo Input                       
                              [   ] Fixed Length                     
               [   ] Automatic Skip        ĳ 
                  [   ] Automatic Hint           
                                           
                                                                       
            -- 
                                                                         
          is the field based on part of the base table?                  
          Frm: ORDER_ENTR  Blk: ORDERS    Fld:       Trg:          <Rep> 
                                                                         
         

 ஫쭮 

 ஫쭮  -  ᯨ᮪   ୠ⨢,   ண  롨ࠥ
 : "on"  "off".

 -    ஫쭮    ᮤন   ஡,   ࠪ⨪, 易
     ⨬ , ⪫祭 ( turned off ).
 -   ஫쭮  ᮤন "x", ࠪ⨪, 易  ⨬
    , 祭 ( turned on ).

   [Select],  ⮡   ⪫ ࠪ⨪, 易
  ⨬ .    㣮  ᯮᮡ  -     ஫쭮   
    ᨬ     祭  ⭮ ࠪ⨪  ஡ -
   ⪫祭.

 㭮 5-3 뢠,   ஫ .

 5-3 ਬ ஫宪
           Ŀ
             Action  foRm  Block  Trigger  Procedure  Image  Help  Options 
             Option Selection 
                                                                           
            Ŀ 
               Run Form Options    Design Options   
            ĳĳ 
             [   ] Buffer Record in File  [   ] Disable Compillation    
             [   ] Debug Mode             [ x ] Generate Form           
஫륳  [   ] Disable Processing     [   ] Limit Undo Buffer       
 > [ x ] Display Block Menu     [   ] Show List of Values     
                 [   ] Quiet Mode        [   ] Supress Hints           
     > [   ] Set Block Validation    [ x ] Use Forms as Default    
             [   ] Share Cursors for SQL                                
             [   ] Cursors for Trigger                                  
             [   ] Statistics                                           
             
                                                                           
                ffers rows in a file?                                      
            Frm: ORDER_ENTR  Blk: ORDERS    Fld:       Trg:          <Rep> 
                                                                           
           


                                    -- 67 --



 

             -      ଠ,      
          ।  ࠭,  ४뢠  ⥪饣 뢮.   ᮤন
                ,               
          ४஢.  ଠ,      ,
           ।,  ꥪ SQL*Forms 㤥 ࠡ (ਬ,
               Open Form).

             [Accept],    祧  SQL*Forms
          믮 ᮮ⢥饥 ⢨.

          㭮 5-4 뢠   View Page.

 5-4
          Ŀ
ਬ      Action  foRm  Block  Trigger  Procedure  Image  Help  Options 
   SQL*Forms  
                                                                      
                                                                          
              Ŀ                           
                     View Page                                          
                                                              
 >                                                           
                    Page:                                          
                                                                        
                                         
                                                                          
            
           Frm: ORDER_ENTR  Blk: ORDERS    Fld: ORDID  Trg:         <Rep> 
          


     䥩 ࠧࠡ⪨  ,    , ।-
   㤠 .    । ꥪ (ਬ,   
 Field  Name    Field  Definition),    ॠ 롮 ⨯ ࠡ⪨
 (ਬ,    Page   View Page).

    ଠ,  ⠡ ࠬ஢   .  㭪
 5-5  5-6 뢠  Field Name,    룫廊  ଥ Field
 Definition   ⠡ ࠬ஢ Field Definition.


 5-5
          Ŀ
       Action  foRm  Block  Trigger  Procedure  Image  Help  Options 
ଥ       Field Definition  
           Ŀ 
            Field Name:    ORDID                                        
            Sequence Number: 1  ^ Data Type:    NUMBER                  
            Field Length:    6       Query Length: 6                   
                                      
            Screen Position:    X: 28    Y:  4    Page:  1              
            Format Mask:                                                
            Default Value:                                              
            Hint:            Enter Value for: ORDID                     
            Valid Range:     Low:            High:                      
            Enforce Key From:                                           

                                    -- 68 --



            List of Values:  Title:                                     
           ĳ 
             List of Values SQL Text   
                                                                        
           ĳ 
             Comment   
            This field records a unique order identification number.    
                                                                        
            
             Enter the field name.                                        
           Frm: ORDER_ENTR  Blk: ORDERS    Fld: ORDID   Trg:        <Rep> 
          


 5-6
          Ŀ
       Action  foRm  Block  Trigger  Procedure  Image  Help  Options 
⠡     Field Definition  
ࠬ஢Ŀ
              Field    Seq   Data   Select  Fld  Qry  Dis      
          ĳ   Name     Num   Type   Attrib  Lim  Len  Len  X  ĳ
           ĳ
 > ORDID   1    NUMBER   ( * )  6    6    6    20  
            ORDERDATE  2    DATE     ( * )  9    9    9    60  
            COMMPLAN   3    CHAR     ( * )  1    1    1    20  
            CUSTID     4    NUMBER   ( * )  8    8    8    60  
            SHIPDATE   5    DATE     ( * )  9    9    9    20  
            TOTAL      6    NUMBER   ( * )  10   10   10   60  
                                                               
          ĳĳ
                                                            >
          ٳ
              Enter the field name.                                       
           Frm: ORDER_ENTR  Blk: ORDERS    Fld: ORDID   Trg:        <Rep> 
          

஢ 
          SQL*Forms ஢ ࠢ쭮  ,  ᭮뢠 
          ⮩   ଠ樨,   ன     ।  ᮡ  
          ਫ.  ᫨ ஢  蠥  ᯥ譮,  SQL*Forms
          ᪠뢠  ४ .

ଠ
          ମ   䥩 ࠧࠡ⪨ 뢠  ࠧ஬  
          ࠭,   ᮤঠ ४⥫, ஫ ,
              ஫஢.    ।    ⠬
          ,   ᯮ  ࠧ  㭪樮  .    
           [Accept],  SQL*Forms ६ ࠭    ࠭
          ਠ  ଠ 祧  ࠭.

          㭮 5-7 뢠  Trigger Definition.

 5-7
          Ŀ
ਬ      Action  foRm  Block  Trigger  Procedure  Image  Help  Options 
       Trigger Definition  
            Ŀ  
              Trigger: KEY-CLRBLK           For Key Triggers Only ĳ  

                                    -- 69 --



              Block:   ORDERS               [ X ] Show Keys           
              Field:                        Descrip:                  
              Trigger Style:    V3                                    
             -ĳ  
               Trigger Text    
              EXECUTE TRIGGER<'CLEAR_DETAILS'>;                        
ଠ ĳ   CLEAR_BLOCK;                                             
                                                                       
                                                                       
             ĳ  
               Comment    
              This trigger clears both the master and detail blocks.   
                                                                       
              
                Enter the name of the trigger.                            
           Frm:ORDER_ENTR  Blk:ORDERS  Fld:ORDID  Trg:KEY-CLRBLK    <Rep> 
          

          設⢮    易    ⠡栬  ࠬ஢   䥩
          ࠧࠡ⪨ ਫ.    ࠡ      ᯮ  [Change
          Display  Type]    ४祭     ⠡ ࠬ஢ 
          .

᮪ 祭
          ᮪  祭  -    ,   ஥      ࠭,
          ४뢠      ⥪饣   뢮.     ᯨ᮪  祭
          ᮮ⢥   ⮫쪮    䥩 ࠧࠡ⪨.
          ᮪ 祭    ,  ᯨ᪠  
          ᪠. (   ᯨ᪨ ᮤঠ  ᪠. )

          㭮 5-8 뢠 ᯨ᮪ 祭 Table Name.
          Ŀ
            Action  foRm  Block  Trigger  Procedure  Image  Help  Options 
            Default Block  
            Ŀ  
             Block Name: Ŀ               
             Base Table:       Table Name                             
 Ŀ                             
᪠                                     ĳ  
             Sequence Number     V                          traints   
             Records Display  Find:   ine: 17   
             ĳ ĳ  
             Master Block:       CUSTOMER    tails     
             ĳ DEPT                       ĳ  
                 EMP                           
                                ITEM                                 
᮪ >   ORD                                  
祭                                    ^                        
                                                                    
                      ĳ                                     
ᯨ᪠                         
                                                                     
                                        
              
                                                                          
            
           Frm: ORDER_ENTR  Blk:           Fld:         Trg:        <Rep> 
          

                                    -- 70 --



  ᯮ짮 ᯨ᮪ 祭  ᬮ     
   祭       㦭    ,   ஥ ᮮ⢥ ⮬
ᯨ.    祭   ६   祭,  ஥ 
㦭,   ᯨ᪠ 祭   [Select].

⨬,    易⥫쭮 ᯮ짮 ᯨ᮪  祭  
 祭  , ஥   ᯨ᮪ 祭.

᮪ 祭        ᯨ᪠

   ᯨ᪠  -  塞  ஫஢,    ᮤন
     祭.            祭 ᯨ᪠ 
, ஬  ᯨ᮪ ᮮ⢥.

  ⠪  ᯮ짮 㭪樮    ६饭  
  祭  ᯨ᪠.  㭮 5-8 뢠  ᯨ᪠ 
ᯨ᪠ 祭 Table Name.

 ⢥ ⥬:      ஫஢

᮪ 祭        ᪠

  ᪠,      Find,      ᪠ 祭  
ᯨ᪠ 祭.  㭮 5-8 뢠   ᪠   ᯨ᪠ 祭
Table Name.

᮪ 祭       㭪 ᪠

㭪  ᪠  ᯨ᪠ 祭   ᪠ । 祭 
 ᯨ᪠ 祭.  ⮡  믮,   㦭  祭  
 ᪠ ᯨ᪠ 祭   [List].  SQL*Forms ୮ 뢥 
࠭ ᯨ᮪, 뢠騩 ⮫쪮  祭,  ᮢ  蠡
襣 祭,    ᪠.

ਬ,  ।,     ࠭ ᫮ 祭  ᯨ᪥
Table Name ⮫쪮 ⥬  ⠡,  稢   "EMP".
 %emp   ᪠   [List].      
"㧨" ᯨ᮪,  ਢ  楤    祭 ᪠.

㭪  ᪠ ᯨ᪠ 祭 ࠧ筠  ⮬,  ய  
 ᨬ.   ਭ ⠭ ᨬ "饭" SQL:
%                        ।⠢  ᫮ ᨬ.
_( ન )       ।⠢   ᨬ.

SQL*Forms       %         祭 
 ᪠.


              ᯨ᪮    롨ࠥ  㭪⮢,   
            ।,    ⢨  믮    
             ᫥騬.

               SQL*Forms(Design),       㭪  5-9,
          뢮  ࠭,   ப 롨ࠥ ⢨  ᠬ  
          ࠭,   ⮫쪮 ॣ  SQL*Forms.




                                    -- 71 --



 5-9
          Ŀ
     Action  foRm  Block  Trigger  Procedure  Image  Help  Options 
     ^  SQL*Forms  
SQL*Forms                                                                
(Design)                                                                 
                                                                         
                                                                         
                                                                  
                                                            
                                                                          
                                                                          
                                                                          
                                                                          
             Perform global operations on Forms.                          
           Frm:             Blk:           Fld:         Trg:        <Rep> 
          

           㣨         
          ⨪  ᯨ᪮  롨ࠥ  㭪⮢,     Action,
            㭪 5-10.

 5-10
        Ŀ
ਬ    Action  foRm  Block  Trigger  Procedure  Image  Help  Options 
   SQL*Forms  
         Ŀ                                            
          New                                                         
           Open                                                       
         ĳ                                            
           Copy                                                       
           Rename                                                     
>  Delete                                                     
           Load                                                       
           Print doc   >                                              
         ĳ                                            
           Generate                                                   
           Execute                                                    
         ĳ                                            
           Save                                                       
           Form security                                              
           Quit                                                       
                                                     
         Create a new form.                                             
         Frm:             Blk:           Fld:         Trg:        <Rep> 
        

   㭪   ⠭묨 ﬨ:
     -  樮஢    㭪   [Select].
  
     -   㪢 (  ᨬ )  㭪.  ᪫祭 ⮣
       ⮤   Form   SQL*Forms.  롮 ⮩
       樨  r (  R ).

      ⮫쪮  ᢥ祭  㭪  .  SQL*Forms
ᢥ稢 ⮫쪮  樨,    ⥪饬 ⥪.



                                    -- 72 --



砭:  롮  権      ࢮ  㪢    ࠡ⠥  ନ
            筮 ०.

ப ᮮ饭

 ப ᮮ饭,    㭪 5-11,    ।᫥
ப  ࠭ SQL*Forms(Design).  뤠 ।० 
ࠧ ᮮ饭.

 5-11
          Ŀ
ப      Action  foRm  Block  Trigger  Procedure  Image  Help  Options 
ᮮ饭   SQL*Forms  
SQL*Forms                                                                 
(Design)                                                                  
                                                                          
                                                                          
                                                                          
                                                                          
                                                                          
                                                                          
                                                                          
ப                                                                    
ᮮ饭> Perform global operations on Forms.                           
           Frm:             Blk:           Fld:         Trg:        <Rep> 
          

 ஫஢

            ஫஢  -    ,      
          । ⨪쭮  ଠ樨.  㭮  5-12  뢠
           Trigger Definition,   ᮤন  ஫஢
          Trigger Text   ஫஢ Comment.


 5-12
          Ŀ
ਬ     Action  foRm  Block  Trigger  Procedure  Image  Help  Options 
⥩    Trigger Definition  
஫-      Ŀ 
஢        Trigger: KEY-CLRBLK       For Key Triggers Only   
               Block:   ORDERS          [ X ] Show Keys                
               Field:   ORDID           Descrip:                       
               Trigger Style:    V3                                    
              ĳ 
               - Trigger Text   
             EXECUTE_TRIGGER('CLEAR_DETAILS');                        
              CLEAR_BLOCK;                                             
                
 ĳ     
஫-       
஢        
           ĳ 
             Comment   
             This trigger clears both the master and detail blocks.   
       ĳ                                                            
                                                                       
             

                                    -- 73 --



           Enter the trigger block.                                       
           Frm:ORDER_ENTR  Blk:ORDERS  Fld:ORDID  Trg:KEY-CLRBLK    <Rep> 
          

            ஫஢,        ,      ,
          ।஢  㤠 .

              ६      ஫஢,   ᯮ
          㭪樮 ,  祭 㭪 ।஢.  
            [Search],  뢠 㭪 ᪠ 
          ஫஢.

 ஫஢
㭪 ᪠

㭪 ᪠   ஫஢      ᪠ ।
祭   ஫஢.   ⮣  [Search], ⮡  맢
  Search Criteria.   ⮬  । ᫥騥 ਨ
᪠:
- ᪮ ப ⥪;
-  ப ⥪   ᪮;
- ࠢ ᪠/ (।  )  ⥪饩 樨 ;
- 㦭       ᪮ 蠡  ப
  .

㭪 ᪠ ࠧ筠  ⮬, ய    ᨬ.

 ࠬ஢

  ࠬ஢  -    ࠭   ⠡,       墠뢠
  ࠭   ⨪,    ਧ⠫.   ⮨ 
᫥ ⮢:
- ४⥫, ஫   ;
- ⨪쭠  ஫஢;
- ਧ⠫쭠  ஫஢.

,   , ஫ , ४⥫   ᯮ
  浪   ⠡ ࠬ஢.      
⨪  ⮫    .  ଠ    ⠪  ⠡,
⭮   ꥪ, 室   ப.   ਧ⠫쭠
ப  ⠡ ࠬ஢, 室 १  ⮫, 뢠 .

  ६頥    ⠬  ⠡  ࠬ஢,   ᯮ ࠧ
㭪樮 .        [Accept], SQL*Forms  ६
࠭    ࠭ 祭  ⠡ ࠬ஢ 祧.

㭮 5-13 뢠  ⠡ ࠬ஢ Block Definition.

            5 13
          Ŀ
ਬ      Action  foRm  Block  Trigger  Procedure  Image  Help  Options 
⠡     Block Definition  
ࠬ஢  Ŀ 
                 Block    Base   Seq  Record  Record  Record  A 
             ĳ  Name     Table  Num   Disp    Buff   Lines  ĳ 
               ĳ   
                ORDERS   ORD      1      1                      
                ITEMS    ITEM     2      4               1      

                                    -- 74 --



                CUSTOMS  CUSTOM   3      1                      
                                                         
ࠬĳ                                                       
p                                                             
                                                                
             ĳ 
                                                                  > 
             
           Enter the name of the block.                                   
           Frm: ORDER_ENTR  Blk: ORDERS    Fld:         Trg:        <Rep> 
          

⥪ ⠡ ࠬ஢

  ࠬ஢ ᥣ  뤠    ࠭    ,    ⭮
 ⥪ ⥪饣 ꥪ.

 -  ࠬ஢, 易  ,  뢮  ,  ⭮騥
    ⥪饩 ଥ.

 -  ࠬ஢,  易   ﬨ,  뢮    ,
   ⭮騥  ⥪饬 .

 -  ࠬ஢,  易  ਣࠬ,  뢮  ,  
⭮  ꥪ ⥪饣  ⥪,  ।    ப  ﭨ.
᪫祭   ⮣ ࠢ  砩,    뢠 ⠡
ࠬ஢   樨  Trigger    .

  ⠡ ࠬ஢   易     ମ    䥩 ࠧࠡ⪨.
 ᯮ [Change Display Type]  ४祭    ⠡ ࠬ஢ 
   .

          ⢥ ⥬:   ⥪  ,   
                              ⥪  ਣ஢

஫஢ ⠡ ࠬ஢

  ࠬ஢  ஫஢ ( ६  ࠭ )
ਧ⠫쭮  ⨪쭮.

ਧ⠫쭮 ஫஢

ਧ⠫쭠    ஫஢  室    ࠭ ⠡
ࠬ஢.  (. 㭮 5-13.)   ஫஢ ᯮ ५
  ᬮ  ⠡  ࠬ஢,  ᫨   ⠡  ࠬ஢  
⥫  - ""  "᫥" 뢥 ࠭. ᫨  ࠭
頥 ⮫쪮  ⠡ ࠬ஢,   ஫஢  ⠪
ᯮ  ,  뢠 "",   ⭮⥫-
 ਧ⠫쭮  樨  ⥪饣 뢮   ࠭  ⠡ ࠬ஢.

᫨ ⠡ ࠬ஢    ࠭,  ஫
ਧ⠫쭮   ࠭      ᤢ.  ( । ⮢
⮡ࠦ ஫஢ 믮 뢭,   ࠭.) 
ࠬ஢   ।  ᤢ  ᥣ 믮  室   ᫥
⮫  ⠡  ࠬ஢     ࢮ ⮫  ᫥.

⨪쭮 ஫஢


                                    -- 75 --



⨪쭠    ஫஢  室      ஭ ⠡
ࠬ஢. (. 㭮 5-13.)  ᯮ ५  ⮡ࠦ ⠡
ࠬ஢,  ᫨       뢥  ଠ樨 "" 
"" ⥪饣 ࠭.  ᫨  ࠭ - ⮫쪮  ᥩ  ⠡
ࠬ஢,   ஫஢ ᯮ ⠪  ,   ..
"",   ⭮⥫쭮 ⨪쭮 樨 ⥪饣 뢮 
࠭  ⠡ ࠬ஢.

᫨ ⠡ ࠬ஢ ᮤন   ࠭ ᥩ,   ஫-
 ⨪쭮     ᤢ.


ப ﭨ

 ப ﭨ -  ᫥ ப   ࠭  SQL*Forms
 (Design).

 砭:    ᥪ   ப ﭨ ⠪,   
 ப   ࠭ ࠧࠡ⪨.   祭 ⫨砥  
 ப ﭨ ࠭ ।.

   ப  ﭨ      ࠭ ࠧࠡ⪨,  ,
 ਬ,  㭪 5-14,  뢮 ᫥ ଠ:
 Frm:        뢠 ।塞 .
 Blk:        뢠 ।塞 .
 Fld:         뢠 ।塞 .
 Trg:  ਣ   뢠 ।塞 ਣ.

 <List>              ,   ᯨ᮪ 祭  ⥪饣  .
                     ᫨ ⠪  ᯨ᪠ ,   ப   ﭨ 

 <Ins>  <Rep>   <Ins>,  ⠢, ,    SQL*Forms 室 
                   ० ⠢      㤥      
                   ᨬ  ᫥    樨 .    <Rep>,  
                   ,  砥,     SQL*Forms  室  ०
                        㤥 ४뢠  騥   ᨬ
                   묨, 稭  ⥪饩   樨 .

 5-14
          Ŀ
ப      Action  foRm  Block  Trigger  Procedure  Image  Help  Options 
ﭨ   Trigger Definition  
 ࠭   Ŀ  
ࠧࠡ⪨    Trigger: KEY-CLRBLK           For Key Triggers Only ĳ  
              Block:   ORDERS               [ X ] Show Keys           
              Field:                        Descrip:                  
              Trigger Style:    V3                                    
             -ĳ  
               Trigger Text    
              EXECUTE TRIGGER<'CLEAR_DETAILS'>;                        
              CLEAR_BLOCK;                                             
                                                                       
                                                                       
             ĳ  
               Comment    
              This trigger clears both the master and detail blocks.   
                                                                       
              

                                    -- 76 --



ப     Enter the name of the trigger.                                 
ﭨ> Frm:ORDER_ENTR  Blk:ORDERS  Fld:ORDID  Trg:KEY-CLRBLK    <Rep> 
          

                                      6
     

    SQL*Forms  ⥪⮬  楯,    ᯮ,
  ࠡ⠥  䥩 SQL*Forms(Design).  ⥪ -   ᯮᮡ
 㧭,    ।      ⥪騩  .
 㣨  ᫮, ⥪ ⢥砥    ᫥騥  :

 1.  "᫨           אַ ᥩ,   ꥪ
     SQL*Forms  ᬮ ஢?"

 2.  "᫨   [Zoom In]   [Zoom  Out]  אַ  ᥩ,  뢥
      ଠ  ࠭?"

 SQL*Forms  ᯥ稢    ⮩ ଠ樨   १  ப
 ﭨ.    ⭮,   ப  ﭨ 뢠  ꥪ  ⥪饣
 ⥪.       ⥪  ,   .

   ᬠਢ 楯 ⥪    ,     
  䥩ᮬ SQL*Forms(Design).  ⭮,  砥  ᥡ ᫥騥
 ⥬:
 - ⥪  樨  ;
 - ⥪  裡  ⠡஢;
 - ⥪  ,   ;
 - ⥪  ਣ஢;
 - ⥪  ࠭ ।;
 -  ⥪ 㭪樮묨 蠬.

⥪  樨  

            ⥪  ᥣ ,  ଠ  ꥪ
           㯭    ⥪騩    १    .  ਬ,
          ।,  ப ﭨ  ,   㭪 6-1.

 6-1  ଠ ⥪   ப   ﭨ
          Ŀ
            Action  foRm  Block  Trigger  Procedure  Image  Help  Options 
            SQL*Forms  
                                                                          
                                                                          
                                                                          
                                                                          
                                                                          
                                                                          
                                                                          
ப            Perform global operations on Forms.                     
ﭨ > Frm: ORDER_ENTR  Blk: ITEMS     Fld: PRODID  Trg:       <Rep> 
          

 ப ﭨ  㭪 6-1  ,   ଠ,  
  ⥪饣 ⥪. ⮬, ᫨         롥
   Field,   ⥬  Modify,  SQL*Forms 뢥  ࠭ ଠ (
   )  ᥬ    ITEMS  ⥪饩  㤥 , 
 易   PRODID.  筮, ᫨       롥-

                                    -- 77 --



   Block,  ⥬  Modify,  SQL*Forms 뤠 ଠ  ᥬ
    ORDER_ENTRY   ⥪饩  㤥 ,   易 
  ITEMS.

⥪  裡  ⠡஢

 ⥪   裡  ⠡஢  ⪨. .., 
 ଠ  ⠡ ࠬ஢ 뢮  ࠭,  ଠ ⥪  
 ப  ﭨ   ,   ଠ  ꥪ 㤥 뢥
 SQL*Forms  ⨨ [Zoom In]   [Zoom Out].

 ਬ, ।,   ࠭ 룫廊 ⠪,    㭪
 6-2.

 6-2  ⥪  裡  ⠡஢
 Ŀ
   Action  foRm  Block  Trigger  Procedure  Image  Help  Options 
   Block Definition  
  Ŀ
   Block: ITEMS             Records   Array Size:        
   Table: ITEM             Displayed: 4   [   ] Prim Key     
   Sequence Number: 2      Buffered:      [ X ] In Menu      
  ĳ 
   Description: ITEMS                                          
  ĳ 
    Default Where/Order By   
   ORDER BY ITEMID                                             
                                                               
  ĳ 
    Comment   
   This block records the items that are associated with one   
   user.                                                       
                                                               
   
   Enter the name of the block.                                  
  Frm: ORDER_ENTR  Blk: ITEMS     Fld: PRODID  Trg:        <Rep> 
 

 ப  ﭨ  뢠,    ⥪  ,  
 .  ᫨   [Zoom In]  ⥪饣 ࠭, SQL*Forms 뢮 -
   Field Definition    ᮧ  , 易   PRODID  ⥪饣
 ⥪  .  ᫨       [Zoom  Out]   ⥪饣 ࠭,
 SQL*Forms 뢮  Form Definition  뤠 ଠ  ⥪饩
 .

 ⢥ ⥬:   [Zoom In]
                     [Zoom Out]

⥪  ,   

 SQL*Forms ⠭ ⥪  娨 ꥪ⮢ ᢥ .   
 SQL*Forms     ⥪    ।  ⥬,   ⠭
 ⥪ ,     ⥪  । ⠭ ⥪
 .





                                    -- 78 --



  ᫨    ⥪ ,  SQL*Forms 㤠  ᢥ     樨
Field    .    砥,           ४஢
  室    ஢    १  Zoom   (⠡஢)  
 ,    ⠭ ⥪ .  筮 ⮬,    -
 室  ࠭ ।  ।⥫쭮 ⠭ ⥪ .

  ⨬,    ⥪⮬  ᥣ  ଠ,      뫨
 ᮧ.

⥪  㬮砭    

 ᫨  ⥪ ,   ⥪ ,    롨ࠥ
  Field    (  ⥬   Modify), SQL*Forms ६頥
   ࢮ  "field"  । ⥪饣 .   ⢨
  㬮砭  ⠭  , 易      ⮩ ,   
 ⥪饣 ⥪,    ࠦ  ப  ﭨ.  筮,  ᫨
   ⥪ ,   ⥪ ,    롥 
 Block      (    ⥬   Modify ), SQL*Forms ६
   ࢮ  "block"  । ⥪饩 .

ﭭ ⥪    

    ⥪ ,  SQL*Forms   ,   ᫥
 ⥪    ⮣  - ⥪  .   ᨬ
  ⮣,    ⥪ , SQL*Forms       
 ন  ⥪  ,    ⠭ ࢮ   ।
   ⥪騩 ⥪ .  筮,     ⥪
 ,  SQL*Forms   ᫥ ⥪   .

প    ᮮ⢥騬 ⥪

 SQL*Forms(Design)  ᫥  ᮮ⢥騩  冷  ᥩ,  
 ᮧ      ।  ꥪ⮢   ⠡  ࠬ஢.
  ஢   ࠡ SQL*Forms,   ४
  ᮧ , 易    ﬨ.   ⭮,  ᫨ 
  ᫥⥫        ᮧ   
 ,  SQL*Forms 頥   ᮮ⢥          ࠢ
 (..  ᫥⥫)      ᯨ᪥ ᥩ,   ⠥
 ६    .  SQL*Forms ࠭    ४-
  ,   , (  ࠭ 뢮, ᫨   室
    ⥪饩  )  ন ⥪騩 ⥪.


⥪  ਣ஢

  롨ࠥ  Trigger    (  ), SQL*Forms
뢮  ࠭  Trigger Definition  ⠡ ࠬ஢   묨
  ਣ஢  ⥪饬 । .  ⨬,    뢮
ᥣ  ,  ᬮ   ⥪騥  ⥪   .   ६
⮩ 樨 SQL*Forms ন ⥪,     ⮣, 
ࠫ  Trigger,   ᫨       .    ०
ࠡ ,  ..  筮  㦭   ଠ  ᥬ
ਣࠬ   ⥫쭮        , 
묨   ⮣ ࠡ⠫.

    뤠  ࠭ ଠ   ਣ஢  ଥ,   
  ⥪騩 ⥪,  । ᮮ⢥饥   ଥ,
 ᯮ 㭪樨 ⠡஢ [Zoom In]  [Zoom Out]   ⭮

                                    -- 79 --



   ଥ  ।   ਣ.    砥 SQL*Forms
 ⥪騩 ⥪     ᮮ⢥⢨  ꥪ, 
    ਣ஬,       ࠡ⠥.

ਬ,  ᫨    ।      ਣ,   ᮥ
  PRODID, SQL*Forms  ᫥騥 :

- ⥪⮬  ⠭ ,  ஬ ਣ ᮥ (..PRODID)
- ⥪⮬  ⠭ ,      PRODID (..ITEMS).


। ਣ  ⥪

   SQL*Forms         ।  ਣ    ⥪.
ਬ, ।,  訬 ⥪騬 ⥪⮬  ଠ ORDER_ENTRY
  ORDERS.    ⠡  ࠬ஢  Trigger Definition  ᮤন
 ଠ  ਣࠬ  ORDERS.    ⠢   
 ⠡ ࠬ஢  ।  ਣ,   㤥 ᮥ
   PRODID     ITEMS.      ᭮  ୥    (
 믮 㭪 ZOOM  ⥪饣 ࠭  ),  SQL*Forms  "६"
  㤠,    ᫥ .   ⭮,    㤥
⥯ 뢠  ࠭ ⮫쪮 ⮣,     뢮 ଠ樨
 ᥬ ਣࠬ  ਣࠬ,  ᮥ   PRODID. ⬥⨬, 
    ⥪騩 ⥪.


⥪  ࠭ ।

    ࠡ⠥    ࠭  ।,   ப   ﭨ 뢠
 ⥪   .    ⥪ ,  ३  
㣮 .  ⨬,    ⥪   ࠧ  ⥪騩
⥪  .        ⥪  (  ⠭  ),
믮   ᫥ ⢨:

- ⠢   饥    [Define Field].
- ᮧ    [Define Field].
- 㤠 ⥪騩 ⥪   [Cut].


室        ⥪ .   ࠭  ࠭
।    ⥪   .

 ⥪ 㭪樮묨 蠬

 ⮣,  ⮡ ꥪ  뫮  ஢    । ,
  ꥪ    襣 ⥪饣 ⥪.  ⮬ 
室    ⥬,    㭪樮 
SQL*Forms(Design)     ⥪.

[Cut]         ᫨  㤠 ⥪饥  ⥪,   ⥬ ᠬ
              ஢ ⥪ .

[Define Field]
               ᫨   [Define Field]  -  饣 ,
              SQL*Forms ⠭ ,  ஥  ।,  
              ⢥    ⥪饣 ⥪.



                                    -- 80 --



               ᫨   [Define Field]  ᮧ     ।
                ,   SQL*Forms  㤠   騩   ⥪
              .   SQL*Forms  ⠭        
              ⥪饣 ⥪,      ࠦ       ப
              ﭨ    ,  ࠭  .

[Down]        [Down] ⠭ ꥪ, 易   ᫥饩  ,
                ⢥  ⥪饣  ꥪ  ⥪.   ਬ,   ᫨
                 [Down]  ⠡ ࠬ஢  Field  Definition,
              SQL*Forms         ⥪饣 ⥪ ,  ஥
              易   ᫥饩   ⠡ ࠬ஢.

[Insert Record
               [Insert Record] 㤠 騩 -  ⥪    ⮣
              ஢ ꥪ,    ।,     㣨
              ꥪ⮢     ஢.  ਬ,  ᫨   
              [Insert  Record],   室    ⠡   ࠬ஢   Block
              Definition,  SQL*Forms 㤠 ⥪騩 ⥪    
              ⥪ . ᫨  ।    ⮬     
              ,   SQL*Forms  ⠭       ⢥
                ⥪饣 ⥪,     ࠦ      
              ப ﭨ,    ࠭  .

[Navigate]    [Navigate] 뢠    Navigate, ஥ 
                ८। ⥪   .

[Next Block]  [Next Block] ⠭ ᫥騩   (
              ᫥⥫쭮 ࠭ ।)    ⥪饣
              ⥪  㤠   騩 ⥪ .

[Previous Bloc
              [Previous Block] ⠭ ।騩  ( ᫥⥫
               ࠭ ।)    ⥪饣 ⥪  㤠
               騩 ⥪ .

[Up]          [Up] ⠭ ꥪ, 易   ।饩 ,
                ꥪ  ⥪饣  ⥪.  ਬ,  ᫨  
              [Up]   ⠡  ࠬ஢  Field  Definition,  SQL*Forms
                ⥪饣 ⥪  ,   ஥  ⭮  
              ।饩    ⠡ ࠬ஢.

[Zoom In]     ᫨  ꥪ ⥪饣 ⥪  ஢ ꥪ⮢,
                ஬    ࠡ⠥,  [Zoom In] ন ⥪騩
               ⥪.  ,  ᫨  ⠪ ꥪ     
              ஢,   [Zoom   In]  ⠭ ꥪ, ⭮騩 
              ࢮ  ,   ꥪ⮬   ⥪饣   ⥪.   ਬ,
              ᫨  諨   [Zoom  In]  ⠡ ࠬ஢
              Block Definition   ⠡ ࠬ஢ Field Definition  
                  ⥪饣   ⥪    ,  SQL*Forms 
              ,  易  ࢮ     ⠡   ࠬ஢,
                ⥪饣 ⥪.

                                      7
         

  㭪樨   SQL*Forms(Design)      ᥡ  ⢨   ࠧ 
믮   ६饭  - ..  , ஬  ⥪. 
믮  㭪樨,   㭪樮 .

                                    -- 81 --



   㬥      SQL*Forms  뫠    㭪樮  
 ᮮ⢥ 㭪権 ( ਬ,  [Next Field] ),     
䨧᪨ .   ᤥ  ⮣,   ࠧ  ⥬  ࠡ
  ࠧ묨 䨧᪨ 蠬,    㭪樮
.

  砥 ᫥騥 ⥬  㭪樮 蠬 SQL*Forms(Design)
-  ;
- ᠭ 㭪樮 ;
- 㯯 㭪樮 .

         ᬠਢ  ,    ᯮ  
SQL*Forms(Run Form).   ଠ樨   . "SQL*Forms Operator's Guide".

          

    뢠,     䨧᪨    襩 ⥬
ᮮ⢥ 㭪樮 蠬 SQL*Forms.     
        SQL*Forms     "ORACLE Installation and User's
Guide"   襣 DBA.   ⮣, ⮡ ᬮ   
⥪饣  ⥪,    [Show Keys]    SQL*Forms(Design).

砭:      ⥬     -  
ࠧࠡ⪨  (    SQL*Forms(Design)  ), 㣠   
᪠    ஢    (     SQL*Forms(Run Form) ).
,    ᯮ 㦭    .

         ᠭ 㭪樮 

  ᥪ  ᮤন ᠭ  ᫥ 㭪樮 
SQL*Forms(Design):
[Accept]                [Next Block]
[Beginning of Line]     [Next Field]
[Bookmark]              [Next Page]
[Cancel]                [Next Record]
[Change Display Type]   [Paste]
[Clear Field]           [Previous Block]
[Copy Object]           [Previous Field]
[Cut]                   [Previous Page]
[Define Field]          [Previous Record]
[Delete Backward]       [Refresh]
[Delete Character]      [Resize Field]
[Delete Line]           [Retrace]
[Delete Record]         [Right]
[Down]                  [Screen Painter]
[Draw Box/Line]         [Scroll Down]
[End of Line]           [Scroll Left]
[First Line]            [Scroll Right]
[Help]                  [Scroll Up]
[Insert Line]           [Search]
[Insert Record]         [Select]
[Insert/Replace]        [Show Keys]
[Last Line]             [Undo]
[Left]                  [Up]
[List]                  [Zoom In]
[Menu]                  [Zoom Out]
[Navigate]


                                    -- 82 --



⭠  㭪,    믮  㭪樮쭠  ,
    ⥪,    ஬   ᯮ.   ᥪ
ᮤন  ᠭ  㭪樮         ᨬ   
⥪,    ਬ.

[Accept]               [Accept] 뢠   
                    室   .

                      ଥ    ⠡  ࠬ஢  [Accept] 뢠
                    ⥪   ⠡ ࠬ஢   ࠭  
                    ᤥ  .

                      ࠭ । [Accept] ࠭  ᤥ
                     . SQL*Forms 뤠  .

[Beginning of Line]
                      [Beginning of Line] ६頥   ࢮ
                    ஡ (  ) ⥪饣 .

                          ஫஢   [Beginning   of   Line]
                    ६頥   ࢮ ஡ ⥪饩 ப.

[Bookmark]           help-⥬ [Bookmark] 砥  ⥪饣
                    help-࠭   㪠⥫ placeholder.

                      䥩 ࠧࠡ⪨ [Bookmark] 뤠 help-࠭,
                       㦥  ⨫    help-⥬  㪠⥫
                    placeholder.
                    ⢥ ⥬:  ⢮ help-⥬ Bookmark

[Cancel]             ଥ, ⠡ ࠬ஢    [Cancel]:
                    - ⬥ ⥪  ,     ⢨
                      (ਬ, ⨥  );
                    - ⬥  , ᤥ  ⥪饣
                      ꥪ  頥    .

                     ࠭ । [Cancel] ࠭  ,
                      ᤥ. SQL*Forms 뤠  .

[Change Display Type]
                     ଥ [Change Display Type] 뤠 ⠡ -
                    ஢,  ᮮ⢥  ⥪饩  ଥ,    頥
                      ᮮ⢥騩 .

                      ⠡  ࠬ஢  [Change  Display Type] 뢮
                    ,  ᮮ⢥ ⥪饩 ⠡ ࠬ஢,  
                    頥   ᮮ⢥騩 .

[Clear Field]         [Clear Field] 頥 楫 .
                        ஫஢  [Clear  Field]  ࠥ 
                     ப  "稢" ⥪ ( wrap ), ᫨ 
                    .

[Copy Object]       [Copy Object] 뤠   Source Object 
                    Target  Object,          ஢
                    ꥪ    뫠  ,  ᫨   
                    ⥪饩 ଥ   㣨 ଠ,    
                    ࠢ 㯠.

                                    -- 83 --



[Cut]               - 㭪樮  ࠭ ।   
                      ஫஢;

                    -㤠 ࠭ ꥪ    ࠭  ࠭
                        paste   ,    믮 
                       㣨 ꥪ⮬    .
                    ⢥ ⥬:    뢠 ꥪ [Define Field]

[Define Field]:     - 㭪樮 ⮫쪮  ࠭ ।;
                    - 뢮  ⠡  ࠬ஢ Field Definition
                        Field  Definition,    ᨬ  
                      ⮣,    訬 ⮬  㬮砭
                    - ⠡ ࠬ஢  ଠ.

                    ᫨      饥  ,   [Define
                    Field]  ,  ᮮ⢥ ࠭
                    ,  ⥪饩  ⠡ ࠬ஢  ଥ. ᫨ 
                    ᮧ    ,  [Define  Field]    
                      ⥪饩    ⠡ ࠬ஢  ଥ.  
                          㤥   ᮤঠ   ,   
                    ᮮ⢥  ,  ஥    ᮧ   ࠭
                    ।.
   ⢥ ⥬:      ࠭ ।
                       ᯮ짮   樨 ࠧࠡ⪨  㬮砭

[Delete Backward]       [Delete Backward]:
                     - 㭪樮     ஫஢;
                     - 㤠 ᨬ ᫥  ⥪饩 樨    
                       ६頥  ᨬ ࠢ       .

[Delete Line]        [Delete Line]:
                     - 㭪樮 ⮫쪮   ஫஢;
                     - 㤠 ⥪ ப   ᤢ  ⠢訩   ⥪,
                       ᫨ , .

[Delete Record]      [Delete Record] 㤠 ⥪    
                     ⠡  ࠬ஢.   䨧᪨ 㤠  
                     ᫥饩 樥 commit.

[Delete Character]   [Delete Character]:
       -  㭪樮  ⮫쪮            ஫஢;
       -  㤠  ᨬ    ⥪饩 樨     ᤢ 
          ᨬ  ࠢ         .

[Down]                ଥ [Down]:
      -  뢮     ᫥饩    ,  ᯨ᪠
         ਣ஢,  ஫     ஫஢ ;
      -  뢮    ,   ᫨  ⥪  뫠 ᫥;
      -  祣  ,  ᫨ ⥪饩   .

       ⠡ ࠬ஢ [Down]:
      -  ६頥     ப,  ᫥饩   ;
      - 祣  , ᫨  室   (⮩) .

       ࠭ । [Down]:
      -  ६頥         ᨬ ;



                                    -- 84 --



      - ६頥    ࢮ ப ࠭, ᫨  
        ,     室  ᫥ ப ࠭,
        祬, ࠭  ஫  ⨪쭮, ᫨  室.

[Draw Box/Line]           [Draw Box/Line]:
      - 㭪樮 ⮫쪮  ࠭ ।;
      -      ࠭묨  窠,   ᫨   窨
        室   ਧ⠫쭮    ⨪쭮 ᪮;
      -  ,  ᯮ  ࠭ 窨     ⢥  
        㣫 祪  ,  ᫨    窨  室  
          ਧ⠫쭮   ⨪쭮 ᪮.
      ⢥ ⥬:   ᮢ   

[End of Line]
     [End of Line] ६頥   ࠢ -     ᨬ
   ⥪饣  ,  ஫      室.

      ஫஢  [End  of  Line]  ६頥     ࠢ
   ᫥ ᨬ ⥪饩 ப.

[First Line]        [First Line]:
  - 㭪樮 ⮫쪮      ஫஢;
  - ६頥     ࢮ  ᨬ  ࢮ   ப       
       ஫஢,   ஫  室⬮.

[Help]
   help-⥬ [Help] 뤠      "About
  the Help System".

   䥩 ࠧࠡ⪨ [Help]  뢠  help-⥬ SQL*Forms,  뤠
  ⥪   ⥪饬  䥩. ᫨ 뤠 ᮮ饭 
  訡  ப ᮮ饭, [Help] 뤠 ⥪   ⮩ 訡.

[Insert Line]       [Insert Line]:
  - 㭪樮  ⮫쪮   ஫஢;
  - ᮧ  () ப ᫥ ⥪饩.

[Insert Record]          [Insert Record]:
  - 㭪樮  ଠ  ⠡ ࠬ஢;
  - ᮧ  (  )  ᫥ ⥪饩.

[Insert/Replace]        [Insert/Replace]:
  - 㭪樮  ,  ஫஢    ࠭ ।;
  - ४砥  SQL*Forms    ०  ⠢    ०   .

 ० ⠢ SQL*Forms 頥  ᨬ,    ,  ᫥ 
⥪饩 樨.  ०  SQL*Forms ४뢠 騥 ᨬ
ᨬ,   , 稭  ⥪饩 樨 .
砭:  ப   ﭨ  뢠,      ० 室
            SQL*Forms - ⠢  .
⢥ ⥬:  饭 ப ﭨ Ins
                   饭 ப ﭨ Rep

[Last Line]          [Last Line]:
  - 㭪樮 ⮫쪮     ஫஢;
  - ६頥        ᫥  ᨬ   ᫥  ⮩
    ப    ஫஢, ஫  室.


                                    -- 85 --



[Left]

   ଥ  ⠡ ࠬ஢ [Left]:
  - ६頥     ᨬ    ;
  -   ६頥             ஫஢.

     [Left]:
  - ᢥ稢   ᫥  ⥪饩;
  - ᢥ稢  ᠬ  ࠢ  ,  ᫨   ⥪ 뫠 ᠬ .

   ࠭ । [Left]:
  - ६頥     ᨬ     ;
  - ६頥    ࠩ ࠢ ᨬ    ࠭,  ᫨
       ,       室   ࠩ 
    樨 ࠭,  ஫ ࠭ ਧ⠫쭮    室.

[List]
   [List] 뤠 ᯨ᮪ 祭  , ᫨ ⠪   ᯨ᮪ .
   砭:  ப  ﭨ 뢠,  㯥    ᯨ᮪ 祭
                 .
   ⢥ ⥬: 饭 ப ﭨ List 5-16

[Menu]                    [Menu]:
   - 뢮  ;
   - ⨢  .

[Navigate]
  [Navigate] 뤠  ࠭   Edit Object,  ஥ 
   "室"   ⠡ ࠬ஢    ଥ  ।
  ꥪ (..  ࠭, ,   ਣ  ଥ).

  砭:     ᯮ   [Navigate]      ⢥ 砩襣  
    אַ  㯠    ଥ  ⠡ ࠬ஢ ⭮ ꥪ.
    ᢮⢮ ᮡ      ࠧࠡ稪,  ࠡ  
  ନ 筮 ०, ..   ⮬ 砥 筮 ॡ  
  ࠭  뢠,  祬  㣨 ⮤ 㯠.

[Next Block]                    [Next Block]:

   - 㭪樮 ⮫쪮  ࠭ ।;
   -   ᫥騩      ᫥⥫쭮    ⥪騬;
   - 頥  undo.

[Next Field]                     ଥ [Next Field]:

   - ६頥  ᫥⥫쭮  ᫥饬   , ஫쭮 
         ஫஢ ;
   - ६頥         ஫쭮     
     ஫஢;
   -   ⥪騬  ࢮ    ஫쭮     ଥ,  ᫨ 
            ᫥ .

   ᯨ᪥ 祭 [Next Field]:
   - ६頥  ,   ᫥饬 祭    ᯨ᪥ 祭;
   - ६頥   ࢮ 祭   ᯨ᪥   祭,  ᫨  
     室   ᫥   祭.



                                    -- 86 --



    [Next Field]:
   - ६頥    ࠢ,  ᫥饩   樨 ;
   - ६頥   ࢮ  樨  ,  ᫨    室 
     ᫥ 樨.

   ⠡ ࠬ஢ [Next Field]:
   - ६頥   ࠢ,   ᫥饬     ஫쭮 ;
   - ६頥        ࢮ         ஫쭮    
     ⠡ ࠬ஢,  ᫨    室  ᫥ .

   ࠭ । [Next Field]:
   - ६頥  - ᫥ ࠢ    ᢥ    -  ᫥饬
         (⮫쪮    ⥪饩 ࠭),    ⥪騬;
   - ६頥   ࢮ     (   ⥪騬), ᫨
         ᫥ .
  ⨬,   ᠭ ६饭     ᫥⥫
  ஢ .

[Next Page]                    [Next Page]:

  - 㭪樮 ⮫쪮  ࠭ ।;
  - 뢮 ᫥ ࠭ ࠭ ।,  ᫨  ࠭
    ;
  - ६頥   孨  㣮 ࠭;
  - 頥  undo.

[Next Record]       ଥ [Next Record]:

    - 뢮   ᫥饩         ,  ᯨ᪠
      ਣ஢,  ஫      ஫஢ ;
    - 뢮  , ᫨ ⥪  뫠   ᫥;
    - 祣  , ᫨ ⥪  - .

  ⠡ ࠬ஢ [Next Record]:
    - ६頥     ப     ᫥饩   ;
    - 祣  ,  ᫨  室     ( ⮩ ) .

[Paste]  [Paste]:

  - 㭪樮 ⮫쪮  ࠭ ।    ஫஢ ;
  - 頥 ᮤন  paste ( .. ꥪ  , ᠭ 
       ᫥ ࠧ )  ࠭,  樮 孨  㣮
    ࠭      .
  ⢥ ⥬:  ⠭ ꥪ

[Previous Bock]
                    [Previous Bock]:
  - 㭪樮 ⮫쪮  ࠭ ।;
  -  ⥪騬     ।騩     ᫥⥫쭮 ;
  - 頥  undo.

[Previous Field]         ଥ [Previous Field]:

     - ६頥   ।饬 ᫥⥫쭮  ⠡
       ࠬ஢ - , ஫쭮      ஫஢;
     - ६頥         ஫쭮     



                                    -- 87 --



       ஫஢;
     -  ⥪騬  ࢮ    ஫쭮     ଥ,  ᫨ 
              ᫥ .

   ᯨ᪥ 祭 [Previous Field]:
     - ६頥    ।饬 祭   ᯨ᪠;
     - ६頥       ᫥  祭   ᯨ᪠, ᫨ 
       室  ࢮ.

    [Previous Field]:
     - ६頥      ।饩   樨 ;
     - ६頥   ᫥ 樨 , ᫨    室 
       ࢮ.

   ⠡ ࠬ஢ [Previous Field]:

     - ६頥    ।饥     ஫쭮  
       ⠡ ࠬ஢;
     - ६頥      ᫥        ஫쭮  ,
       ᫨    室     ࢮ.

   ࠭ । [Previous Field]:
     - ६頥   -  ࠢ      ᭨     -  
       ।饬   ,       ⥪騬;
     - ६頥   ᫥    (     ⥪騬),
       ᫨       ࢮ .

[Previous Page]          [Previous Page]:

  - 㭪樮 ⮫쪮  ࠭ ।;
  - 뢮 । ࠭    ࠭ ।;
  - ६頥   孨  㣮 ࠭;
  - 頥  undo;
  - 祣    ,  ᫨  ⥪ ࠭ - ⢥.

[Previous Record]
                   ଥ [Previous Record]:
        - 뢮   ।饩        ,  ᯨ᪠
          ਣ஢,  ஫      ஫஢ ;
        - 祣  ,  ᫨    室     ࢮ .

    ⠡ ࠬ஢ [Previous Record]:
        - ६頥          ப    ।饩 ;
        - 祣  ,  ᫨    室     ࢮ .

[Refresh]           [Refresh]:

  -  ⥪騩 ࠭;
  - ୮  뢮   ,    ᤥ  ࠭,  ᫨
    ᯮ  ନ ᨬ쭮 ०;

  - 㤠  ,    ᤥ  ࠭,   ୮ 뢮
    ।騥 祭, ᫨    ᯮ  ନ 筮 ०. (
    ன⢠  筮  ०     㭪樥 ନ,  
    SQL*Forms.)

[Resize Field]         [Resize Field]:


                                    -- 88 --



   - 㭪樮 ⮫쪮  ࠭ ।;
   -   뢮 ࠭ ,  ࠢ  ࠩ  
        ⥪  .

[Retrace]     [Retrace]:
       - 㭪樮 ⮫쪮  help-⥬;
       - 뢮 ࠭ ,   ஬  뫨 ।   ⥪騬  ࠭
          ( ⥪饩 ᨨ   ࠡ help-⥬).
  ⢥ ⥬:  ⢮ help-⥬ Retrace  8-4

[Right]
   ଥ  ⠡ ࠬ஢ [Right]:
       - ६頥     ᨬ     ࠢ;
       -  ६頥            ஫஢.

     [Right]:
       - ᢥ稢      ࠢ    ⥪饩   樨;
       -  ᢥ稢  ࠩ   ,  ᫨   ⥪  -
          ࠩ ࠢ.

   ࠭ । [Right]:
       - ६頥     ᨬ     ࠢ;
       - ६頥    ࠩ  ᨬ     ࠭,
         ᫨   ,      室  ࠩ ࠢ
        樨 ࠭, ஫ ࠭ ਧ⠫쭮  室.

[Screen Painter]
  [Screen Painter] 뢠 ࠭ ।  頥   ,  
   ࠭,  ᮮ⢥ ⥪饬 ⥪.

  ਬ,  ᫨   室    ⠡  ࠬ஢ Field  Definition  
  ⥪    ।  CLIENT_ID,  ⨥ [Screen Painter]
      CLIENT_ID  ࠭ ।.

[Scroll Down]
   ᯨ᪥ 祭 [Scroll Down]:
       - ஫ ᮤন ᯨ᪠  ਡ⥫쭮  80% 뢮
         ᯨ᪠    ࠭,   뢠 祭,  뫨 ""
         ⥪饣 뢮 ᯨ᪠;
       - 室  ᠬ  孥  뢥   祭, 
         ஫஢ 蠥.

    ஫஢ [Scroll Down]:

       - ஫ ᮤন   ஫஢    ਡ⥫쭮
          80 % 뢮 ⮩   ࠭,  뢠  祭,  
         뫨   "" ⥪饣 뢮  ஫஢ ;
       - 室  ⮬  ⮫    ᠬ  孥   뢥 ப,
          ஫஢   蠥.

   ⠡ ࠬ஢ [Scroll Down]:
       -  ஫ ᮤন  ⠡   ࠬ஢  ਡ⥫쭮 
       80% 뢮 ⠡    ࠭,  뢠 祭,  뫨 ""
       ⥪饣 뢮 ⠡ ࠬ஢;
       -    襭 ஫஢  室     ,   室
        ,   뢥    ᫥⥫ ஬.



                                    -- 89 --



[Scroll Left]       [Scroll Left]:
     - 㭪樮 ⮫쪮  ;
     - ஫ ਬ୮ 80%  뢥 ᮤন    ࠢ,
       뢠   ,  뫨 "᫥"   뢮 .

[Scroll Right]   [Scroll Right]:
     - 㭪樮 ⮫쪮  ;
     - ஫ ਬ୮ 80%  뢥   ᮤন   ,
       뢠 ,  뫨 "ࠢ"   뢮 .

[Scroll Up]    ᯨ᪥ 祭 [Scroll Up]:
      - ஫ ᮤন ᯨ᪠    ਡ⥫쭮  80 % 뢮
        ᯨ᪠  ࠭, 뢠 祭,  뫨 "" ⥪饣
        뢮 ᯨ᪠;
      - 室  ᠬ 孥  뢥   祭, 
        ஫஢ 蠥.

     ஫஢ [Scroll Up]:

   - ஫ ᮤন   ஫஢  ਡ⥫쭮  80
     % 뢮 ⮩      ࠭,  뢠 祭,     뫨
     "" ⥪饣 뢮  ஫஢ ;
   - 室    ⮬  ⮫  ᠬ 孥   뢥    ப,
      ஫஢ 蠥.

    ⠡ ࠬ஢ [Scroll Up]:
    - ஫ ᮤন ⠡ ࠬ஢    ਡ⥫쭮  
      80 % 뢮 ⠡  ࠭,   뢠 祭,  뫨 ""
      ⥪饣   뢮 ⠡ ࠬ஢;
    -  襭 ஫஢ 室  ,   室  ,
         뢥      ᫥⥫ ஬.

[Search]                    [Search]:
   - 㭪樮 ⮫쪮   ஫஢.
   - 뢮      Search   Criteria, ஥    
     ᪠  ,   ,  㪠 ப ⥪.

[Select]
     [Select] ४砥 祭, ⠪ ࠧ ⨢
  ।饥 ⨢ 祭.

   祢  ᫮  help-⥬  [Select]   롨ࠥ 祢 ᫮, 
  ஬ 室 .

    ᯨ᪥  祭  [Select]  롨ࠥ  祭,   ஬ 室
  .
    [Select] 롨ࠥ ,   ஬  室 .
   ࠭  ।  [Select]  砥     ࠭.  SQL*Forms
  ᯮ  ࠭    ࠬ  㭪 ࠭ ।.

[Show Keys]
     [Show Keys] 뢮  ࠭  । ,  
     ᮮ⢥  ⮬,      । (   ᤥ SQL*Forms 
     㬮砭  )  襩 ॣ樨  SQL*Forms.

[Undo]   [Undo]:
     - 㭪樮 ⮫쪮  ࠭ ।;
     - ⬥ ᠬ ᫥ ,      믮  ࠭

                                    -- 90 --



       ।;
     - ᫥⥫쭮 ⬥  ।騥  樨   ࠭  ।
        ⨨ ⮩  ⭮;
     -  ⬥  ﭭ ⥪;
     -  ⬥  "undo".

砭: SQL*Forms 頥  undo   室   
           ࠭栬   室  ࠭ ।.
⢥ ⥬:  ࠭祭  undo,  -l    SQL*Forms(Design)

[Up]                     ଥ [Up]:
        -  뢮    ।饩      ,  ᯨ᪠
           ਣ஢, ஫    ஫஢ ;
        -  祣    ,  ᫨  室    ࢮ .

    ⠡ ࠬ஢ [Up]:
        - ६頥         ப,     ।饩 ;
        -  祣    ,  ᫨  室    ࢮ .

    ࠭ । [Up]:
        - ६頥         ᨬ   ;
        - ६頥   ᫥ ப ࠭,   ᫨     
          ,      室    ࢮ  ப  ࠭,
          祬, ࠭ ஫ ⨪쭮,  ᫨     室.

[Zoom In]   [Zoom In]:
        - 뢮   ⠡ ࠬ஢   ⨯   ꥪ,  
              蠣   娨   ꥪ⮢, 祬 ⥪騩 ⨯ ꥪ;
        - 祣   ,  ᫨    室     ଥ   
          ⠡  ࠬ஢  Trigger  Step   Definition,     ⠪  ᫨
          ⥪騩 ਣ    ਣ஬ V3   室  ଥ
           ⠡ ࠬ஢ Trigger Definition.

     ᯮ [Zoom In], SQL*Forms ६頥   ᫥饩
   娨 ꥪ⮢,  稭  ஢ ⥪饣 ꥪ:
        - ଠ
        - 
        - 
        - ਣ
        - 蠣 ਣ ( ⮫쪮  ਣ஢ V2 )

   ..  SQL*Forms ।      娨,   ন ⥪騩
   ⨫ 뢮 - ⠡ ࠬ஢   .  ᪫祭  
   砩,      [Zoom In]    Form  Definition,  ⮣
   SQL*Forms   室      ⠡  ࠬ஢  Block Definition  
   Block Definition  ᨬ  ⨫ 뢮  㬮砭.
   ⢥ ⥬:  ᯮ짮   ⢥ 樨 ࠧࠡ⪨ 
                       㬮砭

[Zoom Out]            [Zoom Out]:

     -  뢮   ⠡ ࠬ஢  ꥪ,  
        ⥪騬  ꥪ⮬.  ꥪ,  뢮, 筮   蠣
          娨 ꥪ⮢, 祬 ⥪騩 ꥪ.
     -  祣   ,  ᫨   室    ଥ Form Definition.




                                    -- 91 --



  ᯮ  [Zoom  Out],  SQL*Forms ६頥    
᫥饩  娨 ꥪ⮢, 稭  ஢ ⥪饣 ꥪ:
     - ଠ
     - 
     - 
     - ਣ
     - 蠣 ਣ ( ⮫쪮  ਣ஢ V2 )

SQL*Forms ।      娨     ஢      ࠧ,
 ᪫祭 ,   ⥪騬 ꥪ⮬    ਣ,  
   ଠ.  .. SQL*Forms ।   娨,  
ন  ⥪騩  ⨫  뢮  - ⠡ ࠬ஢  ,  
.

        㯯 㭪樮 

    ᥪ ࠧ  㭪樮   SQL*Forms(Design) 
㯯    ᭮ ࠪ⨪:
     - 㭪樨 ࠢ ஬;
     - 㭪樨 ।஢;
     - ᭮ 㭪樨 ࠧࠡ⪨;
     - 㭪樨 ࠭ ।஢.

    ᯮ짮 ⠪ ࠧ 㭪樮   㯯
 । 㦭 㭪樮쭮 ,   ,   
ᤥ ( ਬ,  ६        㣮  )  
 室 믮 । ⢨ ( ਬ,  ࠭ । ).
  ।,    㭪樮쭠    㦭,  
ᠭ  ⮩ .

砭:  㭪樮   , 祬
             㯯.

        㭪樨 ࠢ  

[Beginning of Line]          [Previous Block]
[Down]                       [Previous Field]
[End of Line]                [Previous Page]
[First Line]                 [Previous Record]
[Last Line]                  [Right]
[Left]                       [Scroll Down]
[Next Block]                 [Scroll Left]
[Next Field]                 [Scroll Right]
[Next Page]                  [Scroll Up]
[Next Record]                [Up]

        㭪樨  ।஢

[Beginning of Line]           [First Line]
[Clear Field]                 [Last Line]
[Cut]                         [Insert Line]
[Delete Backward]             [Insert Record]
[Delete Line]                 [Insert/Replace]
[Delete Record]               [Left]
[Delete Character]            [Paste]
[Down]                        [Right]
[End of Line]                 [Search]


                                    -- 92 --



        ᭮  㭪樨  ࠧࠡ⪨

[Accept]                      [Next Record]
[Cancel]                      [Previous Record]
[Change Display Type]         [Refresh]
[Copy Object]                 [Screen Painter]
[Help]                        [Select]
[Insert Record]               [Show Keys]
[List]                        [Zoom In]
[Menu]                        [Zoom Out]
[Navigate]

㭪樨 ࠭ ।஢

[Cut]                              [Previous Block]
[Define Field]                     [Previous Field]
[Down]                             [Previous Page]
[Draw Box/Line]                    [Previous Record]
[Left]                             [Resize Field]
[Next Block]                       [Right]
[Next Field]                       [Select]
[Next Page]                        [Undo]
[Next Record]                      [Up]
[Paste]

                             8

   HELP-

    SQL*Forms   help-⥬  㬥樥  
த,  ன  砥 , 室  䥩 SQL*Forms
(Design).   㬥 ⭮ ⮫쪮   SQL*Forms(Design) ,
 ᭮, ᮤন ਠ   ⭮ -    䥩
ࠧࠡ⪨ (ਬ, 樨  Generate,  Field,    Edit
Object).    ਠ   ,  ..     
  ࠡ  ⨬ த⮬,      ⥬ ন
ᠬ    㤮 ⮤ 㯠.

    ਠ,  室  help-⥬,     
砥  㣨   㬥樨  SQL*Forms.   
ࠧ,   help-⥬ SQL*Forms  ꥬ  
⮣ ,  ன  室 .

  砥 ᫥騥 ⥬:
    - ࣠ help-ਠ;
    - ᮡ help-⥬.

    ⠪  ᬠਢ  ⥪ ࠡ ଠ SQL*Forms,
  室  help-⥬.   砥 ଠ  ⮬, 
뢠  help-⥬.
⢥ ⥬:    맮 help-⥬


        ࣠ help-ਠ

ଠ  help-⥬ ࣠  ⥬.     ᪨
冷        ⥬  help-⥬  (   ࠦ  ⠡
ᮤন help-⥬ ),  짮⥫    㯠  㦭

                                    -- 93 --



ଠ樨.    ਭ樯,         ⥬ help-⥬ ,
  ⭮,    㤥  뢠   ࠭   ଠ樨
ᯮ冷筮,       室   ஥ ᢮ ਫ.
稥   ⥬ 祢 ᫮   砥  ந
   ଠ樨.

  help-࠭,     뢠  ⤥   䥩,
।⠢ ଠ  ⠭⭮ . -, help-࠭  ,
  室  䥩 ࠧࠡ⪨             ⮬
⭮ ⥪.  ⥬ help-࠭    騩  
楯権,  ⭮   ⮬  䥩.

elp-⥬ ।⠢ ଠ ⠪ ࠧ, ⮡   
  ,    ਭ 襭  ⭮
஡  ࠧࠡ⪨  த ᢮ ࠡ.  쪮 ᫨  ॡ
 楯㠫 ਠ,    ਤ ᬮ  
help-࠭.

㭮  8-1  뢠 help-࠭    ⠡
              ࠬ஢ Block Definition.
       Ŀ
ਬ   Action  foRm  Block  Trigger  Procedure  Image  Help  Options 
help-    Block Definition Form and Spread Table 
-࠭ Ŀ 
                                                                    
        ĳ Use Block Definition form or spread table to create     
           or edit a block for a form in your application and to   
           provide basic information about it. The spread table    
           displays details about all the blocks for the current   
            application, while the form displays all the details    
            about a specific block.                                 
                                                                    
            Press [Change Display Type] to move between the         
            form and the spread table.                              
        ĳ                                                         
         V                                                          
         
         
        Frm: ORDER_ENTR    Blk: ITEMS     Fld:       Trg:        <Rep> 
       

        ᮡ help-⥬
   help-⥬      SQL*Forms(Design)   ন ᫥騥
ᮡ  襭 㯠  help-ଠ樨:
     -   help-⥬;
     -   help-⥬;
     - ᮤন help-⥬;
     -  help-⥬;
     - 祢 ᫮  help-࠭;
     -  ਨ;
     - ᢮⢮ Retrace;
     - ᢮⢮ Bookmark;
     -   訡.

          help-⥬
᭮   help-⥬,  뢠 "About the Help System", ᪠뢠-
  ⮬,   짮 help-⥬.    ଠ । ⥬,
 ᯮ짮 help-⥬ .

                                    -- 94 --



          help-⥬

    help-⥬ ࠢ  ᭮묨 㭪ﬨ.   
ᥣ,   뢠 help-⥬,   ⠥  ࠭    ६,
  室  .    ࠢ ⥬ १ ᫥騥 樨:

Exit       頥   , 㤠  諨    SQL*Forms  맮
           help-⥬.
Contents   뢮 ⠡ ᮤন help-⥬.
Previous   뢮 ।騥 ⥬      ⥬.
Next       뢮 ᫥騥 ⥬    ⥬.
Retrace    뢮 help-࠭,   室 ।   ⥪騬 help-࠭.
Bookmark   砥 㪠⥫ placeholder ⥪饩   help-⥬.

        ন help-⥬
 ᮤন help-⥬   ᯨ᮪ ⥬,  ᬠਢ 
⥫ help-⥬.   ᯮ짮 ஢ ࠭   㯠  
ଠ樨    ⨬  ⥬,     ᯮ짮 㭪樮  
  롮    ⥬   䥩.   ॡ㥬
ଠ .

         help-⥬
 help-⥬ ᮤন ᯨ᮪  ⥬,   祭   ⥫
help-⥬.  ᯨ᮪ ஢  䠢  ᮤন ४
뫪.    ᯮ짮  ஢  ࠭  㯠  ଠ樨 
⥬ ⮣ ᯨ᪠,   ᯮ짮 㭪樮     
롮      㭪    䥩.   ॡ㥬
ଠ .

        祢 ᫮  help-࠭

祢  ᫮  help-࠭ -  ᢥ祭 ᫮  㯯 ᫮,
      ⥪    help-࠭.   祢 ᫮
 ⥬  help-⥬,  易    ⥪饩   ⥬.   
  뢥  help-࠭    ⥬, ᮮ⢥饩  祢
᫮,  ६⨢    祢 ᫮   [Select].

         ਨ
  ਨ 뢮 ᯨ᮪ ⥬ help-⥬,   ⬥砥 ன
   help-⥬ -६ ⥪饩  help-ᨨ.    ᢮⢮  
⮫쪮   ᬮ,    뫨  help-⥬,    
⥬  ⮣ ᯨ᪠  ਨ      ᮮ⢥騩
help-࠭.

        ⢮ Retrace
⢮ Retrace  help-⥬     ᫥⥫쭮 
 蠣      help-࠭,     ᬠਢ  -६
⥪饩 help-ᨨ.    롨ࠥ Retrace    
help-⥬      [Retrace]    help-⥬, SQL*Forms
뢮  help-࠭,      室  ⥪饣 help-࠭.
⢥ ⥬:    [Retrace]

        ⢮ Bookmark

⢮ Bookmark help-⥬      㪠⥫ placeholder
⥪饩  help-⥬.  ᫨    롨ࠥ  Bookmark    help--



                                    -- 95 --



⥬  ⥬ 頥  SQL*Forms (..  室  help-⥬), 
ᬮ   祭 ࠭ ⮬ ࠧ,  [Bookmark].
⢥ ⥬:    [Bookmark]

          訡
Help-࠭,   ᮮ饭  訡 SQL*Forms(Design),
㯭   help-⥬.  ᫨   [Help],  
ᮮ饭  訡      ப ᮮ饭,  SQL*Forms 뤠
᪠,    訡,   ᪠  㤥 "뢠"
 䥩,   ஬    室 .

















































                                    -- 96 --
