


                    III            

                     9            


    ⮩    뢠 ନ஢ ꥪ SQL*Forms.   ,
 뢠 ᫥騥 ⥬:
     * । 
     * ࠪ⨪ 
     *   ⨯ 
 ⮩   뢠  ᮧ  ஢ .
易몥 ⥬:   2-5

        । 

    ᮧ                  䥩 (ࠧࠡ稪)
SQL*Forms १  । .

    ଠ । 

   ଠ   ।    -      (᪮) 䥩
SQL*Forms,      ।  ࠪ⨪ .   ଠ 뢠
ଠ 直 ࠧ ⮫쪮   .

㭮 9-1 뢠  ।   묨, 묨  ਬ.

       9-1    ଠ । 

   Action  foRm  Block  Field  Trigger  Procedure  Image  Help  Options
    Form Definition   
  
   Title:                    Order Emtry Application
   Validation Unit:          Field
   Mouse Navigation Limit:
   Default Menu Application:
   Starting Menu Name:
   Menu Security Group Name:
  
   --------------------------------- Comment -----------------------------
   This form defines an order entry system that allows operarors to query,
   enter, update, and delete customer orders.
  
  
  
  
  
  
 Enter title for this form.
 Frm: ORDER_ENTR  Blk:             Fld:             Trg:             <Rep>


  ⮭宦:  ⮡     ।  
᭮  믮 ᫥騥 蠣:
     1. ⮢,     ⥪ .  (    
         ⥪  ⥪ ,       易⥫쭮.)
     2. 롥  .



                                    -- 97 --



  ⠪ ᬮ  ।  ࠢ:
     * [Zoom Out]   । 
     * [Navigate]     ७ ⠡      ।
       ⥪ 

ࠪ⨪ 

    ।   ⮨   ࠪ⨪  
.    ࠪ⨪  ࠦ  ᫥騥 , 騥 :
     *  ଠ,  ,   ORACLE   頥  ଥ
     *  ଠ   SQL*Menu  믮
     *    ᯮ짮     ࠡ     ମ
     * ஢ 

   ࠪ⨪         ⮬   ࠧ  ।⠢   䠢⭮
浪. ,    ࠪ⨪  ।⢥  ᮮ⭮
      । .  ਬ,  Title () 
ଥ ।   -       ,      ।   Title
ࠪ⨪ .

  ᢠ ࠪ⨪  ⥬  祭   ⮢,
  ஫ ⮢.

      ਩

  ࠪ⨪   ।  ଠ  ଥ.
਩ -   ।⢮  ஢ ।祭  
ᮤঠ  .       ᭮   ᯮ   㣨
ࠧࠡ稪,    ᯮ  ,   ਫ,    ,
   ⫠  ਫ.

易⥫/易⥫:   易⥫

      ਫ      砭

  ࠪ⨪  ਫ   砭 뢠  ਫ
SQL*Menu,  ஥  뢠 SQL*Forms 直 ࠧ  믮 ⮩
  ।⢮  SQL*Forms (Run  Form).        
ਫ   믮  १  楤 REPLACE_MENU.

   祭  㬮砭: ࠪ⨪  ਫ     㬮砭
頥   DEFAULT,  । ਫ   㬮砭,
஥  ন SQL*Forms.

易⥫/易⥫:   易⥫
⢥ :   REPLACE_MENU, ⭠ 楤 16-24
                    SQL*Menu, 易  25-3


             㯯 

      
  ࠪ⨪  㯯    뢠 ਢ
㯯,   SQL*Menu  ᯮ짮  ਫ    
㬮砭.   SQL*Menu  ᯮ   ⠭  ।  権
,    뤠  砫  .



                                    -- 98 --



易⥫/易⥫:   易⥫
⢥ : SQL*Menu,   25-3

      ࠭祭 H 

   ࠪ⨪    ࠭祭   । ࠭祭
 , ஥ ଠ ᯮ,    ᪠  
