


         3              

        ᮧ    ⥩,  㤥 
  ᮤন ᠬ⥫.

     ,   믮 ᫥騥 :
   -  SQL*Forms
   - ᮧ    
   - ࠭,   ஢ .

   SQL*Forms
   । 砫 ࠡ 㡥,     ࠬ  
ᯮ㥬    ନ.    稨 ᪠
 ନ ( ᨬ        c>      $  ).

  ࠦ 3-1
   1. ,  SQL*Forms  ORACLE RDBMS ⠭

        SQL*Forms
           ( 2),  ⠪  稥 ਬ஢   㪮⢠.

   2.  SQLFORMS   [Return].  㢨 ࠭ ॣ樨
                                                SQL*Forms  3-1.

   㭮 3-1         ࠭ ॣ樨 SQL*Forms
 
  
                                                                              
   SQL*Forms Design: Version 3.0.14.0.2 Production on Mon Apr  8 08:53:16 1991
                                                                              
   Copyright (c) Oracle Corporation 1979, 1989.  All rights reserved.         
   Using Object*SQL Version 01.00.16.00.02 (Production)                       
   Using PL/SQL Version 01.00.30.00.01 (Production)                           
                                                                              
                      Username:                            
                      Password:                                               
                                                                              
                   Press ^K at any time to show function keys.                
                                                                              
  
  Frm:             Blk:             Fld:             Trg:                   <Re
 

   3.      Username   [Next Field]. ᫨  
       訡, ᯮ  ५ ६饭  ࠢ 
      ࠢ쭮 ᨬ, ⥬  [Delete Backward].

    ⮡ ᬮ    ६ ᢮ 蠬 祭,
     [Show Keys].  ⮡ 㤠 ᯨ᮪  [Select].  
     ࠢ筨 ࠧࠡ稪 SQL*Forms   ⪮ ࠢ筨
    ࠧࠡ稪 SQL*Forms  ஡ ᠭ  㭪樮 .

  4.   ஫   Password   [Next Field]     室
        ⥬. ᫨  訡    ஫,   ப
     ᮮ饭  ᮮ饭  訡.  㤥 室  
     ஫    [Next Field] ᭮.



                                    -- 19 --



         SQL*Forms.

 ப       ப ᮮ饭 (. . 1-3) -  ᢥ祭 ப
 ᮮ饭     ࠭,  ன 뢠  ᮮ饭.


 ப        ᫥ ப ᫥ ப ᮮ饭  ࠭. 
       ப ࠦ  ⥪饩 ,  ,   
              ,  ਣ.    ப ⠪ ࠦ ०      
               -   饭 -  ᫨ 㯭,  ⠪ 
              ᯨ᮪ 㯭 祭   .   
              室  ࠭ 㤮,   ப ﭨ ⠪      
              ⮡ࠦ  ⥪饩 ࠭  न , .

   祭 
   ਬ 3-2    ⥬ . ஥  㬭-
  SQL*Forms,  ⥬  (help) 砥  ᥡ ࠧ
    ᠬ⥫.  ࠧ  ⠫쭮 ᠭ 
ꥪ 䥩 ⠪ : ⠡ ࠬ஢, ଠ   .

   ࠦ 3-2 뢠,    ⥬    .
ࠢ help,  㢨  ନ  ࠭ ⥬ . 
⥪⭮-⢨⥫ help 㯥   窥 SQL*Forms,  ⮣
室  [Help]. 訬 筨 ଠ樨  祭 
 ࠭ "About the Help System"  ᠬ ஥ ⥬ .

   ࠦ 3-2  :
   1.    롨  Help  뢮  help

 祭  SQL*Forms.

      ࠢ   ६    롨
   ⭮ 祭 ⨥ [Select]. 㭪  ⠪   
     ᮮ⢥饩  㪢.

   2.  [Select] ⮡   ⥬   ᢥ  -
       ࠭, "About the Help System" ( 3-2).  ࠭ ᮤন 業-
       ଠ  ⥬ . । ⥬  த, ⠩ .
   3. ६ 㪠⥫   Contents   [Select].

   4. 롥 祢 ᫮ Characteristics   [Select].


   ᯮ [Next Field]  ६饭  ᢥ祭묨 ⠬
    ⥬   ᢥ祭묨 ⠬  ⥪ . 
   ஫஢ ଠ樨 ᯮ [Scroll Up]  [Scroll Down].

   5.  ࠭  Characteristics 롥 Page Definition

      3-2     ᭮ ࠭ 
Ŀ
Exit  Contents  Previous  Next  Index  History  Retrace  Bookmark           
  [About the Help System]  ĳ
Ŀ
Welcome to the SQL*Forms On-line Help System. You can ask for help at any
ôpoint and return to the place in the SQL*FormsDesign interface from where
you entered the Help system.                                             
                                                                         

                                    -- 20 --



 Help                                                                    
 Topics       The Help system contains single-page and multiple-page help
              topics.  Up and Down arrows in the scroll bar to the left  
              indicate that there are more pages of help text above and  
              below the current page.  Press [Scroll Down] to go to the  
              next page and [Scroll Up] to go to the previous page when  
              you have read more than one page of text.                  
                                                                         
 Getting                                                                 
 Help         You can enter the Help system in two ways:                 
                                                                         
              1.   Press the [Help] key at any point.                    
ô                                                                         
v                                                                        
ٳ
 
Frm:          Blk:             Fld:             Trg:                  <Rep> 


   6.   [History] ( 롥  History  ,  ) 
                     뢮  ᯨ᪠ ⥬,   ᬮ५   
                                                        (  3-3).    
                                                        ६⨢      㪠⥫

    3-3         ਨ ⥬ 
Ŀ
  Exit  Contents  Previous  Next  Index  History  Retrace  Bookmark         
  [Page Definition Form and Spread Table]  ĳ
Ŀ
  Use the Page Definition form or spĿ
Ĵ characteristics of a page in your                 History            
  size of the page, whether it is a                                    
  spread table displays details abouĴ
  the form displays all the details    About the Help System          
  [Change Display Type] to move betwĴ  Table of Contents              
                                       Characteristics                
                                       Page Definition Form and Spread
                                                                      
                                                                      
                                    Ĵ                                 
Ĵ                                                                     
v                                   ٳ
ٳ
   
Frm:             Blk:             Fld:             Trg:                <Rep>


   7.  롥  ⠡ ࠭ Contents.  History ஥  SQL*Forms
       ୥  ࠭ Contents.

   8.  ⥬  R ( 樨 Retrace)   [Retrace]  
        ।饬 ࠭. (  砥  ୥  ࠭ 
       "About the Help System")  ࠧ  Retrace  
         ⭮ 浪  ᯨ ਨ ࠭ ,  
       History    ࠭   ᯨ᪠.
   9.  C    ᭮  ⥬ .



                                    -- 21 --



   10.  멤   ⥬  ।⢮ ६饭  樨
         Exit   [Select].  ୥  SQL*Forms ।⢥ 
         ,  ண   㫨.
























































                                    -- 22 --



       

  ਬ 3-3  ᮧ    뢠  ORDER_ENTRY.

 ਬ 3-  4
 1.  蠬   ࠢ 롥  Action    SQL*Forms.

      
 2.   [Select].   Action,  ᢥ祭 樥 New.
 3.   [Select]  롮 樨 New.   ࠭  
         New Form,     3-4.

 ਬ 3-4            New Form