SQL*Forms (Run Form). ࠭祭     ।  ()
    ।⢮ .  㯭 ࠭祭
  -  , , ,  ଠ:

         ⠭  ࠭祭    ,  
                ⥪饬  .    ⠭
         ⮫쪮   ⮣,    ᯮ    
        .

             ⠭      ࠭祭    ,
           ᤥ        ⥪饬   ⥪騬
        ⨥  ⮬   .

         ⠭      ࠭祭    ,
           ᤥ      ⥪饩  ⥪騬
        ⨥    ⮬   .

ଠ            ⠭     ࠭祭    ,
           ᤥ       ⥪饩 ଥ  ⥪騬
        ⨥    ⮬ .

祭  砭:   ଠ
⢥ :   । ⮢ ⮡ࠦ D-4

        砫쭮  

  ࠪ⨪ 砫쭮    뢠    , ஥
SQL*Forms      ,       ଠ 믮    SQL*Forms
(Run  Form).         ਭ    ਫ    SQL*Menu,
।    ࠪ⨪  ਫ   砭.  
     砫쭮   娨   ਫ.

易⥫/易⥫:   易⥫
⢥ :   SQL*Menu,   25-3

      
  ࠪ⨪     뢠  ⥪,   뤠  
  । .  ,   㣨  ࠧࠡ稪,   ᬮ
           .  ,  ᫨
ଠ  ਫ  ,  樨஢    ,    
               .    ᯮ ࠪ⨪
  ᭮ ᠭ ,  ஥ ⨪   
।⠢.

     䥩 (ࠧࠡ稪)  SQL*Forms,   ஥ 樨஢ 
ࠪ⨪      255 ᨬ    ᮤঠ
஡.

祭  砭:   ࠪ⨪     㬮砭  ,
                    ஥  ᢮ ଥ   ࠬ  .
易⥫/易⥫:   易⥫

                                    -- 99 --



      ஢ 

  ࠪ⨪  ஢筮  । ஢ ,  
ᯮ ଠ   ᪠      SQL*Forms (Run Form).
 ஢  -  ଠ, , ,  .

祭  㬮砭:  ࠪ⨪ ஢筮   㬮砭 - NULL.
 祭 । ,  SQL*Forms   ᯮ짮  ஢
    㬮砭,   ।   襬 ஢筮 㦥.  筥,
᫨  ࠡ⠥   筮  ०  㦥,  NULL  ⥭ ஢-
  ⨯ .    㣨 㦥, NULL ⥭ ஢-
  ⨯ .
⢥ :
               ⠭ ஢筮   ०     D-2
               ஢  3-7

        

     ⨯        (, ⠪ ࠧ,
      ).    १,     .

       ⮫쪮  ਣ Pre-Form.  ਣ Pre-Form
 ਣ Post-Form -  ਣ,      믮.

   ࠡ稪  筮  ᯮ         ⮡ࠦ
  ᮮ饭    .
⢥ :    11-19
                     12-27

                    10              

    ⮩   뢠 ନ஢ ࠭筮 ꥪ  SQL*Forms.
 ,  뢠 ᫥騥 ⥬:
      * । ࠭
      * ࠪ⨪ ࠭

  ⮩   뢠  ஢ ࠭    㫨஢
࠭栬.

     । ࠭
   ᮧ ࠭  㫨 ࠭栬  䥩 (ࠧࠡ稪)
SQL*Forms १  । ࠭ 

 ७ । ࠭.

           ଠ । ࠭

  ଠ  ।  ࠭  -         䥩 (ࠧࠡ稪)
SQL*Forms,     ᮧ   ࠭.   ଠ 
 ᬮ  ଠ  ⤥쭮 ࠭   ࠧ.

:   ᯮ   ⠡   ७   । ࠭ ᫨ 
 ᬮ ଠ   祬    ࠭   ࠧ.

㭮 10-1 뢠  । ࠭  묨  ਬ.




                                   -- 100 --



            10-1         ଠ । ࠭

   Action  foRm  Block  Field  Trigger  Procedure  Image  Help  Options
    Page Definition   


      
       Page Number: 2               [ X ] Pop Up
      
       Page Size: X: 80  Y: 16     [ X ] Border
       View Size: X: 70  Y: 14     [ X ] Vertical Scroll Bar
       View Loc:  X: 5   Y: 2      [   ] Horizontal Scroll Bar
       View Page: X: 6   Y: 3      [ X ] Remove on Exit
      
       Title: Customer Information
      


 Enter the page number of the page.
 Frm: ORDER_ENTR  Blk: CUSTOMERS   Fld: CUSTID      Trg:          <Rep>


  ⮭宦:    ⨦  । ࠭
  , 믮 ᫥騥 蠣:

     1. ,    ⥪ . (     ⥪
            ⥪  ,          室.)
     2. 롥  ࠧ.
     3. 롥  䨪樨   ࠧ.
     4. ᫨    ⠡  ७  ।   ࠭, 
        [  뤠].


              ७ । ࠭

    ७  ।  ࠭  -      䥩
(ࠧࠡ稪)  SQL*Forms,     ᮧ   ࠭. 
⠡ ७   ᬠਢ ଠ    祬
  ࠭     ࠧ.  ,          ⮩
⠡ ७ 뢠   ࠧ.

: ᯮ  ।  ࠭,  ᫨   
ᬠਢ    ଠ    ࠭   ࠧ.

㭮 10-2 뢠  ⠡ ७ । ࠭ 
             묨  ਬ.

      10-2          ७ । ࠭

   Action  foRm  Block  Field  Trigger  Procedure  Image  Help  Options        
    Page Definition   
 
    Page           Pg Sz  Pg Sz  Vw Sz  Vw Sz  Vw Lc  Vw Lc  Vw Pg  
 Ĵ Number  Pop Up    X      Y      X      Y      X      Y      X    
  
     1     [   ]                                                    
     2     [ X ]    90     16     70     14      5     2      6     
                                                                    

                                   -- 101 --



                                                                    
 Ĵ                                                                  
                                                                    
 
                                  
 
 Enter the page number of the page.                                            
 Frm: ORDER_ENTR  Blk: CUSTOMERS   Fld: CUSTID      Trg:                   <Rep


  ⮭宦:  ⨦ ⠡ ७ । ࠭ 
 ,  믮 ᫥騥 蠣:
     1. ,    ⥪ . (      ⥪
            ⥪  ,         室.)
     2. 롥  ࠧ.
     3. 롥  䨪樨   ࠧ.
     4. ᫨  ଠ  । ࠭,    [ 
        뤠].


     ࠪ⨪ ࠭

     ।   ࠭   ⮨       ⠭ ࠪ⨪
 ࠭.  ࠪ⨪ 뢠 ᫥騥   
࠭:
     *  ଠ,   ࠭
     *  ࠭ 뤠     ᥡ

   ⮬  ࠧ  ।⠢  ࠪ⨪  ࠭   䠢⭮
浪.   ,       ࠪ⨪ ࠭    筮
ᮮ⢥  ⮢  ଥ । ࠭     ७
⠡  । ࠭. ਬ,   ࠭  ଥ
। ࠭  -   ,   । ࠪ⨪ 
 ࠭.

    ᢠ  ࠪ⨪  ࠭  १  ࠧ 
䥩  ࠧ묨 ﬨ:

 䥩  ᢠ ࠪ⨪ 

஢筠 ࠬ   ॢ ࠪ⨪  祭  몫祭
                ⨯  祭

       ࠧ  ᢠ,  ⠪      
        ࠧ   뢠    ࠪ⨪.   ਬ,