Ŀ
   Action  foRm  Block  Field  Trigger  Procedure  Image  Help  Options     
   [SQL*Forms]  ĳ
                                                                            
                                                                            
     Ŀ                               
                     New Form                                             
                                                                          
                                                                          
      Name:                                            
                                                                          
                                    
                                                                            
                                                                            
 Enter the name of the form that you are creating.                          
 Frm:             Blk:             Fld:             Trg:       <List><Rep>  


    -  쪠 ଠ,   業 ࠭,
६ ४뢠  ⥪饣 ࠭.       ஡
ᠭ  ࠢ筨 ࠧࠡ稪     SQL*Forms .

  4.  ORDER_ENTRY   NAME  ⮨    [Accept].
     SQL*Forms ୥   .

  5.  R     ⥬    ⨦  FORM
     DEFINITION ( ଠ । ).  襩  ORDER_ENTRY ᥣ
        TITLE .

   6.  [Next Field]  ⨦   ஫.   
ᮤন ᯨ᮪ 祭    롥  ஫,  ଠ
ᯮ   믮   SQL*Forms (RUN FORM).  ⠭
ࠪ⨪  ஫ । 訩    ஬
 SQL*Forms  樠樨 ஫.  ஫ 㬮砭
⫨砥 ᮮ⢥⢥ ⨯ ᯮ㥬 ନ,    .
 ⠫   ஫  ࠪ⨪  ஫ ᬮ
ࠢ筨 ࠧࠡ稪  SQL*Forms.

  7.  [List]  ⮡ࠦ ᯨ᪠ 祭  ⮣ .  -
     ஢ ।    ⠡  ᯮ 
     [Up]  [Down].

  8.  [Select]  롮 祭 "Field"       ஫.



                                    -- 23 --



  9.  [Next Field]    ६  ஫㥬 
      Comment .  ᯮ    ᠭ 祭 ᢮
      , ஦ ࠭ , 㭪     
       ⪨  ᥡ.

  ஫㥬  ⮨  ,       ப稢
⨪쭮  ଠ樨.  ஫㥬       ,
।஢  㤠 .       ⠪ ᯮ짮 㭪
᪠  ⠪ .

   ,   ப    ,  -
 ,  㯯  ᭮.    ࠢ筨 ࠧࠡ-
稪  SQL*Forms  ⠭ ࠪ⨪  ६饭  
ᯫ  筮 樥,  ꥤ   ਫ SQL*Forms.

  10. 

  This form is used to enter, update, and query orders from  customers

  ( ଠ ᯮ  , ४஢       
    㯠⥫.)

  11. ᯮ  RETURN  室   ப.
       ᮧ 襩 . 㭮 3-5
  뢠 祭  Form Definition .

  ਬ 3-5       ⥫쭠 ଠ  Definition Form
Ŀ
  Action  foRm  Block  Field  Trigger  Procedure  Image  Help  Options      
  [Form Definition]  ĳ
 Ŀ
  Title:                    ORDER_ENTRY                                   
  Validation Unit:          Field                                         
  Mouse Navigation Limit:                                                 
  Default Menu Application: DEFAULT                                       
  Starting Menu Name:                                                     
  Menu Security Group Name:                                               
  
  --------------------------------- Comment ----------------------------  
   Thisformisusedtoenter,update,and queryordersfromcustomers
   
   
   
   
                                                                          
 ٳ
Enter title for this form.                                                  
Frm: ORDER_ENTR  Blk:             Fld:             Trg:             <Rep>   


 12.  [Accept]     .  [Accept]
     ६ ࠭ ᢮   ࠡ祩 .   ࠭
      ﭭ ࠭  .

 
     .   ᮮ⢥  쭥襬
 ⠡  , 뢠 ⠡楩 .   (Blok)


                                    -- 24 --



।⠢    ᮮ⢥饩 ⠡ ࠬ஢  ଥ.
  ᭥    ⢨ , ਣ஢  㭪権
㬮砭   ⥬ .

     
 ࠦ 3-4  ᮧ    , 뢠 ORDERS 
  ᪮쪨 ﬨ, 뢠 ITEMS , ᯮ  
㬮砭  ஥ ⭮襭 ᭮-⠫. ᯮ짮 
 㬮砭 -  ३訩  砩訩  ᮧ ;  ࠭-
   㬮砭 ⠭ ୮.  ⭮襭 ᭮-⠫
  ᠭ ⮫쪮  ଥ  㬮砭 (Default Blok).  ⮬
   㬮砭   ᠬ⥫.

      ⮡ࠧ ⮫쪮     
६    , ࠭  ⠡ .   ᪮쪨
ﬨ  ⮡ࠧ ᪮쪮 ᥩ ६ 祭 
⠡  .


ࠦ 3-4:  1.  ⮡    (blok)   .
      .
ORDERS  ITEMS

2. 롥  㬮砭. ଠ  㬮砭 ⮡ࠧ.

   ᠬ⥫ ⠡ ࠬ஢ -   ⨯ ᯫ  㬮砭.
 ࠬ஢ -  ࠭ ᯫ,     
࠭.  ⨢ ଥ, ⠡ ࠬ஢   
祬  .   -  ਧ⠫쭠 ப  ⠡.

 ᯮ ⠡ ࠬ஢  祭 饩 ⨭  ᪮쪨
                .

   ,   ⮬,  ⮫쪮 ଠ   
ᮮ⢥ ⠡ ࠬ஢. ଠ  䥩 ࠧࠡ⪨ - 
࠭  ( ஫㥬),  ᮤন ଠ
⮫쪮     ஫쭮 , , ஫㥬 .

 (஫  -  -롮 ᯨ᮪  ண  롨ࠥ
"on"  "off" ⨥  [Select].       ஫쭮  
祭 "on") ᯮ   祭 ⪮, ⠫쭮 ⨭
   ࢮ ࠭.  襩 ନ஢  ଠ 
䥩 ࠧࠡ⪨ ᬮ ࠢ筨 ࠧࠡ稪  SQL*Forms.

 ᫨    ⨯ ᯫ  㬮砭, 롥 Options 
 . ᯮ [Next Field]  [Right]  ⨦ 樨