ࠪ⨪,  ᢠ ।⢮ ஢筮 ࠬ  ᠭ
  ⠭  砭 (     "祭" 
"몫祭").     ୠ⨢,     ࠪ⨪, ᢠ ,
  易⥫쭮/易⥫쭮 ᠭ,  뢠饥   
⠢   ⮣    । ꥪ .

⢥ :  䥩 5-1

           ࠭

ࠪ⨪  ࠭ "࠭" ।     ࠭
  ࠭.  ᫨    ᢮  ࠭ ࠪ⨪  ࠭,  
SQL*Forms  ᤥ  ᫥騥 ⢨   ࠭.

                                   -- 102 --



     *   SQL*Forms      ࠭   ᨬ       ।
   ࠧ஬ ࠭.  ᫥⢨ ⮣    ࠭    ३  
   ⥫쭮   ࠭   ࠭⢮.    १  ,
      祬  ࠭,    뫠  ,  ᫨      
   ⠭ ࠭ ࠪ⨪.

     *  SQL*Forms  ᯮ 㠫쭮 ᮤঠ    ᨬ 
    ࠢ  ࠭. ᫥⢨ ⮣ न   ⠡ - 
   ।   砫쭮  ᯮ    ࠭    孥   㣫
     ⮩ ࠭ -    ,       ३ १ ࠭.

:  SQL*Forms    ࠭  ࠪ⨪, ᫨
           ࠪ⨪  ࠭  Pop  Up     祭    ࠭.

易⥫/易⥫: 易⥫
⠭  砭: 몫祭

         ਧ⠫쭠 ஫ 

ਧ⠫쭠 ஫  -  ࠪ⨪ ࠭, ।
㤥     ࠭  ਧ⠫ ஫  .

᫨  ᢮ ࠪ ਧ⠫쭮 ஫   ࠭,
 SQL*Forms  ᨬ ஫   । ࠧ஬
࠭.  ᫥⢨ ⮣    ࠭      ३    ⥫쭮
࠭ ࠭⢮.   १  ,   祬 
࠭,     뫠  ,  ᫨        ⠭ ࠪ⨪
ਧ⠫쭮 ஫ .

: SQL*Forms  ࠪ⨪ ਧ⠫쭮 ஫
,   ᫨ ࠪ⨪ ࠭ Pop Up  ࠭  祭 
࠭.

易⥫/易⥫: 易⥫
⠭  砭: 몫祭

          ࠭

ࠪ⨪  ࠭ । ,   ᯮ SQL*Forms
 । ࠭.
易⥫/易⥫: 易⥫

            ࠭         (Pg SZ)

ࠪ⨪  ࠭ ⮨      ᫥ ⠭:
     X । ਭ ࠭  ᨬ.
     Y ।  ࠭  ᨬ.

     ࠫ,  SQL*Forms ᥣ ᯮ 孨   㣮
࠭      孥      㣫   ࠭ (ᯮ 1,1).

:   SQL*Forms      ।   ࠪ⨪
   ࠭,   ᫨   ࠪ⨪ ࠭ Pop Up  祭 
࠭.  , SQL*Forms  ᯮ 祭  㬮砭    
࠭,    ࠪ⨪ Pop Up 몫祭.

࠭祭:   ࠭           ᨬ ⮩   
ᨬ  ਭ    ᨬ  255  ᨬ ਭ  255 ᨬ ⮩.

                                   -- 103 --



易⥫/易⥫: ࠪ⨪  ࠭ 
                             易⥫쭮 ᫨ ࠪ⨪ Pop Up 祭.

祭    砭:  ⠭ X   Y  㬮砭  ਭ   
࠭,   ।   । ନ,    ᯮ짮
 ᮧ .   ⠭    㬮砭   뢠   
䥩 (ࠧࠡ稪) SQL*Forms.


         Pop Up

ࠪ⨪   Pop  Up  ।  㤥       ࠭
ந  pop-up (⠫   ⥪).    ࠪ⨪
祭,   ᫥騥 ࠪ⨪ ࠭ ⠭ ⨢묨:
     * ࠭
     * ਧ⠫쭠 ஫ 
     *   室
     * ⨪쭠 ஫ 
     * Loc 
     * ࠭ 
     *  
祭  ࠪ⨪  Pop  Up   ⠪       ।
祭    ࠪ⨪   ࠭, ⫨筮  祭 
㬮砭.

易⥫/易⥫: 易⥫
⠭  砭: 몫祭
⢥ : ꥪ Pop-up, ࠭ 13-5


           室

ࠪ⨪ ࠭   室 । 㤥   祧
 ࠭ ᫥ ⮣,     ࠭.

,  ࠭  ࠪ⨪   室  
,     ⥪饩 ࠭楩 १  楤
SHOW_PAGE. ࠭ 祧 ⮣,   ࠭ 뫠 ⥪饩  
 ࠭.

: SQL*Forms  ࠪ⨪     室,  ᫨
          ࠪ⨪ ࠭ Pop Up  祭  ࠭.

易⥫/易⥫: 易⥫
⠭  砭: 몫祭
⢥ : SHOW_PAGE, ⭠ 楤

         

ࠪ⨪  ࠭    ।   , 
  業  設  ࠭ pop-up.

࠭祭:  騥  ࠭祭  ,    ᢠ
              ࠪ⨪ ࠭ :
     *   । ,          255
       ᨬ  .
     * SQL*Forms  ࠪ⨪ ,  ᫨   ࠪ⨪


                                   -- 104 --



       ࠭ Pop Up  ࠭    祭    ࠭.
易⥫/易⥫: 易⥫
祭  砭: NULL

           ⨪쭠 ஫ 

⨪쭠 ஫  -  ࠪ⨪ ࠭, ।
㤥    ࠭  ⨪ ஫    
ࠢ ࠭ .  (ࠢ    ᫥   ஫  
  ன⢠,  ஬  ᪠ ).

᫨    ᢮  ࠭  ࠪ⨪   ⨪쭮 ஫
,      SQL*Forms   ᤥ  ᫥騥 ᮮ⢥⢨   ࠭:

     * SQL*Forms  ᨬ ஫      ।
   ࠧ஬ ࠭.  ᫥⢨ ⮣    ࠭    ३  
   ⥫쭮   ࠭   ࠭⢮.    १  ,
      祬  ࠭,    뫠  ,  ᫨      
   ⠭  ࠪ⨪  ⨪쭮 ஫   .

     * SQL*Forms ᯮ 㠫쭮 ᮤঠ          ᨬ
   ࠢ  ࠭.  ᫥⢨ ⮣ न   ⠡ - 
   । 砫쭮 ᯮ    ࠭    孥 㣫 
    ⮩ ࠭ -    ,       ३ १ ࠭.

:  SQL*Forms   ࠪ⨪ ⨪쭮 ஫
           ,  ᫨ ࠪ⨪ ࠭ Pop Up  
࠭  祭  ࠭.
易⥫/易⥫: 易⥫
⠭  砭: 몫祭


         Loc          (Vw Lc)

ࠪ⨪  ࠭  Loc  ⮨   ⠭ (X  Y),  
। 砫쭮 ᯮ ࠭   孥 㣫  ࠭.
 ,  ।   ࠭  㢨  ࠭.

  ⠭          믮 ⭮
楤ன ANCHOR_VIEW.

: SQL*Forms   ࠪ⨪    Loc  , ᫨
          ࠪ⨪ Pop Up  祭  ࠭.

࠭祭:   ᯮ  ࠭ ⠪,  ⮡   襫 
             ࠭.
易⥫/易⥫: ࠪ⨪ Loc  ॡ, ᫨
                             ࠪ⨪ Pop Up 祭  ࠭.
祭  砭: 1(X), 1(Y)
⢥ : ANCHOR_VIEW, ⭠ 楤 16-5


           ࠭ 