ᯮ짮   㬮砭   [Select].   ⢨ 
祭 ஫쭮   饭 "    " (   ",
ᯮ  ")  㤠 "    ",  ᨬ  ।饣
祭.  [Accept]     .

 ᫨    ⥪騩 ⨯ ᯫ,   㬮砭, ᯮ
 ⨯  [Change Display Type].    ଥ,[Change
Display Type] ⮡ࠧ ᮮ⢥ ⠡ ࠬ஢;   
⠡ ࠬ஢, [Change Display Type] ⮡ࠧ ᮮ⢥ .

 3.   ORDERS   Blok Name.
 4.  ᯮ [Next Field]  ६饭    Base Table.

                                    -- 25 --



 5.   [List]  ⮡ࠦ  ⠡,    
                                  ᯮ殮.
 6.     %    ᪮  ᯨ᪠   [Select], ⮡
        ⠡ ,   稭  "O".

 7.     ⠡ ORD   [Select]. "ORD"   
     Base Table.

 8.   [Accept]. SQL*Forms ୥   .

 9.  騥 蠣 1  2,㪠 . ଠ Default Blok ( 㬮砭)
      ᭮.

 10.   ITEMS   Blok Name.
 11.   [Next Field] ⮡ ।    Base Table 
       ITEMS (᫨  뫨  㢥७,  ⥫  ⠡  
      ᬮ  騥  稨,  ᯮ ᯨ᮪ 祭
      楤ன 㪠   5  7 蠣.)

 12.   [Next Field] ।    Records Displayed 
       4

 SQL*Forms ⮬᪨ ᣥ ᫥⥫쭮 ᥫ, ⠪  
 ਤ    Seguence Number.

     ᯮ짮  ⮫  ⠡ ITEMS   ⠡
 ࠭  㬮砭  ᯨ᪥ Select Columns, 易⥫쭮
  ᯨ᮪. ⮡ 筨 ⮫쪮 ।   㤥
ᯮ짮 [Select]  ⮡ࠦ ᯨ᪠ Select Columns  ᯮ짮
[Select] ᭮ ⮡  ,    .

 易⥫쭮  祭 ஫쭮  Use Constraints. ⮡
 祭 㬮砭 ஫쭮 , ⥬   ᯮ
[Select]  ४⥫.

 13.   [Next Field]  ࠧ ⮡ ३   Master Blok.
 ORDERS.    SQL*Forms     ⭮襭
᭮ ⠫.  ⢨⥫쭮 ᮧ ⠫ .
  ன  Page Number;  㦤 .

 ।०  祭  Base Line ⮬᪨   1 
ଥ  㬮砭 [Default Blok]   ORDERS  9   ITEMS.
祭  Base Line  Y- न⮩    .
 㬮砭 Base Line ,1   ࢮ ࠭.

 14. ।   ஫㥬  Join Condition. 
     ORDERS.ORDID = ITEMS.ORDID .  ᫮  SQL*Forms  ⮬ 
     ORD  ITEM ⠡ 易 饩  ORDID.

  諨 ஫   祭 㬮砭 ⮡   Join
Condition.  ⥯ ஫  Delete Details.

 㭮 3-6 뢠 ⥫  Default Blok   ITEMS.

 㭮 3-6       ⥫쭠 ଠ    Default Blok  ITEMS
Ŀ
  Action  foRm  Block  Field  Trigger  Procedure  Image  Help  Options       
   Default Block   ĳ

                                    -- 26 --



 Ŀ
  Block Name: ITEMS                                                        
  Base Table: ITEM                                                         
 ĳ
  Sequence Number:   2     ( Select Columns )        [   ] Use Constraints 
  Records Displayed: 4     Page Number: 1            Base Line:  9         
 ĳ
  Master Block: ORDERS                               [   ] Delete Details  
 ĳ
  ----------------------------- Join Condition --------------------------- 
  ORDERS.ORDID = ITEMS.ORDID 
   
   
 ٳ
                                                                             
Enter join condition WHERE clause if block has a Master Block.
Frm: CHAPTER3    Blk: ORDERS      Fld:             Trg:                <Rep> 


 15.  [Accept] ⮡ ६ ࠭  
         .

    ⥪騩 ⥪     .
(   -  ITEMS   "ORDERS"  "ITEMS").
⥪ 뢠     । ᥩ 㯭.
( SQL*Forms  祭 ஡ ଠ樨  ⥪⠬.)

         ORDERS -     ; 
  ﬨ   । ⮫쪮  ப 㤥 ⮡ࠦ.  ITEMS -
 -    ᪮쪨 ﬨ;  ।  祬   㤥
 ⮡ࠦ.  ࠭ 㤮 ⮡ࠦ ⮫쪮  ப  
 믮 ,  4 ᥩ 㤥 ⮡ࠦ   ITEMS.

  쥣    ࠦ 3-5  ᮧ ⨩  CUSTOMERS
                ᭮  ⠡ CUSTOMERS.  ६  
                       ⥬  ३  㭪   㭪 
                     SQL*Forms.

  ࠦ 3-5:

       CUSTOMERS          
  1.  ଥ Default Blok  CUSTOMERS   Blok Name.
  2. ᯮ ਥ,  稫  ࠦ 3-4  ᠭ
     ⠡ CUSTOMERS.

  3.   Page Number  2.  ⮩ 稭   
     ࠭   CUSTOMERS.

          ⠡ CUSTOMERS   
      㬮砭, ய  Select Columns.

  4.  祭 Base Line  1 ६饭  , ⨥ [Right]
      ࠧ  ⨥ Spacebar.  㤠 "7".  砫  ப 17
      ࠭  CUSTOMERS  1 ப  2 ࠭.


  5.  [Accept]      .


                                    -- 27 --



         ࠭, 믮  ஢ 

   ⥯  填    ࠭.  ଠ 㤥
   ࠭  ᪠      ⠡
ORD, ITEMS, CUSTOMERS.  㤥 ࠭ ,஢  믮 
⮡ ᬮ  ࠡ.   ࠭ ,   
  ࠡ祩 ,    ﭭ .

    ࠭ ,  ।   ᮧ ﭭ
  . ⮡ 믮   ।  
 ॢ饭  䠩,   㤥 믮 SQL*Forms. 
 뢠 樥 .

  ࠭ 
 ࠦ 3-6  ࠭ .  易⥫쭮 ࠭ 
 ࠧ   믮 .     ⮪  SQL*Forms,
ଠ ⠫  ࠡ祩    ஢  믮﫨 . 
 , ࠧࠡ稪 ਫ ࠭    ⮣ ⮡
 ࠡ  ⪠ ࣨ  㣨 । ஡.


  ࠦ 3-6:              ࠭ 

 1. 롥  Action.
 2. 롥  Save.    Save Form.

 3.  [Accept]   Return.  㢨 ᮮ饭:
    Working...

      ᮮ饭  ࠭ ࠭.    Save Form
            祧,  ଠ 㤥 ࠭  .

    믮 

  ॢ頥 ।   䠩,   
믮 SQL*Forms.   ஢   믮 
஢.  ⠪  ஢   ࠧ  
 ; -㣮 -  㤥 믮 ⥫   
⥬  .


         ࠦ 3-7
        1.     [Select] ⮡  .

  믮    ⥪饩    Name    Field

        2. 롥 Generate.   Generate Form 

3.  [Accept].    Generate Form 祧, ଠ
   ᣥ஢. (⮡   䠩   [Next Field] 
     Generate Form ,    䠩  
   [Accept].)

4. 롥  Execute   Action.     襩
   ମ    㬮砭.

5.  [Accept] ⮡ 믮  ORDER_ENTRY.  ⮡ࠧ ࢠ
   ࠭ .  㤥   ࠭    .

                                    -- 28 --



 ᫥ ।饩 楤   ६    -
   믮     樨 Generate Before Executing Formf
SQL*Forms   Options. ⥬   ஢  믮
  롥 Execute   Action  樨  믮 襩
.

஢      ਢ몫   㪮   SQL*Forms 
          ᥣ   믮 . ࠦ 3-8 ᯥ稢
               ⢨  ஢   ᮧ;
               ࠧ㬥  ᨬ ⠭   (
               ⨥ [Insert/Replace]/ ᫨ 室).

         Insert Mode SQL*Forms 蠥 ᨬ    ᫥ 
        樨 .  Replace mode, SQL*Forms १뢠 -
        騥 ᨬ   , 稭  ⥪饩 樨 .

ࠦ 3-8:   ᯮ ।   SQL*Forms(Run Forms) 
஢      믮 ⮣ .    । 
               ⪮ ࠢ筨  SQL*Forms  㪮
                    SQL*Forms.


1.  [Execute Query]. ࢠ ᭮     ORDERS 
⠫쭠  易  ᭮  襩   ITEMS
(ᬮ .3-7).  ⨬   ⭮襭 ᭮-⠫ ,
ᠭ ᫮ﬨ ᮥ   ORDERS  ITEMS( ORDID) 
  ⠫쭮  ITEMS.

         㭮 3-7
Ŀ
                                                                             
                             ========  ORDERS  ========                      
                                                                             
               ORDID  610                       ORDERDATE 07-JAN-87       
                                                                             
            COMMPLAN  A                              CUSTID 101        
                                                                             
            SHIPDATE  08-JAN-87                        TOTAL 101.4       
                                                                             
                             ========  ITEMS  ========                       
                                                                             
  ITEMID   PRODID     ACTUALPRIC   QTY          ITEMTOT                      
  1   100860   15   1     15                   
  2   100870   2.8   4     6.4                   
  3   100890   58   1     58                   
                                   
                                                                             
                                                                             
                                                                             
   
  Count: *1                                                        <Replace> 


 2.  [Next Record]  [Previous Record] ⮡ ᬮ 㣨 .
    ⨬        ORDERS (᭮), -
      ITEMS (⠫)    . 砭  ⭮襭
    ᭮-⠫,  ᮧ  ࠦ 3-4 ᠭ  裡
      ORDERS  ITEMS.

                                    -- 29 --



 3.  [Insert Record].     ;
       ORDID.

 4.  [Next Field].  㢨 ᮮ饭:
    FRM-40202: Field must be entered.  (    ) ORDID -
    易⥫쭮 , ஥       祭.

 5.  121   [Next Field] ⮡ ३   ORDERDATE.

 6.  16/04/89  16 ५ 1989    [Next    Field].
     㢨 ᮮ饭:

    FRM-50012: Date format is DD-MON-YY.

 7.  16-APR-89   [Next Field].

 8.   ⠫   ORDERS ᫥騬:
    COMMPLAN       A
    CUSTID         155
    SHIPDATE       30-APR-89
    TOTAL          35

 9.  [Next Blok] ⮡ ३   ITEMS.

   ⮣  ⠪:
 ITEMS          1
 PRODID         100860
 ACTUALPRICE    35
 QTY            1
 ITEMTOT        35

 10.  [Commit]; 㢨 ࢮ ᮮ饭:
     Working...

 ⥬ ᫥饥 ᮮ饭:
 FRM-40400: Transaction completed -- 2 records posted and committed.
            (⢨ 祭 -- 2  ⪮४஢  ᠭ).

 11.  [Clear Form/Rollback].          
     ६   ORDID(  ORDERS).

 12.  [Entry Query]   121  .

 13.  [Execute Query].  㢨        :
 ᭮    ORDERS  ⠫쭠   ITEMS. 㭮 3-7
 뢠  ᫥ 믮  ⮣ .

 㭮 3-8                 ଠ ORDER_ENTRY   ⮡ࠦ  
Ŀ
                                                                            
                             ========  ORDERS  ========                     
                                                                            
               ORDID  171                    ORDERDATE 16-APR-89      
                                                                            
            COMMPLAN                                CUSTID 155       
                                                                            
            SHIPDATE  10-APR-89                        TOTAL 15      
                                                                            

                                    -- 30 --



                             ========  ITEMS  ========                      
                                                                            
  ITEMID   PRODID     ACTUALPRIC   QTY          ITEMTOT                     
  1   100860   15   1     15                  
                                  
                                                                            
                                                                            
                                                                            
   
  Count: *1                                                      <Replace>  


   14.  [Next Blok]  ࠧ ⮡ ३  ITEMS     ᭮ ३
 CUSTOMERS. ⥫ Page         2   
ன ࠭ .

   15.   ⢥ ᯥਬ ᢮ ᮡ⢥    .

   16.    ஢ ୨   ORDERS  
       [Clear Blok]. ⨬      ⠪  頥
        ⠫ .

   17.  [Cancell]     . ᫨     ᯮ
ᮢ襭 ⢨    ,       ᮢ 㣨
 롥 "NO"    ᯮ짮 [Next Field] ⮡ ३ 
㦭 롮      [Select].

   ᫨   ⤮  砫  4, 롥 Quit     
Action    ਣ襭 樮    ⥬.






























                                    -- 31 --



                                   4
     
 -------------------  ⪮ ᮤঠ :  

 ⢨   稫   3:
 .  ⮡ࠦ  
 .     
 .    ᫥饬 㭪 
 .  롮 㭪  
 .     ᯨ᪥
 .  ࠭ ࠭  ᯨ᪥
 .  ४祭 ஫쭮  on  off
 .   ⥪   
 .  㤠 ⥪   
 .  ᮧ  㬮砭
 .  室    ⠡ ࠬ஢   襣 롮
 .  ६ ࠭ 
 .  ࠭ 
 .   
 .  믮 

   

       ORDERS, ITEMS, CUSTOMERS ᮮ⢥
  ⠡ .   ଥ   롨  
      ⠡.         ,  
     ⠡.

   ⠪  ஥ , 믮 ᫥騥 :
        - ࠢ  ITEMS
        - 襭  
        -   ORDERS
        - ஢ 

 ࠢ ITEMS 

  ITEMS ᮤন 㠫 㭪  易   ⮡-
   ORDERS. ਬ,   ORDERS   㢨  
610.  ITEMS ,㤥 뢠  㭪 (⥭ ࠪ⪨, , ,
 ..) .  ⠭ ⭮襭 ᭮-⠫ ᪠ 
 3,  ITEMS ⮬᪨ ⮡ࠧ 㭪, 易  
⬥祭   ORDERS.

 ८।   
  ࠦ 4-1  ८। 騥  ⮡ ᤥ  묨.
 ⮡    SQL*Forms, -: 㤠    
 "cut", ⥬ ⠢ "paste"   .   ࠫ ꥪ 
 ६ ࠭   "paste".   ᮧ ꥪ ⠢ 
 ⭮  ⠪  ࠧ ᫨  . 쪮 ᫥ ࠭ ꥪ
 ࠭   "paste". ᫨   ᪮쪮  ,  
     ᢮  .

  㤥  ⬥ ⨥   롮, ⠪   
  ᫥⥫쭮 ᥫ,  , ⨯   .





                                    -- 32 --



   ࠧ㬥   ᯥ譮 稫 3   ⥯ ୥
   . ᫨    ᫥ 3 ,   SQL*Forms,
 롥  Open   Action,  order_entry   Name 
  [Accept].    㧨  3 ८। ਬ
  ( 3).

 ࠦ 4-1:
    ᫨    ᫥  3, 筨  蠣 1.  ᫨   
 ,  筨  蠣 2.        ⮬ 
  [Accept] ࠭   ६  ࠡ祩 . 
 ࠧ㬥    ࠧ  ࠭   
 [Accept]  ᯮ짮 Save  ࠭     .
  ⠪    [Menu] ୥   ,   
 ࠭       ⠡ ࠬ஢.


   1. ⠭ ⥪  (ᠭ  ࠦ 3-4)  ,
      ⥬   [Accept].  ⮫쪮    ࠭
                           㤮  ⥪  ⠭.
   2.    I       ⮡   Image.

   3. 롥  Painter.    View Page.

   4.  1  祭  Page   [Accept]   ࠭
      㤮.  ࢠ ࠭  ᮧ    3.

      ᠬ  孥 㣫 ࠭.  㭪⠬  
      ࠡ⠥   ORDERS  ଥ ORDER_ENTRY.    o
    ࠭ 1   室  ࠭ 㤮, 㭪 Page 㤥 =1.

     ⠪   x,y न     ࠭
   㤮. 1,1 窠 -  ᠬ 孨  㣮 ࠭; x - ࠢ
   ਧ⠫쭮, y - ⨪쭮.

   5.     ।  ⮫쪮  ࠭    
   ࠡ   ITEMS,  [Next Blok].    ITEMS 
       뢠 ITEMS  ⥪騩 .(ᬮ . 4-1)

   㭮 4-1                 ࠭ 1     ࠭ 㤮
Ŀ
                                                                            
                           ========  ORDERS  ========                       
                                                                            
             ORDID                         ORDERDATE         
                                                                            
          COMMPLAN                                 CUSTID          
                                                                            
          SHIPDATE                          TOTAL         
                                                                            
                           ========  ITEMS  ========                        
                                                                            
ITEMID   PRODID     ACTUALPRIC   QTY          ITEMTOT                       
                            
                                                                            
                                                                            
                                                                            
                                                                            
                                                                            

                                    -- 33 --



 
Frm: ORDER_ENTR  Blk: ITEMS         Page: 1   X: 1  Y: 1  Select:  <Replace 


    ⨬  ᬮ     ORDID   ITEMS      
 ६ 믮 ணࠬ,    ࠭ 㤮   
 ⥪⮢ ⠭ ( ⪠).  ஥ । ᫮ ᭮--
 ⠫ 譥 ,  室 ࠧࠡ稪.    㦤
  ࠭     蠥 ࠭ 㤮,  㤥 ८।
   ᪠       .


  ८।   
   6. 롥 ⬥祭 .
     a.  [Next Field]    ⨣ ࢮ ஡
                ࠭  (:60,y:13).  [Select] ⮡ ⬥ 

        ᫨  ᤥ 訡   ࠭ 㤮,  [Undo].
                 [Undo] ⬥   

        [Select],[Paste],[Cut],[Copy],[Resize Field],[Draw Box/Line]. 
                ୮ ,[Undo] ⬥ ᫥⥫쭮 ࠭ ⢨.

     b.  [Resize Field] ⮡ ᤥ    1 ᨬ.
     c.  [Select] ⮡     1 ᨬ.
     d.    ᫥ ஡ ⥪饩  (:80,y:13).   
         [Cut] ⥬ [Paste] ⮡    室.       
            ⬥祭    ,  稥
        ࠡ  ﬨ  ⮡ࠦ  .

  १, ⠢  ᨠ  

   7. 롥 ப 뤥 .

     a. 롥 ⥪饥 ⬥祭  (:80,y:13)

     ⮡   ࠢ  ப    , 
      ⮡ࠦ  ( ࠭ 㤮),  ⮡ࠦ 
     (⠪  ⥪饥 ⬥祭 )  ⠢  ⮩  ᠬ
     ப  㣮   ITEMS.  砥,   
     ६ ⬥祭         ⮩  ᠬ
     ப.

    b.  [Right] ⮡ ।     뤥
        (:1,y:13).

    c.  [Select] ⮡ ⬥ 砫 롨ࠥ .
        ࠭  뤥 騬 ஬  롮 㭪 (item)
          뢠    ᤥ  롮 
       ࠭ 㤮.

    8.  ࠭     ப ⮡ ᢮
       ࠭⢮  襩 來  .

    a.  [Down] ⮡ ३  孨  㣮  
       (:1,y:14).



                                    -- 34 --



    b.  [Cut] ⮡ 㤠 .
    .  [Paste]. ப 뤥  ६   
       ப    㭪 4-2.

 㭮 4-2                  ६饭   ITEMS
Ŀ
                                                                             
                           ========  ORDERS  ========                        
                                                                             
             ORDID                         ORDERDATE          
                                                                             
          COMMPLAN                                 CUSTID           
                                                                             
          SHIPDATE                          TOTAL          
                                                                             
                           ========  ITEMS  ========                         
                                                                             
ITEMID   PRODID     ACTUALPRIC   QTY          ITEMTOT                        
                                  
                                                                             
                                                                             
                                                                             
 
Frm: ORDER_ENTR  Blk: ITEMS            Page: 1   X: 1  Y: 14 Select:   <Rep> 


    १  ⠢ ᪮쪮  ࠧ,   ⬥
   ࠭,।    , ⥬ १ ࢮ  ࠧ
   ⠢ ࠭.     ⬥ ࠭  १,  ।-
       ,  ⥬ ⠢ ࠭.    
   ᯮ ன ⮤,  砫쭮  ࠭, ⠪ 
   㠫쭮 ᪠  砫쭮   㤥.

     ⪨  
    9.    ITEMID  4 ஡  २  
         㭪 4-3(࠭ 4-6).

     a.     "i"  ITEMID (:5,y:12).
     b.  Spacebar  ⮡ 㤠 "ID".

     c.    "I"  ITEM (:1,y:13).  ID ᫨  
          訡,  ६   訡筮 ⥪ 
         ࠢ ᨬ.  ⮡ 㤠 ⥪   [Delete
        Character]  [Delete Backward].

     d.    ࢮ 樨  ITEMID(:1,y:14),  [Select]
        ⮡ ⬥ ࠭ .

     e. ६    樨    ITEMID (:4,y:14;
         ஡  ""  ITEM).

     f.  [Resize Field].  ITEMID ⥯  4 樨 .

     10. ᯮ  ६饭   [Next Field] ⮡
         ३   QTY     ⠪, ⮡  ⠫  5
         権 .



                                    -- 35 --



  㭮 4-3                   
Ŀ
                                                                           
                           ========  ORDERS  ========                      
                                                                           
             ORDID                         ORDERDATE        
                                                                           
          COMMPLAN                                 CUSTID         
                                                                           
          SHIPDATE                          TOTAL        
                                                                           
                           ========  ITEMS  ========                       
                                                                           
ITEMID   PRODID     ACTUALPRIC   QTY          ITEMTOT                      
ID                                                                         
                                
                                                                           
                                                                           
                                                                           
 
Frm: ORDER_ENTR  Blk: ITEMS            Page: 1   X: 4  Y: 14 Select: <Rep> 


                11.   ITEMTOT  8 権.

   12. । ITEMTOT  20 権 ࠢ  砫쭮 樨.

    a. 롥 ᫥   ⢨⥫쭮  ITEMTOT (:54,y:14).
    b.  ,y न ࢮ "I"  ITEMTOT,   ࠫ
        (:47,y:12).

    c. ᫥ १ , ।   न    
       20,  y ⮦ ᠬ (:67,y:12).  [Paste].(  5 ஡
        ⬥祭    ITEMTOT).   㤥 ঠ 
       業 (ACTUALPRICE*QTY) 㭪⮢  ⮩ .

      㭮 4-4 뢠    QTY  
         २ ITEMTOT.

 㭮 4-4               ८।  QTY  ITEMTOT
Ŀ
                                                                            
                           ========  ORDERS  ========                       
                                                                            
             ORDID                         ORDERDATE         
                                                                            
          COMMPLAN                                 CUSTID          
                                                                            
          SHIPDATE                          TOTAL         
                                                                            
                           ========  ITEMS  ========                        
                                                                            
ITEMID   PRODID     ACTUALPRIC   QTY                         ITEMTOT        
ID                                                                          
                                 
                                                                            
                                                                            
                                                                            

                                    -- 36 --



                                                                            
 
Frm: ORDER_ENTR  Blk: ITEMS            Page: 1   X: 67 Y: 12 Select:  <Rep> 


           ८।  

   13.  ।  ITEMTOT.

   a.     뤥  ITEMTOT;
       [Define Field].  ଠ Field Definition  ITEMTOT.

   b. ३  樨 Select Attributes   [Select].   
      "" ⮫쪮  ஫  Base Table, Echo, Input.   ᯮ
      [Next Field] ⮡ ३        [Select]
        "".  off  㣨 ਡ⮢ (  [Select]
      ""  祧).

  㭮 4-5 뢠  ࠧ  ᯨ᮪ Select Attributes.

  㭮 4-5                  ᮪ Select Attributes   ITEMTOT
Ŀ
  Action  foRm  Block  Field  Trigger  Procedure  Image  Help  Options       
   Field Definition    
 Ŀ 
  Field Name:         ITEMTOT                                              
  Sequence Number:    7    Ŀ  ( Select Attributes ) 
  Field Length:       11    [ X ] Base Table       Display Length: 8     
  Screen Position: X: 71    [   ] Primary Key      ( Editor Attributes ) 
  Format Mask:   $999999.99 [ X ] Displayed                              
  Default Value:            [   ] Required                               
  Hint: Enter value for : I [   ] Input Allowed                          
  Valid Range: Low:         [   ] Update Allowed :                       
  Enforce Key:              [   ] Update if Null                         
  List of Values: Title:    [   ] Query Allowed         Pos: X:      Y:  
 ĳ [   ] Uppercase      ĳ 
  ------------------------  [ X ] Echo Input     ----------------------- 
                            [   ] Fixed Length                           
                            [   ] Automatic Skip                         
 ĳ [   ] Automatic Hint ĳ 
  ------------------------------------------------ 
                                                                           
                                                                           
  
Canquerycriteriabeenteredintothefield? 
Frm: CHAPTER4    Blk: ITEMS       Fld: ITEMTOT     Trg:             <Rep>    


   c.  [Accept] ⮡ ਭ 祭  ᯨ᪥ Select Attributes. 
        ࠧ   ITEMTOT ᯫ ⮫쪮.

   d. ६    Field Length.  11 ⮡ ᮣᮢ
   ଠ ᪨,   ।  ᫥饬 蠣. ⮡ ᮣᮢ
      祭,  冷  ᥣ   
   ᨬ ⢠ ᨬ   ଠ ᪨. ଠ ᪨  蠣 f  10
   ᨬ ,    ITEMTOT   11 ( ).

   e.  祭   Query Length  11.

                                    -- 37 --



   f. ⮡ । ଠ ᪨    Format Mask  $999999.99.
      ᫮   ,  㤥 ⮬᪨ ⮡ࠦ
    ࠢ  ࠢ ,  砫  $  筮 窮 
      ࠢ  .

   14.  [Screen Painter] ⮡   ࠭ 㤮  
                        ⠩ ࠡ  ଥ Field Definition 믮.

  㯮冷稢  

   16. 㯮冷稢  ITEMTOT.

    a.    ITEMTOT,  [Define Field] ⮡ ⮡ࠧ 
       Field Definition.
    b.  [Next Field] ⮡ ३   Sequence Number 
         㯮冷稢  7  6.

    ITEMTOT  砫쭮 㯮冷祭 #5.     QTY, 
   㯮冷稢 㤠  ⠭ 㯮冷祭 .  
  㯮冷稢  QTY   7,   ITEMTOT  6.

  17. , २  ⥬ ०  ⠢  ACTUALPRICE PRODID
   ⠪, ⮡  룫拉  㭪 4-6.   ACTUALPRICE 㤥
   8 権 , 砫  (:50,y:14).  PRODID 㤥 6 権
  (砫  :7,y:14).

   㤥 5 ஡  ITEMTOT  ⬥祭 ,  ஡ 
  ६ ﬨ  ࠢ ஭ ࠭   ஡   ﬨ 
  ࠢ ஭.


 㭮 4-6
                ८।   ITEMS
Ŀ
                                                                            
                           ========  ORDERS  ========                       
                                                                            
             ORDID                         ORDERDATE         
                                                                            
          COMMPLAN                                 CUSTID          
                                                                            
          SHIPDATE                          TOTAL         
                                                                            
                           ========  ITEMS  ========                        
                                                                            
ITEMID   PRODID                          ACTUAL       QTY    ITEMTOT        
ID       ID                              PRICE                              
                                    
                                                                            
                                                                            
                                                                            
                                                                            
 
Frm: ORDER_ENTR  Blk: ITEMS            Page: 1   X: 12 Y: 14 Select:  <Rep> 


  18. ८।   ᮮ⢥⢥ ᫥饩 ⠡:


                                    -- 38 --



  Field        Data Type  Format Mask     Field Length
  __________________________________________________________

  PRODID       INT                        6
  ACTUALPRICE  NUMBER     $999.99         8
  QTY          NUMBER                     5

  ਬ砭:
    INT (楫) 砥 ⨯       楫.

  ᫥ ᮢ襭    PRODID  ଥ Field Definition 
  [Next Record]      [Previous Record]        Field Name   
  㤥 ACTUALPRICE. ந  ⮩ .   楤
  ⮡   Field Definition     QTY.

      -    ,  , ப ᯫ   -
  室 祭.  ᫮       ࠢ
      ப ᯫ     ࠢ  .

  19. ୨   .


   襭  

        ⥪  ᢮  ࠭ ⮡
    ᯥ 來     樨 .    ⠪ 
    ᮢ   ࠬ    뤥  ⫨   ࠧ ⮢ .

    ᫨  㤠 (ﭭ 㤠) , ⥪  ⮣ , ᮧ-
       㬮砭  訬 ﬨ, 㤠.   ࠧ,
      ᫥ 㤠  ,    ࠭ 㤮  㤠
     ⥪, ࠬ,   ⮣ ,   . 
    ⠪ ⮬ ,  ⥪ 易  ࠭楩  ⮫쪮 .

     ࠦ 4-2   ࠬ   ORDERS,  
    ,     來.

ࠦ 4-2:  ᮢ ࠬ  ⥫쭮 ⥪  ORDERS.
   1.       ࠭ 㤮  .
   2.  [Previous Blok] ,⮡   ⥪

   3. ᯮ [Up], [Down], [Left], [Right] , ⮡ ६
              樨   ࢮ "S" 
      SHIPDATE (:9,y:9).

   4.  [Select].
   5.  [Up]  [Left],      ⠭      
      7 権 ࠢ     ORDERDATE (:75,y:3;   
      쭮   ).

   6.  [Select].
   7.  [Draw Box/Line].    㢨 ࠬ   㭪 4-5,
      ᠭ  ORDERS.

   8.  [Up]  (:75,y:1).
   9.  [Left], ⮡ ६    ⭮    
      ࠬ   ⠭       "=" ᫥ ORDERS 


                                    -- 39 --



      窥   (:30,y:1)  ORDERS.
  10.  SUMMIT SPORTING GOODS     襩 .   ଠ
      ⥯  㭪 4-7. ⠢  ࠭ 㤮.


    㭮 4-7                    ORDERS
Ŀ
                             SUMMIT SPORTING GOODS                         
                           ========  ORDERS  ========                      
         
            ORDID                        ORDERDATE       
                                                                          
         COMMPLAN                                 CUSTID        
                                                                          
         SHIPDATE                         TOTAL       
         
                           ========  ITEMS  ========                       
                                                                           
   ITEM  PROD                                  ACTUAL    QTY    ITEMTOT    
   ID    ID                                    PRICE                       
                                              
                                                                           
                                                                           
                                                                           
                                                                           
 
Frm: ORDER_ENTR  Blk: ORDERS      Page: 1    X: 50   Y: 1    Select: <Rep> 


     C          ࠦ 4-3,   ८। 
     ITEMS,                  ᮧ   , ᠭ .
     㯮冷稢 

     PRODUCT
     DESCRIPTION     PRODID ,   뢠
                 ᠭ த.  ࠭ ६    
                 ஢ ᠭ த  ⥬,  뫮 㪠  ଥ
                 .  (   ⠡ ८ࠧࢠ)

     STD PRICE       PRODID ,   뢠
                 ⠭ 業. த   ஦ 
                 ᪨  த; , 䠪᪠ 業  ⫨
                  ⠭⭮. (    ⠡ ८ࠧࢠ)

       ࠦ,      ।     ⥫
     ITEMS   ⥫쭮     㭪 4-8.  ᥣ
  ᢮      ࠦ 4-1.

          , ᯮ ଠ    . ,
          Field Definition  ⠡
  ࠬ஢ (   ᯮ짮  ⢠).

      ᠬ⥫ ࠭  ࠭ (     ⮡ࠦ 
  ࠭)       ଠ樨  . 
   ᮧ ᢮ ᮡ⢥ ,    㪮  
  ⠪     PRODUCTDESCRIPTION  PRODESCRIP.



                                    -- 40 --



                              Display  Data
     Screen Name   Field Name Length   Type  Attributes
     ___________________________________________________________
     PRODUCT        PRODUCT    23      CHAR   Displayed,
     DESCRIPTION    DESCRIPTION                   Echo
     STD PRICE      STDPRICE    8      NUMBER Displayed
                                        Echo

      ᮧ ,   ⮬᪨ ⠭ ࠢ
    ப ନ, ᪫     㬮砭.

   ࠦ 4-3:     1.  [Next Blok] ⮡ ३   ITEMES 
        ࠭ 㤮.
   
                    ᮧ  ⬥  PRODUCTDESCRIPTION.


                  2.   PRODUCTDESCRIPTION.
     a.  ⠢   樨 ࠢ   PRODID (:15,y:14) 
         [Select], ⮡ ⬥ 砫 .

     b.  [Right] ⮡ ।   22 樨  न
        (:37,y:14).  ᮧ   23 樨.

     c.  [Select], ⮡ ⬥  襣 ࠭.


                  3.  [Define Field].  ଠ Field Definition.


   ।       4. ।  PRODUCTDESCRIPTION   
           ਡ.

      a.  PRODUCTDESCRIPTION   Field Name   Field Definition.
      b.   ࠦ 4-1   ITEMETOT,  ⠪ ⮡  祭
          ᯨ᪥ Select Attributes 뫨 ⪫祭 "off" (஡), ஬
         祭 Displayed  Echo Input.

      c. ୨  ࠭ 㤮.

                  5. ⬥⪠ .

    a.  [Next Field] , ⮡ ३     PRODID.
    b.  [Right] ⮡ ६    樨 ࠢ  "D"
        PRODID (:15,y:12).

    c.  PRODUCT
       ⥬  [Down]  [Left], ⮡ ६   "" 
        ࠧ  (:15,y:13).

    d.  DESCRIPTION
          6.   STDPRICE,    8 ᨬ,
   ।          ஬ 蠣 ⮣ ࠦ.  "S" 
   STDPRICE          STDPRICE  2 樨     樨 ࠢ 
                  ᫥ ᨬ   PRODUCTDESCRIPTION (:40,y:12).


                  7. ।  STDPRICE.

                                    -- 41 --



    a.  ଥ Field Definition  STDPRICE     Field Name.
    b.   Data Type । NUMBER    ᯮ짮
       ᯨ᪠ 祭.

    . ⪫  祭  ᯨ᪥ Select Attributes ஬

                Displayed  Echo Input.

    d.  Field Length  Query Length  11  ⮣ ⮡ ᮣᮢ
        ଠ⮬ ᪨,   㤥    ᫥饬 蠣.

    e.    Format Mask $999999.99

                8. ୨  ࠭ 㤮  ⬥  STDPRICE
                  㭪 4-8.

   㭮 4-8             ITEMS
Ŀ
                             SUMMIT SPORTING GOODS                           
                           ========  ORDERS  ========                        
        Ŀ  
            ORDID                        ORDERDATE        
                                                                           
         COMMPLAN                                 CUSTID         
                                                                           
         SHIPDATE                         TOTAL        
          
                           ========  ITEMS  ========                         
                                                                             
   ITEM  PROD     PRODUCT            STD         ACTUAL    QTY    ITEMTOT    
   ID    ID       DESCRIPTION        PRICE       PRICE                       
                      
                                                                             
                                                                             
                                                                             
                                                                             
                                                                             

Frm: ORDER_ENTR  Blk: ITEMS       Page: 1    X: 47   Y: 14   Select:  <Rep>   


  㯮冷稢 9.    ⭥, १  ⠢ 
               ⠪, ⮡  ࠧ⨫   
             業  ࠭.   롮஬   (
             ⬥祭 )    ⥪⮬, ⥬ ६   
             樨.  ࢮ "I"   ITEMID   樨 ࠢ
             (:4,y:12)  ⥪饣 .

      ⢨ ⠪  㯮冷   ⠪,    ਤ
 ⮣ .
  ᤥ     , ୨  ࠭ 㤮.








                                    -- 42 --





                           ORDERS

   ORDERS ᮤন ᭮ ଠ  .  ⮬ ࠦ 
  ।    ⮣ .

  ᮢ    ࠦ 4-4    ।  CUSTNAME,
  ।  ⠡ ८ࠧ   ORDERS.  ⠡
     ८ࠧ 뢠   ⠡,  
                  ,  ஬  . 
                6   ࣣ,  ⮬᪨ ⮡ࠧ
                㯠⥫, -    CUSTID.  ଥ
                 ᮡ⢥筮 த殬  
               ।⠢⥫, 뢠    㯠⥫. 
               㯠⥫ ⮬᪨ ⮡ࠦ   CUSTNAME,
               ஥ ࠭   ६    ஢ 
               ᮮ⢥⢨  㯠⥫. ᫨ ।⠢⥫ த殢
               ᤥ 訡   㯠⥫,   㯠⥫  ଥ
                      ᮢ.

  ࠦ 4-4:     ࠦ 4-4 ࠧ㬥,   ⥯  
ᮢ        १  ⠢  믮 㣨   ࠭
।       㤮,   ६  ࠭ 㤮
        䥩ᮬ SQL*Forms(Design).
 ORDERS

 1.  [Previous Blok]     ORDERS.
 2.  [Next Field]    ⨣  CUSTID.

 3. ।  CUSTID ⠪, ⮡ ᢮ ࠭⢮  
    .   ""  CUSTID   樨  ࢮ  (=)
     ORDERS   8 権 ࠢ   COMMPLAN (:28,y:6).

 4.    CUSTNAME, ᯮ 孨  ࠦ 4-3. 
    ""   樨  ࢮ "R"   ORDERDATE (:51,y:6).
       14 権.

 5. ।  Field Name.
   a.  CUSTNAME   Field Name.
   b.  5   Sequence Number.  室   祭
        ⮬     饥  稨 ᫮ 浪 ஥
        SQL*Forms ⮬᪨ 砥 ,  ᮧ .

   c.     㬮砭 CHAR ( CHARACTER).

   d.   Displayed c Echo.

 6.  [Change Display Type] ⮡ ३  ⠡ ࠬ஢ Field
    Definition ⠡ ᮤন ଠ  ᥬ ਡ⠬   
    . ,   ⠡ ࠬ஢   ८ࠧ  
    Field Definition  ⥪饩  ⨥ [Change Display Type]. 
     ଥ, [Change Display Type] ୥  ⭮  ⠡
    ࠬ஢.஢ ᫠ 浪   㭪⮢  ORDERS, 㡥
     ⮬  ᫠ 㢥稢 ᫥  ࠢ   ( : ORDID=1,
    ORDERDATE=2, COMMPLAN=3  . .).  㬮砭    ஬ 
    ᫠ 浪.


                                    -- 43 --



 ⮡  ᫮ 浪 ᯮ [Next Record]  ஫஢
 Seq,    ⨣ ࠢ쭮 祭.   ࠢ쭮
祭.

 7. ୨  ࠭ 㤮,⮡ ᬮ   ORDERS 
      㭪 4-9.

  㭮 4-9            ORDERS  ࠭ 㤮
Ŀ
                             SUMMIT SPORTING GOODS                          
                           ========  ORDERS  ========                       
        Ŀ 
            ORDID                        ORDERDATE       
                                                                          
         COMMPLAN       CUSTID         CUSTNAME    
                                                                          
         SHIPDATE                         TOTAL       
         
                           ========  ITEMS  ========                        
                                                                            
   ITEM  PROD     PRODUCT            STD            ACTUAL  QTY  ITEMTOT    
   ID    ID       DESCRIPTION        PRICE          PRICE                   
                     
                                                                            
                                                                            
                                                                            
                                                                            
 
Frm: ORDER_ENTR  Blk: ORDERS      Page: 1    X: 1    Y: 1    Select:  <Rep> 


  8. ୨   .

  ஢ 

   ஢   ࠦ 4-5 ⮨    
                                  窨 ७ .

  ࠦ 4-5:       ஢            
  1. ࠭  ᣥ       ࠦ 3-8. ᫨
      ᤥ "Yes"  樨 Generate Before Executing Form  
     Options, ३  蠣 2.

  ,   易⥫쭮 ࠭    ࠧ   -
  믮 .   ࠡ⠥, ଠ ⠥  SQL*Forms.  
   ᥣ   ࠭  ᫥ 砭 
蠣,   筮  .

  2. 믮 . ᬮ  ࠭ ⥫쭮  
     㭪 4-10.

  㭮 4-10:         ORDERS  SQL*Forms (RunForm)
Ŀ
                           SUMMIT SPORTING GOODS                            
                         ========  ORDERS  ========                         
      Ŀ   
          ORDID                        ORDERDATE         
                                                                          

                                    -- 44 --



       COMMPLAN       CUSTID         CUSTNAME      
                                                                          
       SHIPDATE                         TOTAL         
         
                         ========  ITEMS  ========                          
                                                                            
 ITEM  PROD     PRODUCT            STD            ACTUAL    QTY    ITEMTOT  
 ID    ID       DESCRIPTION        PRICE          PRICE                     
                     
                     
                     
                                                                            
                                                                            
                                                                            
 
  Count: *0                                                           <Rep> 


  3.  [Execute Query], ⮡      ORDERS 
                           ITEMS.

   ⠡,   ᮧ   3, ⮡ࠦ . 
 CUSTNAME   ORDERS   ⮣.      
⮣    ⮡ࠧ  .


  4.  [Next Blok], ⮡ ३   ITEMS.  ⨬, :
      .    ORDERS , ᮧ   ⮡ࠦ 
      .  祭 ACTUAL PRICE  QTY ࠢ  ࠢ   ⮡ࠦ
           $.

 5. ⠩ ᯮ  [Left]  [Right], ஫஢  
    PRODID,ACTUAL PRICE,  QTY.

 6.  [Cancel]     .
    ᫨     । 砫  5,  [Cancel] 
      ਣ襭 樮 ⥬.

 ⪮ ᮤঠ :  

 騩 ᯨ᮪ 㬬 ⢨,   稫   4:
    .   ࠭ 㤮
    .      ᯮ ࠭ 㤮
    .  ᮢ  । 
    .  롮 
    .  롮 אַ㣮쭨 (   )
    .  ⬥ । [Select], [Cut], [Paste],
       [Resize Field]  [Draw Box/Line]
    .  ८। 
    .  १  ⠢  (६饭  ஢ )
    .   ᫠ 浪 
    .   ⨯  
    .    
    .  ᮢ ࠬ
    .  ᮢ ਧ⠫  ⨪ 




                                    -- 45 --