ࠪ⨪  ࠭  ࠭      ⮨    ⠭ (X 
Y),  । 砫쭮 ᯮ ࠭   孥  㣫
  ࠭.    ,   ।      ࠭  
㢨 ࠭ १ .

                                   -- 105 --



 ⠭           믮 ⭮
楤ன MOVE_VIEW.

:  SQL*Forms    ࠪ⨪    ࠭ , ᫨
           ࠪ⨪ Pop Up  祭  ࠭.

࠭祭:   ᯮ  ⠪, ⮡   襫 
             ᬠਢ ࠭.

易⥫/易⥫:  ࠪ⨪  ࠭   ॡ, ᫨
                              ࠪ⨪ Pop Up 祭  ࠭.

祭  砭: 1(X), 1(Y) ⢥ : MOVE_VIEW, ⭠
楤

                   (Vw Sz)

ࠪ⨪ ࠭   ⮨     ᫥ ⠭:

X । 砫 ਭ   ࠭
Y । 砫    ࠭

 ⠭           믮 ⭮
楤ன RESIZE_VIEW.

:  SQL*Forms  ࠪ⨪   , ᫨
           ࠪ⨪ Pop Up  祭  ࠭.

࠭祭:   । ࠭   ⨪
              ,  ᫥騥 ࠭祭:
     *  ਭ    ࠭    ,
        祬 ਭ   ࠭.
     *  ࠭     1 ᨬ ਭ 
       1  ᨬ .
     *  ࠭   ⠪ ࠧ,  ⮡     襫 
       ࠭ ନ.

易⥫/易⥫: ࠪ⨪      ॡ, ᫨
                             ࠪ⨪ Pop Up 祭  ࠭.

祭  砭: X  Y ⠭  㬮砭  ਭ  
                       ࠭.
⢥ : RESIZE_VIEW, ⭠ 楤 16-25

                    11          

 ⮩   뢠 ନ஢ ꥪ SQL*Forms.   , 
뢠 ᫥騥 ⥬:
      * । 
      * ࠪ⨪ 
      * ⨯ 
      * 騥 裡
 ⢥ :  ,   㬮砭 2-4

     । 




                                   -- 106 --



   ।    䥩  (ࠧࠡ稪)  SQL*Forms १   
।   ,   ⠡  ७ । ,   
 砭.

        ଠ थ 

ଠ  ।    -            䥩 (ࠧࠡ稪)
SQL*Forms,    ᮧ,    㤠 .    ଠ
    ᬮ   ଠ  ⤥쭮    ࠧ.

:  ᯮ  ⠡ ७ ।  ᫨  
ᬮ  ଠ    祬        ࠧ.   
६,  ᯮ  ।   砭  ᮧ 
   ⥬   ᯮ      ।      ⠡
७ ।    䨪樨.

㭮 11-1 뢠  ।      묨  ਬ.

   Action  foRm  Block  Field  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
                                          Lines per: 1    [   ] Column Sec
  
   Description: ITEMS
  
   ------------------------- Default Where/Order By ------------------------
   ORDER BY ITEM
  
  
   --------------------------------- Comment -------------------------------
   This block records the item that are accothiated with a single order.
  
 Enter the name of the block.
 Frm: ORDER_ENTR  Blk: ITEMS       Fld: PRODID      Trg:               <Rep>


  ⮭宦:    ⨦  ।     
                    , 믮 ᫥騥 蠣:
1. ,    ⥪ . (     ⥪
       ⥪  ,          室.)
2. 롥  .
3. 롥  䨪樨   .
4. ᫨    ⠡  ७  ।   , 
   [  뤠].

  ⠪ ᬮ  ।  :
 * [Zoon In]   । 
 * [Zoon Out]   । 
 * [Navigate]     ७ ⠡     ।
   ⥪ . (     ⠡ ७ ।
   .)

           ७ । 



                                   -- 107 --



     ७   ।      -     䥩
(ࠧࠡ稪)  SQL*Forms,        ᮧ,     㤠
.    ⠡ ७   ᬠਢ ଠ 
 祬         ࠧ.  ,        ⮩
⠡ ७ 뢠   ࠧ.

   :  ᯮ    ।  ,  ᫨   
ᬠਢ   ଠ      ࠧ.   
६,  ᯮ    ।     砭    ᮧ
      ⥬ ᯮ  ।    ⠡
७ ।    䨪樨.

㭮 11-2 뢠  ⠡ ७ ।   묨
                                       ਬ.

   Action  foRm  Block  Field  Trigger  Procedure  Image  Help  Options
    Block Definition   
 
                                       Seq  Records  Records  Records  
 Ĵ    Block Name        Base Table     Num    Disp     Buff    Lines  
  
   ORDERS            ORD               1      1                       
   ITEMS             ITEM              2      4                  1    
   CUSTOMERS         CUSTOMER          3      1                       
                                                                      
 Ĵ                                                                    
 
                                                 
 
 Enter the name of the block.
 Frm: ORDER       Blk: ITEMS       Fld: PRODID      Trg:                   <Rep

  ⮭宦:        ⨦   ⠡   ७ ।
      ,  믮  ᫥騥 蠣:
    1. ,    ⥪ . (      ⥪
           ⥪  ,         室.)
    2. 롥  .
    3. 롥  䨪樨.
    4. ᫨  ଠ । ,  [  뤠].

        ଠ   砭

  ଠ         砭   -      䥩 (ࠧࠡ稪)
SQL*Forms,        ᮧ       㬮砭.  筥 , 
ଠ - ᯮᮡ 襣 㯠    㬮砭.     
ଠ   .

㭮  11-3  뢠    砭  묨  ਬ.

   Action  foRm  Block  Field  Trigger  Procedure  Image  Help  Options
    Default Block   
  
   Block Name:         ITEMS
   Base Table:         ITEM
  
   Sequence Number:   2     ( Select Columns )        [   ] Use Constraints
   Records Displayed: 4     Page Number: 1            Base Line: 9
  

                                   -- 108 --



   Master Block:      ORDERS                          [   ] Delete Details
  
   ----------------------------- Join Condition ----------------------------
   ORDERS.ORDID = ITEMS.ORDID
  
  
 Enter the name of the block.
 Frm: ORDER_ENTR  Blk: customers   Fld:             Trg:                <Rep>


  ଠ      砭  -    䥩 (ࠧࠡ稪)
SQL*Forms,     ⠭ ᭮ ⠫  ⭮襭  
.  ⮬    ⠭ ᫥騥 ࠪ⨪   ⮫쪮
     砭:
    *  ⠫
    * ꥤ ᫮
    * ᭮ 

        ⠭  ࠪ⨪    
࠭祭  ᯮ짮  ⮫쪮    ଥ     砭.

       ⠭ ᫥騥 ࠪ⨪    
 砭:
    * Column Sec
    * Cooment (਩)
    * In Menu ( )
    * Menu Description (ᠭ )
    * Array Size ( ᨢ)
    * Default Where/Order  By  (᫮/஢     砭)
    * Primary Key (ࢨ )
    * Records Buffered (ਧ )
    * Lines Per Record (ப  )

   ࠪ⨪ ᪠ 祭  㬮砭   ⠭
  㬮砭    ᮧ      १    㬮砭.

      易⥫쭮,    ᯮ짮  । 
 砭    ᮧ    ,   ᮤঠ    
⠡.  ,    ᯮ짮    ।    
砭    ७  ⠡  ।      ᬮ 
䨪樨 ଠ樨  .

⮭宦:  ⨦  ।     砭  
                  , 믮 ᫥騥 蠣:
    1. ,    ⥪ . (      ⥪
           ⥪  ,         室.)
    2. 롥  .
    3. 롥   砭   .

           砭

       砭  SQL*Forms  ᮧ  , 騥
 ᪮쪨 ,    砥 १      
砭.      砥    ଠ樨,   ᮧ  
, ନ騥 ,    ⠭  㬮砭    .  
१,      㬮砭  ᡥॣ   讥



                                   -- 109 --



⢮  ६    ।      .  ᮧ ,
   ஢  筮  ᯥ䨪樨,  
ࠧࠡ⠫.

      㬮砭  ⠪  砥     ⮬
⠭  ⠫ ⭮襭  .

        ࠪ⨪ 

    ।    ⮨  ⠭   
ࠪ⨪.  ࠪ⨪ 뢠 ᫥騥   :
     *  ଠ,   ,    ᫥    ଥ
     *       ᥡ 
     * 祭    ᭮   ⠫   ⭮襭

    ⮬ ࠧ   ।⠢   ࠪ⨪       䠢⭮
浪.  ,   ࠪ⨪  筮 ᮮ⢥ 
⮢    ଥ  । ,    ७  ⠡  ।
   ଥ   砭.  ਬ,          ଥ
।      -    ,     । ࠪ⨪
  .

  :         ࠪ⨪        ᮪ 
䥩 ࠧࠡ稪.  ⮬ ࠧ  ᮪饭     ᫥    
묨        (.., ᫥⥫  (Seq Num)).

    ᢠ  ࠪ⨪      १   ࠧ 
䥩  ࠧ묨 ᯮᮡ:
 䥩  ᢠ ࠪ⨪ 

                      [Select]  ᬮ
                        ⥫ ⮢
஢筠 ࠬ         몫 ࠪ⨪
                     祭
 ஫஢   祭

     ࠧ   ᢠ,  ⠪       ,
      ࠧ  뢠    ࠪ⨪.   ਬ,
ࠪ⨪,  ᢠ  ஢ ࠬ    ᠭ  
⠭   砭   (   㤥       "祭"  
"몫祭"). ୠ⨢,  ࠪ⨪,  ᢠ १  
 易⥫쭮/易⥫쭮 ᠭ, 뢠    
⮣   । ꥪ .
⢥ :  BLOCK_CHARACTERISTIC ⭠ 㭪 17-3
                    䥩 5-1

            ᨢ

  ⨪      ᨢ । ᨠ쭮 ⢮
ᥩ,    SQL*Forms  (Run  Form)   롨     ࠧ.

   SQL*Forms ⠥  讥 ⢮ ப   ,
 ࠧ ᨢ 1 ᯥ稢 ᠬ ஥ ६ "⨬"  ⢥.  
,  SQL*Forms  뢠   ࠭    ࠭,  祬   뫮
 ᫨  ࠧ ᨢ   祬 1,  ⠪    SQL*Forms롨ࠥ 
   ࠧ.  ⨢,  ࠧ ᨢ 10 - 롨 10 ᥩ
। ⥬,      .


                                   -- 110 --



 ⮬ 砥 襭 ६   ......................   .........

        ࠭祭: 騥 ࠭祭      
                     ࠪ⨪  :

*        ⠭  ⢥     ,   
     騬         ﭭ ⥪⮬ 짮⥫.
*       ⠭   ⠪,  ⮡     
   뢠  ࠭.
易⥫/易⥫: ࠪ⨪    易⥫쭠 ⮫쪮
                             ᮧ  १    砭.

祭    砭:  ࠪ⨪       㬮砭 - 
ࢠ  ப ᫥     ﭭ ⥪ 
࠭.

                 (Table)
  ࠪ⨪     ।  ⠡   
,    뫠 .      ⠡   
ᯨ᪠ 祭  .

易⥫/易⥫: ᫨  ᮧ  १     
砭,  ॡ  ࠪ⨪  .   砥 
 ॡ.

                 (Block)
       ࠪ⨪       । ,   
     ண  짮⥫  SQL*Forms    .  .........
H H






























                                   -- 111 --
