


          12

     । 

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

         ଠ थ 

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

:  ᯮ  ⠡  ७ ।  ᫨  
ᬮ ଠ  祬      ࠧ.

㭮 12-1 뢠  ।      묨  ਬ.

            12-1         ଠ । 

   Action  foRm  Block  Field  Trigger  Procedure  Image  Help  Options
    Field Definition   
  
   Field Name:         ORDID
   Sequence Number:    1    Data Type:    NUMBER      ( Select Attributes )
   Field Length:       6    Query Length: 6           Display Length: 6
   Screen Position: X: 28   Y: 4    Page: 1           ( Editor Attributes )
   Format Mask:
   Default Value:
   Hint: Enter value for : ORDID
   Valid Range: Low:                            High:
   Enforce Key:
   List of Values: Title:                                  Pos: X:      Y:
  
   ------------------------ 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>


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

    ⠪ ᬮ  ।  :
     * [Zoon In]   । 
     * [Zoon Out]   । ਣ (   ⥪ 


                                   -- 112 --



     * [Navigate]     ७ ⠡       ।
       ⥪   .  (     ⠡ ७
       । .)


            ७  । 

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

: ᯮ  । , ᫨   ᬠਢ 
          ଠ      ࠧ.

㭮 12-2 뢠  ⠡ ७ ।   묨
 ਬ.

            12-2          ७ । 

   Action  foRm  Block  Field  Trigger  Procedure  Image  Help  Options
    Field Definition   
 
                     Seq     Data       Select    Fld  Qry  Dis      
 Ĵ    Field Name     Num     Type     Attributes  Len  Len  Len   X  
  
   ORDID             1    NUMBER         ( * )    6    6    6    1   
   ITEMID            2    NUMBER         ( * )    6    6    6    10  
   PRODID            3    NUMBER         ( * )    8    8    8    19  
   ACTUALPRICE       4    NUMBER         ( * )    10   10   10   30  
   QTY               5    NUMBER         ( * )    10   10   10   43  
   ITEMTOT           6    NUMBER         ( * )    10   10   10   56  
                                                                     
 Ĵ                                                                   
 
                                                                           
 
 Enter the field name.
 Frm: ORDER_ENTR  Blk: ORDERS      Fld: ORDID       Trg:                   <Rep


  ⮭宦:    ⨦   ⠡   ७ ।
                           ,  믮  ᫥騥 蠣:

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

     ࠪ⨪ 
    ।    ⮨  ⠭   
ࠪ⨪.   ࠪ⨪ 뢠 ᫥騥   :
     *  ଠ,   ,    ᫥  
     *     ⢮      
     * ⨯ ,           ଠ  ஬
          

                                   -- 113 --



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

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

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

 䥩      ᢠ ࠪ⨪ 

஢筠 ࠬ         몫 ࠪ⨪
                     祭
 ஫஢   祭

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

⢥ : FIELD_CHARACTERISTIC ⭠ 㭪 17-6
                   䥩 5-1


           ⮬᪠ ᪠

  ࠪ⨪  ⮬᪠ ᪠ 뢠,  SQL*Forms
뤠 ᮮ饭   ,   ᪠, 直 ࠧ,  
  (।,   । ⥪ ᪠  ).

 㦥 ० ,  SQL*Forms ᥣ  ,   ᫨  
ࠪ⨪ 뫠 몫祭.

⠭  砭: 몫祭
砭:    䥩  ࠧࠡ稪,  ஢筠  ࠬ ⮬᪮
            ᪠  樨஢    襩  롮 ਡ⮢.
⢥ : ࠪ⨪   ᪠ 12-6


           ⮬᪨ 

  ࠪ⨪          ⮬᪨    ᪠ 뢠,
 SQL*Forms ६頥      ᫥饥   ,  
᫥        .  ࠪ⨪, 
᭮, ᯮ  ᮪饭  .  ࠡ稪 
ᯮ   ࠪ⨪ ஢ , ⠪   ⮫쪮
      ᫥   ॡ㥬   ᨬ,    । 
᫥饥 㯭 .




                                   -- 114 --



    ।    ᫥饥    ।⢮ ࠪ⨪
⮬᪮   ᤢ,    SQL*Forms    ⨢ ਣ Key-NXTFLD
(-).     ⬥砥    䠪,     
   [饥 ].

⠭  砭: 몫祭
࠭祭:   ࠪ⨪  ⮬᪮     
             ࠪ⨪  뢠    襭 .
砭:    䥩  ࠧࠡ稪,  ஢筠  ࠬ
⮬᪮     樨஢    襩  롮 ਡ⮢.

            

  ࠪ⨪    뢠,     
ᮮ⢥ ⮫   ⠡ ,   ᮤন  .
⠭  砭: 祭
砭:    䥩  ࠧࠡ稪,  ஢筠  ࠬ  
            樨஢  襩 롮 ਡ⮢.

           ਩

  ࠪ⨪        ਩   ।   ᭮ ଠ 
.  ਩ -    ।⢮ ᠭ 楫      ࠪ⨪
.     ᮡ   ᯮ 㣨  ࠧࠡ稪,  
ᯮ   ꥪ   ਫ    ⫠  প 
ਫ.
易⥫/易⥫:   易⥫

            祭

  ࠪ⨪   祭 ।  ⨯ 祭 SQL*Forms
      SQL*Forms 뢠  祭  ࠭.

砭:   ⨯ ,  SQL*Forms  㤠   ࠧ⥫
ᨬ   祭.   ࠧ, ᫨     
ᨬ  ᫥   祭   , SQL*Forms  㤠    ᨬ    ਥ
祭.  ᫨     祭  ᨬ       ஡,
SQL*Forms  㤠  ஡     祭   NULL ().

易⥫/易⥫:   易⥫
祭  砭:  祭  㬮砭    ⮣,  
                        ᮧ .

     *  ᫨    ᮧ      㤮 ࠭,
        祭  㬮砭 㤥 CHAR.
     * ᫨  ᮧ   १        㬮砭,
        ⨯ 祭  㬮砭     ⨯ ,     ᮮ⢥-
       騩 ⮫   .   ࠧ 祭   㬮砭
           CHAR, DATE, LONG,  NUMBER.

騥 ࠭ 뢠  ⨯ .
⢥ :  , 塞 祭 12-25

         ALFA

ALFA,   䠢,   ᮤঠ   㪢 (孥
  ॣ஢).


                                   -- 115 --



         CHAR

CHAR,  ᨬ,    ᮤঠ   ᫥
ᨬ:
     * 㪢 (孥   ॣ஢)
     * ᫠
     * ஡
     * ᯥ樠 ᨬ ($, #, @,  _)

         DATE

 DATE  ᮤঠ ,   ⭮  ⮫ DATE  
      SQL*Forms  ࠡ뢠   ࠢ  (
ᨬ쭠 ப).  ଠ  㬮砭 - DD-MON-YY.  騥 ਬ
।⠢  祭   DATE:
23-OCT-82
01-JUN-87

  뤠  DATE   㣮 ࠢ쭮 ଠ ⥬ 
ଠ ᪨ .
⢥ : ࠪ⨪  ଠ ᪨ 12-15

         DATETIME

  DATETIME    ᮤঠ  ,   ⭮  ⮫ DATE 
    SQL*Forms  ࠡ뢠   ࠢ    (
ᨬ쭠  ப).  ଠ   㬮砭  -   DD-MON-YY   HH:MI[:SS].
騥   ਬ ।⠢ 祭  DATETIME:
18-OCT-88 10:02
31-DEC-88 23:59:59

           EDATE

EDATE,    ய᪠  ,     ᮤঠ ,  ⭮
 ⮫ NUMBER   .  ଠ  㬮砭   -   DD/MM/YY.
騥  ਬ  ।⠢ 祭  EDATE:
23/10/82
01/06/87

砭:      EDATE      SQL*Forms   ᪨
ᮮࠦ.  Oracle Corporation ४, ⮡   ᯮ짮  ⨯
  DATE    ࠪ⨪ ଠ  ᪨    祭  ய᪮
ଠ .  ᯮ짮 ᪨ ଠ   樨   
।⠢  ⮫  DATE        ᨬ   ⮫ NUMBER.

⢥ : ࠪ⨪  ଠ ᪨ 12-15

         INT

INT,   楫,    ᮤঠ    楫  (.., ᫮ 
筮 窨,    ).

         JDATE

JDATE,    ᪠  ,      ᮤঠ  ,  ⭮
 ⮫ NUMBER   .  ଠ  㬮砭   -   MM/DD/YY.



                                   -- 116 --



騥  ਬ  ।⠢ 祭  JDATE:
10/23/82
06/01/87

砭:      JDATE      SQL*Forms   ᪨
ᮮࠦ.  Oracle Corporation ४, ⮡   ᯮ짮  ⨯
  DATE    ࠪ⨪ ଠ  ᪨    祭  ᪮
ଠ  .  ᯮ짮 ᪨ ଠ   樨   
।⠢  ⮫  DATE        ᨬ   ⮫ NUMBER.

         LONG

 LONG  ᮤঠ   ᨬ,     65,536
ᨬ.         LONG   ORACLE-  ப
६ .

砭:   ४⭮    訢    LONG.    ࠧ,
           LONG  ஢ WHERE  ORDER BY 
    SELECT.   ।饭 ⠪ ,  䥩
(ࠡ稪) SQL*Forms ।頥  ⠭  ࠪ⨪  
襭      ⨯ LONG.

           MONEY

  MONEY    ᮤঠ  ᫮,        筮 窮
 , ஥ ।⠢ 㬬 .  騥 ਬ ।⠢
祭  MONEY:
10.95
0.99
10000.00
-15.47
砭:       ᯮ짮   ଠ   ᪨    ଠ஢
            祭  MONEY    (.., $).

         NUMBER

 NUMBER  ᮤঠ  ᫮,     ,   ⠪  
筮  窮    ,   ॣ୮  筮 樨.   NUMBER
⭮  ⮫栬 NUMBER         SQL*Forms  ࠡ뢠  
祭   ࠢ ᫠ ( ᨬ ப).  騥  ਬ
।⠢ 祭  NUMBER:
10963
-15
0.01
1018.996
1.85E3

SQL*Forms              ᫠ (..,  99,999).
,     뤠    ᫠   묨, ᯮ ଠ ᪨.
⢥ : ࠪ⨪  ଠ ᪨ 12-15

         RINT

RINT,   ࠢ 楫,   ⥦ ࠪ⨪,    INT,  
᪫祭 ⮣,      RINT  뤠 ࠢ묨 ࠢ ( ⫨稥 
ࠢ).



                                   -- 117 --



砭:   RINT ন  SQL*Forms ⮫쪮  ᮢ⨬
 ।騬 ﬨ. Oracle Corporation ४,  ⮡  
ᯮ짮  ⨯    NUMBER  ᮮ⢥騩 ଠ ᪨ (.., 999).

         RMONEY

RMONEY,  ࠢ-,    ⥦ ࠪ⨪,    
MONEY,   ᪫祭 ⮣,   祭  RMONEY  뤠
ࠢ묨   ࠢ   (   ⫨稥    ࠢ ).  騥
ਬ ।⠢ 祭  RMONEY:
   10.95
    0.99
10000.00
  -15.47
  砭:     RMONEY  ন    SQL*Forms ⮫쪮  
ᮢ⨬    ।騬 ﬨ.  Oracle Corporation ४,
⮡  ᯮ짮  ⨯   NUMBER  ᮮ⢥騩 ଠ ᪨
(.., 9999.99).

         RNUMBER

RNUMBER,   ࠢ-᫥,    ⥦ ࠪ⨪,   
NUMBER,  ᪫祭 ⮣,   祭    RNUMBER 뤠
ࠢ묨  ࠢ  ( ⫨稥      ࠢ   ).  騥
ਬ ।⠢ 祭  RNUMBER:
   10963
     -15
    0.01
1018.996
  1.85E3
砭:      RNUMBER  ন  SQL*Forms ⮫쪮 
ᮢ⨬    ।騬  ﬨ.  Oracle Corporation  ४,
⮡   ᯮ짮 ⨯  NUMBER  ᮮ⢥騩 ଠ ᪨ (..,
999.999).

         TIME

  TIME    ᮤঠ  ᫠  (  ⮫),    ⭮  
⮫栬  NUMBER     ,  ⮫쪮   ⮫栬 DATE.  ଠ 
㬮砭 - HH:MI[:SS].  騥 ਬ ।⠢ 祭  TIME:
10:23:05
21:07:13
砭:      ।⠢  ଠ  ६   DATETIME.
⢥ :   DATETIME 12-7
                  ࠪ⨪  ଠ ᪨ 12-15
                  祭  砭

     (Default)

  ࠪ⨪    祭      砭   뢠 祭,
஥  SQL*Forms         .   
⠭ 祭  㬮砭   ᫥ ⨯ 祭:
     * 室 祭 (.., 340, 'JONES')
     * ⥬ ६ (.., $$DATE,$$TIME$$)
     * 뫪    㣮    (..,   :ORDER.ORDERID, :DEPTNO)
     * 뫪   ᫥⥫   ꥪ        
       ⮬᪮ ஢   ᫥⥫쭮 
       (.., :SEQUENCE.ORDER_NUMBER.NEXTVAL)

                                   -- 118 --



     砭:  祭 ଠ樨  ᮧ ꥪ    ᫥⥫-
           ஬  ORACLE,   ࠢ筮 㪮⢮ 몠 SQL.
     易⥫/易⥫:   易⥫

     (Dis Len)

  ࠪ⨪      뤠    祭    । ⢮
ᨬ,  SQL*Forms 뤠  .

,  ᫨  ᤥ  뤠  , 祬    ,
     ⠭  ஫㥬.   ᫨    뤠   -
१    ।    ७ ⠡ -  ,  祬
 , SQL*Forms 뤠 訡  ⪥ ᣥ஢ .

易⥫/易⥫:   易⥫
祭  砭: ᫨    ᮧ      ࠭ 㤮,  
祭   㬮砭 ࠢ  㥬  .

᫨  ᮧ  १ ⨫    㬮砭,   祭  
㬮砭      ⨯       㬮砭:
     *    ⨯  CHAR (ᨬ)  LONG,   祭 
   㬮砭 ⠪ ,   ,       60. ᫨  
   , 祬 60,  SQL*Forms   ⠭  뤠  - 60  
   ⠭   ஫㥬.
     *    ⨯  DATE, 祭  㬮砭   - 9.
     *       ⨯    NUMBER,  祭     㬮砭
          ᮮ⢥饣 ⮫    ⠡  :
     * ᫨ ᮮ⢥騩 ⮫    ⠡       
        ,  祭    㬮砭   ࠧ ,  祬 
       .   塞 ஡ ।⠢       筮
       窨  .
     * ᫨  ᮮ⢥騩  ⮫  ⠡       
         ,  祭    㬮砭 - 10.
p⢥ : ஫㥬  12-28

           뤠

  ࠪ⨪   뤠 뢠    뤠,
 ,   맮 ।⢮  SQL*Forms (Run Form).

⠭      砭:   ࠪ⨪  뤠   㬮砭
祭.  , ᫨    譨 祬    -⠫
⭮襭,   SQL*Forms  ⠭  㬮砭  몫祭.
砭:  䥩 ࠧࠡ稪, 뤠 ஢筠 ࠬ
           樨஢  襩 롮 ਡ⮢.
⢥ :   12-27

              뢮

ࠪ⨪      뢮  뢠   SQL*Forms ᥣ 뤠
祭 ⥪饣 .  ࠪ⨪  뢮, SQL*Forms ᥣ 뤠
祭  ஡.

ਬ,   ஫  ࠭ ॣ樨 SQL*Forms   몫祭
ࠪ⨪   뢮.    ࠥ ஫,  ࠥ 
ᨬ  ᢥ稢.



                                   -- 119 --



⠭  砭: 祭
࠭祭:   ࠪ⨪  뢮   
             ࠪ⨪ 뤠.
砭:    䥩 ࠧࠡ稪, ஢筠 ࠬ  뢮
             樨஢  襩 롮 ਡ⮢.

           প 譥      (Enforse Key)

  ࠪ⨪    প 譥  뢠  筨
祭,   ஥   SQL*Forms   ᯮ     .  
ࠪ⨪ ⮨   ⥩,  ⮩,  ।  
(Block)  ⮩,   ।      (Field)     SQL*Forms
⠥ 祭.

SQL*Forms ন ⭮襭 譨 祩 :
     * ᮧ  , ᮤঠ 
     * 訢 , ᮤঠ騩 
     * ⠢ , ᮤঠ 

SQL*Forms  ন ⭮襭 譨 祩  
饩 .

砭:   ࠪ⨪ প  譥     
몫祭 ࠪ⨪ 襭 뢮.    ,   ⠪ -
    ॡ,     頥     ९ন
⭮襭 譥 .
易⥫/易⥫:   ⥫쭠

             ᯮ  

  ࠪ⨪   ᯮ ⮨   ⠭, 
। ਧ⠫  (X)    ⨪  (Y) न  孥
  㣫  ।  ,    ।  SQL*Forms  (Run  Form)
뢠    ⮣ .
易⥫/易⥫:   易⥫쭠
祭  砭: 1(x), 1(Y)
砭:    䥩  ࠧࠡ稪,    ᯮ  
           (X  Y) 樨஢    襩  ਡ⮢  ।஢.
⢥ :   13-2

            

  ࠪ⨪         ।  ᨬ쭮 ⢮
ᨬ,      .

,   ᫨    ᤥ      ,  祬 뤠
,      ⠭ ஫㥬.  ᫨    뤠
    -   १   ࠭ 㤮  -  祬    ,  
SQL*Forms  祭    ᯮ 祭 뤠
.
࠭祭:   騥    ४樨        ࠭祭 , 
 ᢠ ࠪ⨪  :
     *       ࠪ⨪  ,      
        ,  祬  ᮮ⢥     ⮫   ⠡  
       ⥫쭮  ࠭⢮,   ஥ 室  ᨬ ଠ
       ᪨.      ,  ⮡  ⠫   祭,
       ஥ , 祬  ⮫.


                                   -- 120 --



     *          ⨯    NUMBER,      ॣ㫨
       ᯥ樠쭮 樥,       ᮮ⢥⢥   .
        ।     १ 祭    ਭ  ,
       襩, 祬   । 筮.  ,   ᫨ 祭
       १   ந      㣨     ଥ,
       SQL*Forms  १ 祭     .

     *      ,     ᪫祭    LONG,   ᨬ쭠
         - 255 ᨬ.

     *    ⨯   LONG,  ᨬ쭠      - 65,536
       ᨬ.

易⥫/易⥫:   易⥫쭠
  祭    砭: ᫨    ᮧ   ࠭ 㤮,  
                           祭  㬮砭 ࠢ    㥬 .
᫨    ᮧ    १  ⨫   㬮砭, 祭  
㬮砭      ⨯       㬮砭:
     *    ⨯  CHAR, 祭  㬮砭
       -  ࠢ    樨㥬 ⮫  ⠡  .
     *    ⨯  DATE, 祭  㬮砭 - 9.
     *    ⨯  LONG, 祭  㬮砭 - 255.
     *       ⨯    NUMBER,  祭     㬮砭
          ᮮ⢥饣 ⮫  ⠡  :

          * ᫨ ᮮ⢥騩 ⮫    ⠡        
             ।  ,  祭  㬮砭   ࠧ
              ⮩   .    塞  ஡  ।⠢
              筮 窨  .

          * ᫨ ᮮ⢥騩 ⮫    ⠡       
              ,  祭    㬮砭 - 10.
⢥ : ࠪ⨪  ଠ ᪨ 12-15
                  ஫㥬  12-28

        

   ࠪ⨪         ।  ,   ஥ SQL*Forms
ᯮ  䨪樨 .    ( 䨪   
)  ⠪,   ஥     ᯮ짮    饭      
ਣ       ⭮襭 প 譥 .

     *       ⠡,        筮 
       ᮮ⢥饣  ⮫    ⠡    .
     *      ⠡,          
       襬 롮,  ஥  ᮮ⢥   ᮣ襭   ꥪ⮢
        㭨쭮  .

      㬮砭  ᯮ      ⠭
⥪⮢      .    SQL*Forms ᮧ  ,    
        ࠭ 㤮  ⢨   .
,    ᫨       譥    
-⠫ ⭮襭,    SQL*Forms      ᮧ  ⠭⭮
⥪⮢ ⪨  .

  砭:  SQL*Forms    ᮧ ⮫,     ᮤঠ
  ᨬ.      SQL*Forms       ᮧ ⮫,
  ᮤঠ  ᨬ.  ࠧ,     ᮧ ,

                                   -- 121 --



஥   ⮫,   ᮤন  ᨬ. ᫨ 
  ᡠ஢   ⠪ ⮫,  ᮧ  樨஢
⠡,   㤠 ஡     ⮫.

易⥫/易⥫:   易⥫쭠
祭  砭:   ᫨    ᮧ    १  
 㬮砭,        㬮砭 㤥  ᮮ⢥饣 ⮫
 ⠡  .
⢥ :      12-26
                    襭   20-1


       ஢ 

   ࠪ⨪   ஢  뢠     
 祭  ࠧ ⠪ ,   ᮮ⢥   .
ਬ,      ᢮  ࠪ⨪  ஠  ,
஥ ᮤন   ᫮ ,  ⠪  SQL*Forms  㤥 ᪠
  ⪨ -  ᫥⥫쭮  ⨬ - 室.

 ᫨       ࠪ⨪ ஢  ⠪   
ࠪ⨪ 易⥫,   SQL*Forms  ⠥  ਭ 㫥
祭  .

 ⠭  砭: 몫祭  ࠭祭:  騥  ࠭祭
   ,    祭 ࠪ⨪ ஠
:
      *    ࠪ⨪ 뤠  襭 .
      * ᫨    ⨯  NUMBER  RNUMBER,       
        ᮤঠ 砫 㫨.  ᫨       ⠪  祭,
         SQL*Forms  ⮬᪨   㤠 砫 㫨  ⠭
        ஢      " ".

砭:   䥩  ࠧࠡ稪,  ஢筠  ࠬ  ஢
              樨஢      襩   롮  ਡ⮢.
⢥ : ࠪ⨪    12-13

       ᪠ ଠ

   ࠪ⨪      ᪠   ଠ   ।    뤠
ଠ  .   ࠪ⨪     ,  ⮡
SQL*Forms  뤠  ਭ  ᨬ  .

    ।  ଠ  ᪨    ,     
ᨬ   ࠭⢮,   ࠧࠡ뢠 蠡. 騥 ਬ
  ᮣ襭:  999"-"99"-"9999

       ᪠  ଠ  뢠  祭   ଠ ᥫ
   த  ⭮     ⮢.   ᫥  ⮣,   
          ᫮   ,   SQL*Forms  ࠢ쭮
   ଠ   祭  . ୠ⨢,  SQL*Forms ਬ 
     뤠 ᨬ ᪨, ᫨   .

MONTH" "
DDth","YYYY




                                   -- 122 --



        ᪠   ଠ  뢠  祭       ।
   蠡   (..,  JANUARY  1st,1988),  ᮮ⢥騥 ஡
    .

SQL*Forms  ᬠਢ    ᨬ  ࠧ⥫  祭
  -             -       ᬠਢ  
    ᫨ﭨ 祭 .  ,   ⠭  
  (१  ࠪ⨪    ),   ᯥ  
 ᨬ.

砭:    祭  ᯨ᪠   ᠭ ࠧ ⮢ ଠ
            ᪨,   ࠢ筮 㪮 몠 SQL.
易⥫/易⥫:   易⥫쭠
⢥ : ᪠ ଠ,  3-11

        ᪠

  ࠪ⨪      ᪠ । ᪠, 
  ப ᮮ饭 SQL*Forms (Run  Form).   ᪠ 뤠
 ᫥ ᫮:
     *  ᫨      [Help]    ⮬ 
     * ᫨ ਣ 믮  楤  HELP    
     * ᫨  ६⨫     ࠪ⨪
       ⮬᪠ ᪠ 祭

易⥫/易⥫:   易⥫
祭    砭: ᫨  ᮧ  १ ⨫  
㬮砭, SQL*Forms ᮧ ᫥騩 ⥪   㬮砭:

  Enter value for: ﯮ
                ﯮ -   ⥪饣 .

       襭 

   ࠪ⨪  襭  뢠   
६       (  ०  )    祭.


⠭    砭:  ࠪ⨪ 襭   㬮砭
祭.  ,   ᫨       譥       
-⠫   ⭮襭, SQL*Forms  ⠪ 㬮砭 
몫祭.

࠭祭:      ࠪ⨪  ࠧ襭   
                ࠪ⨪ .
砭:    䥩  ࠧࠡ稪,  ஢筠  ࠬ 襭
             樨஢      襩   롮 ਡ⮢.

       ᮪ 祭 Pos     (List)

   ࠪ⨪    ᮪  祭  Pos  ⮨   ⠭,
   ।   ਧ⠫   (X)    ⨪  (Y)  न
孥    㣫 ᯨ᪠ pop-up (ᯫ뢠) 祭  .

砭: ᫨  ᮧ ᯨ᮪ 祭  ⨫  V2,  
           SQL*Forms   ࠪ⨪.



                                   -- 123 --



易⥫쭠/易⥫쭠: 易⥫쭠
祭  砭: 1(X), 1(Y)
p⢥ :  ᮪ 祭, pop-up 13-14
                   ᮪ 祭, ⨫ V2 12-17


           ᮪ 祭   SQL

  ࠪ⨪    ᮪  祭  SQL ।  SQL,
 롨 祭  ᯨ᪠ 祭.    祭  
 ᯨ᮪ 祭   롮ન   ( ).

,         롨 祭   ᯨ᪠ 祭,
 ᯨ᮪ 室 祭     뢠   祭.

⠪,      ᯮ  ࠪ⨪  । ,
 SQL*Forms ᮧ  ᯨ᮪  祭   ᯨ᮪ 祭 V2,  
ᯨ᮪ 祭 V3.
     * ᮪  祭  V2 㭪樮 筮 ᯨ   祭 
       ।  SQL*Forms.
     * ᮪ 祭  V3  -      pop-up  (ᯫ뢠騩)   ꥪ  
       㭪樮 筮 ᯨ 祭    䥩 ࠡ稪.


        ⠪ ᪠ V2 祭  SQL

    ᮪  祭  ⥪  SQL   ᯨ᪠ 祭 V2  
⮫쪮   ⠡  ⮫殢.

ਬ,  ।⠢ ᥡ,      ᮧ  ᯨ᮪ 祭,
        롮  ᯨ᪠  IDs.  
   ᫥騩  ᮪ 祭 ⥪ SQL:

  EMP.EMPNO

  SQL*Forms   ⠢訩 ᮮ⢥騩 ⥪ SQL   ⮣,
⮡  ந   ᯨ᮪   祭,    㭪樮  筮
ᯨ 祭  ।饩 ᨨ SQL*Forms.

           ⠪ ᪠ V3    祭  SQL

  ᮪ 祭 ⥪ SQL  ᯨ᪠ 祭 V3:
     *    SELECT
     *  롮ઠ             
     *  롮ઠ   pop-up ᯨ᮪ 祭     祬 
       ⮫   祬  ⠡

ਬ,  ।⠢ ᥡ,      ᮧ  pop-up ᯨ᮪  祭,
    롮  ᯨ᪠  ࠢ IDs.
 ⠪ ,  ⮡ ᯨ᮪  祭  ন ஬  
ᯨ᪮ ᯮ ᮢ ࠢ ( ४⭠ 뫪   
⠡).         ᫥騩  ᮪ 祭 ⥪ SQL:

  SELECT EMPNO, LOC
     INTO :MGR
     FROM EMP, DEPT
     WHERE EMP.DEPTNO = DEPT.DEPTNO
          AND JOB = 'MANAGER'

                                   -- 124 --



  ⮫  ,    頥   (㧥)
SELECT,         ⠪,     INTO 롥
⥬  .  ᫨  ⠪  롨 祭 ⮫ LOC    
LOC,       㤥  ᫠    LOC ᫥  MGR 
 INTO (..,   INTO :MGR, :LOC  ).

     ਬ ,      ᫠   ⮫   
  SELECT,       ⬥祭   ᮮ⢥饬  
  INTO.    ࠡ⪠       뤠  ଠ,
     ᯮ짮 ஬,        
 .  ,        ⠭  ⠪  ⨯ 뤠,   
⬥祭 뫪  ⮫       SELECT  ⮫쪮
᫥  ⬥祭 ⮫殢 (..,  INTO   ய
 ⮫殢   SELECT    ࠧ⪥    ⮫殢    ).

騩 ਬ  㤥 ࠡ ࠢ쭮  ⮣,      ᮡ
  ࠢ,  뫠  ⮫ DEPTNO । ⮫殬 LOC:

  SELECT EMPNO, DEPTNO, LOC
     INTO :MGR, :LOC
     FROM EMP, DEPT
     WHERE EMP.DEPTNO = DEPT.DEPTNO
          AND JOB = 'MANAGER'

  易⥫쭠/易⥫쭠: 易⥫쭠
⢥ : ᮪ 祭, pop-up 13-4

           ᮪ 祭 

   ࠪ⨪    ᮪  祭   । ,
  SQL*Forms  ᯮ  ᢥ  pop-up ᯨ᪠ 祭  .

砭:  ᫨  ᮧ ᯨ᮪ 祭  ⨫ V2,  
            SQL*Forms   ࠪ⨪.

易⥫쭠/易⥫쭠: 易⥫쭠
⢥ :  ᮪ 祭, pop-up 13-4
                   ᮪ 祭, ⨫ V2 12-17


           ࢨ 

   ࠪ⨪  ࢨ  뢠,    -  
㭨쭠  ࠪ⨪         㭨쭮
ࠪ⨪    (           ࠪ⨪ ࢨ筮
). ⮡ 㤮⮢,   ⠢塞      塞   
  㡫  㦥 ,    ᪮    ()
ࢨ筮     ࠪ⨪ ࢨ筮 .

ਬ,         㢥७,     ਫ    
祬            ID .    ⮣,  ⮡
ᯥ  ,     EMPLOYEE_ID ࠪ⨪   ࢨ筮
       ࠪ⨪  ࢨ筮 .

  ,        ࢨ筮 ,  SQL*Forms
 , ⮡  祭  뫠 㡫஢.     ᫮
ࠧ襭     ⮣,    SQL*Forms   ஢        
ࢨ筮  ,    樨,  㡫㥬.

                                   -- 125 --



ࠪ⨪ ࢨ筮      SQL*Forms   ᪨
ᮮࠦ.  Oracle  Corporation ४  ᯮ짮 㭨
    ⮫    ⠡   ,  ᨬ    ᯮ짮
ࠪ⨪ ࢨ筮 , 樨஢  .  
ন 㭨쭮  ਫ,     ⮫栬
 ᯥ稢   ࠡ, 祬 ⠭ ࢨ筮 .

  ଠ樨    ᮧ     ᯮ짮   㭨 ᮢ
  ࠢ筮 㪮 몠 SQL   㪮 
  ORACLE.

⠭  砭: 몫祭
࠭祭:   ࠪ⨪ ࢨ筮   
             ⠪  ࠪ⨪  .

砭:    䥩  ࠧࠡ稪,  ஢筠  ࠬ
            ࢨ筮  樨஢  襩 롮 ਡ⮢.
⢥  :  ࢨ  ,  ࠪ⨪  


           襭 

   ࠪ⨪    襭    뢠,     
த    ( ० )   ᫮ ᥪ樨 .

⠭  砭: ࠪ⨪ 襭   㬮砭 -
祭.  , ᫨     譥   -⠫
⭮襭, SQL*Forms  ⠭  㬮砭  몫祭.

࠭祭:  騥  ࠭祭        ᢠ
ࠪ⨪ 襭 :

     *      ࠪ⨪ 襭  ⠪    
        ࠪ⨪ 뤠.
     *      ⨯      LONG            ࠪ⨪
        襭 .
砭:     䥩  ࠧࠡ稪  ஢筠  ࠬ 襭
  樨஢      襩   롮 ਡ⮢.
⢥ :   LONG 12-8

         

ࠪ⨪       । ᨬ쭮 ⢮
ᨬ,          ᫮ .

    ᤥ          ,  祬 뤠 
.  ਬ,    5      ᫮
    !=500         뤠 3.

易⥫쭠/易⥫쭠: 易⥫쭠 祭  砭: 祭
  㬮砭  ࠢ   .

࠭祭:   騥  ࠭祭       ᢠ
               ࠪ⨪  :
 *              祬     .  ᫨
    ⠥ ᢮   , SQL*Forms 뤠 訡.



                                   -- 126 --



ᨬ쭠   ࠢ 255 ᨬ.
⢥ : ஫㥬  12-28

        ॡ㥬

ࠪ⨪    ॡ㥬  뢠        NULL.
ਬ, ᫨    㢥७,         ਫ,
    뫠  ( )  ID ,     
ࠪ⨪

ॡ㥬  EMPLOYEE_ID.

,      ᢮ ࠪ⨪ ॡ㥬 ,  ᫨
    ࠪ⨪ 뤠  襭 .  ᫨ 
    ⠪   ࠪ⨪,     易
࠭஢, ⮡   뫮  (१ ਣ   
㣨 ᯮᮡ).

⠭  砭:  SQL*Forms  砥  ࠪ⨪ ॡ㥬  ᫨
 ᮧ  १    㬮砭  ᮮ⢥騥
⮫      NOT  NULL  (  ).  ,  SQL*Forms
⠭ ࠪ⨪ ॡ㥬 몫祭.

砭:    䥩  ࠧࠡ稪,  ஢筠  ࠬ
            ॡ㥬 樨஢  襩 롮 ਡ⮢.

         ࠭

 ࠪ⨪   ࠭ ⮨  ᫥  ⠭:

࠭   ।  ࠭ ,    ன    .

X         । ਧ⠫ न  ࠭     .
Y         ।  ⨪  न  ࠭     .

        易⥫쭠/易⥫쭠: 易⥫쭠

祭  砭: ᫨    ᮧ      ࠭ 㤮,
࠭    㬮砭 ⠭   ࠭,   ன 
ᮧ  ,    X    Y  -   न , ஥  .

᫨   ᮧ  १    㬮砭, ࠭
⠭   㬮砭      ࠭,   । 
 (१ ࠪ⨪    ࠭),    X    Y - 
न,  ।塞 SQL*Forms.

        ᫥⥫ 

ࠪ⨪    ᫥⥫   ।   ᯮ-
  ᫥⥫쭮    .  ᫨   , 
᫥⥫  뢠 冷,    ᮮ⢥⢨   
㤥     樨 १ SQL*Forms (Run Form).

        易⥫쭠/易⥫쭠: 易⥫쭠

祭        砭:    祭         㬮砭 ᫥⥫쭮
        ⮣,      ᯮ  ଥ:


                                   -- 127 --



     *     ᮧ      㬮砭,  SQL*Forms   㯮冷稢
        稭    1.  SQL*Forms   㯮冷稢   浪 
           ࠭   㤮 (.., ᫥ ࠢ, ᢥ ).

     砭:  ,        譥     
                 -⠫  ⭮襭     訥
                 ᫥⥫   .

     *      ᮧ      ࠭  㤮,   ᫥⥫
       㬮砭 ⠭    ᫥騩 ᫥⥫ 
      .

     *           뫠      ,   ᫥⥫
      ⠭  㬮砭  ᫥騩 ᢮   .

         १    ᪫ ,  SQL*Forms   
     祭   ᫥⥫쭮          㬮砭:

        *   १  ᪫         ,
          ᫥⥫         ⠭  㬮砭 
          , ᫥騩      ᨬ   ஬     .   ,
          SQL*Forms 㬥蠥    ᫥⥫     
          ⠫     ,       ᮪
          ᫥⥫ ,  祬   ࠧ१ .

        *     ࠧ१  ᪫        ⥬
          c      ⮬    ,   SQL*Forms   ⠭
          ᫥⥫       ,  稭    1.

          SQL*Forms   㯮冷稢       浪       
          ࠭  㤮  (..,  ᫥   ࠢ, ᢥ ).

        *   ࠧ१  ᪫      ⥬ c
              㣮  ,   SQL*Forms   ᫥⥫ 
           ᪫ , 稭 ᫥ ᨬ쭮 ᫥⥫쭮
            ,   ஬    ந ᪫.  SQL*Forms
          㯮冷稢   ᪫    浪     
          ࠭ 㤮.

        襭 

ࠪ⨪  襭  뢠 ,   
 祭    .

⠭      砭:   ࠪ⨪    襭  
㬮砭 祭.  ,  ᫨    譥  
-⠫  ⭮襭,  SQL*Forms  ⠭ 
㬮砭  몫祭.

 ᫥ ᫮, SQL*Forms ⠭ ࠪ⨪ 
㬮砭  몫祭 ⮫쪮  ⥪饣 :

     *      ,      ᢮  ।     ࠪ⨪
         ⮫ Sec 祭.
     *      ਢ      ⮫




                                   -- 128 --



࠭祭:     ࠪ⨪  ࠧ襭    
ࠪ⨪ 뤠  襭 ,     
ࠪ⨪  ᫨ .

砭:    䥩  ࠧࠡ稪,  ஢筠  ࠬ 襭
              樨஢    襩   롮 ਡ⮢.
⢥ : ࠪ⨪  ⮫ Sec 11-9


         ᫨ 

ࠪ⨪       ᫨    뢠     
  祭    ⮫쪮      ᥩ,  ࠭  ।⢮
,    ⥪饥 祭 - NULL.

        ⠭  砭: 몫祭

࠭祭:      ࠪ⨪    ᫨     
              ࠪ⨪  뤠      ࠪ⨪
              襭 .

砭:    䥩  ࠧࠡ稪,  ஢筠  ࠬ    ᫨
               樨஢     襩  롮 ਡ⮢.

        孨 

ࠪ⨪    孨  뢠,   㪢 孥 ॣ
  㪢  孥  ॣ       .  ਬ,  
    STATE ࠪ⨪ 孥 ॣ,  ⮡
࠭஢         ॢ    㡫
⮫쪮 묨 㪢.

,   ࠪ⨪  孥  ॣ   ⮫쪮    
祭,     ଥ.      祭,  
१  㣨     १   ਣ.     ⠪      
뤠 ।⢮  ;  訢    뤠 ⠪,
  ࠭   .

⠭  砭:    SQL*Forms    ⠭ ࠪ⨪  孥
   祭,   ᫨    ᮧ    १    
㬮砭  ᫨ ᮮ⢥騥 ⮫     ⨯  DATE.
    ,   SQL*Forms  ⠭  ࠪ⨪ 孥 
몫祭.

࠭祭:      ࠪ⨪  孥  ॣ  ⮫쪮
                 ⨯  CHAR  ALPHA.

砭:   䥩  ࠧࠡ稪,  ஢筠  ࠬ 孥 
           樨஢  襩 롮 ਡ⮢.

        ⨬ 

ࠪ⨪    ⨬    ⮨    ⠭,
  ।   ᨬ쭮   (High)    쭮 (Low) 祭,
 SQL*Forms ᪠  .  SQL*Forms ᪠  ⮫쪮  㪠
祭    祭  .



                                   -- 129 --



     ⠡   뢠     SQL*Forms   祭 
  묨 ⨯ :
     ⮤ ᫥

ALFA           䠢⭮, ᮣ⭮ 襩 ⥬
               ᫥⥫쭮 㯮冷稢
CHAR           䠢⭮, ᮣ⭮ 襩 ⥬
               ᫥⥫쭮 㯮冷稢

DATE            ஭᪮ 浪
DATETIME        ஭᪮ 浪
EDATE          ᫥
INT            ᫥
JDATE          ᫥
MONEY          ᫥
NUMBER         ᫥
RINT           ᫥
RMONEY         ᫥
RNUMBER        ᫥
TIME           ᫥

易⥫쭠/易⥫쭠: 易⥫쭠
⢥ : ࠪ⨪    12-6

        ७ ப

  ࠪ⨪  ७ ப 뢠,   ।   SQL*Forms
(Run  Form)  ⮬᪨ ७ ⥪,   ஬ 
    ப   .   ࠪ⨪ 몫祭,
SQL*Forms ⮫쪮 稢  ப        [Insert  Line]
([⠢ ப]).

⠭  砭: 祭
砭:    䥩  ࠧࠡ稪,  ஢筠  ࠬ
            ७ ப 樨஢  襩 롮 ਡ⮢.
⢥ :   13-2


      

 ⬥,   SQL*Forms ᠬ  ᥡ  ࠧ砥 ⨯ ,   
᪮॥   ࠧ砥   ⠭  㠫 ࠪ⨪ .  
 ᫥騥 ⨯ ,   ᯮ     㬥
 ॢ ᯮᮡ ᠭ ⠭  ࠪ⨪ :
     *   ⠡
     * ஫쭮 
     *  
     *  
     *  ८ࠧ
     *   
     * ஫ 

             

     樨஢    ⮫殬     ⠡ ,
  ᮤন.  ᨬ  ⮣,  ࠪ⨪ 
⠭,      ਣ   ᯮ짮     ⠡
  믮 ᫥ ⢨:

                                   -- 130 --



   * 訢 祭  樨஢ ⮫
   *    樨஢ ⮫
   * ⠢   樨஢ ⮫
   * 㤠   樨஢ ⮫

ॡ㥬   ⠭:   ࠪ⨪        祭.


           ஫쭮 

  ஫쭮   樨஢    ⮫殬   ⠡.

ࠡ稪 筮 ᯮ ஫쭮   ᮤঠ ᫥
祭  ᮮ饭.    ⠪   ᯮ짮 
뫪     ࠬ,    ᯮ  ਫ 
믮 ᫥, ࠡ  , ᮢ,  㣨 ⢨.

     ਣ       ஫쭮 .
SQL*Forms   ନ஢        ᫥ 筨:
      *  ஬
      *   ⠡
      *  㣨 
      * 㣨   ଠ, 맢  ମ

ॡ㥬   ⠭:   ࠪ⨪        몫祭.


            

    -   ,        
ଠ쭮 ०   ०  .

ॡ㥬 ⠭:   ࠪ⨪    襭 ,  
                     ࠪ⨪  襭 ,   
                     ࠧ   祭.

            

     뤠  SQL*Forms (Run Form).   뤠
 ࠭  㤮    ⮩  ࠭,   ன  樨஢.

ᯮ    ᮪ 業 ᢥ.
ॡ㥬 ⠭: ࠪ⨪ 뤠 몫祭.

            ८ࠧ

    ८ࠧ  樨஢    ⮫殬  ⠡, ⫨筮  
 ⠡ , ᮤঠ饣 .  ᯮ  ८ࠧ 
뤠  ( 㣮 ⠡)  樨஢  㣮 ଠ樥 
.

     ⮫쪮  ଠ樨 楫 ,  㬮砭,
   訢, , ⠢,   㤠    १
  .  ,     ஢  ᠬ⥫쭮 १
ਣ,   ८ࠧ   騬         
 ஢.



                                   -- 131 --



     ਣ  롮ન   ⠡    
஢筮 .

ॡ㥬    ⠭:   ࠪ⨪       몫祭.

             

          ० .
ॡ㥬  ⠭:  ࠪ⨪   襭    몫祭.


             ஫㥬 

  ஫㥬    뤠 ,  祬   .  
१,    "ᮤন"  ,  祬    뤠.   
,    祭 㤥 ஫஢ ।⢮ .
ᯮ ஫㥬   ᮤঠ  祭 (.., )
  墠⠥ ,    ᫠, 뢠  祭.

ॡ㥬   ⠭:  ࠪ⨪  뤠  祭 ⠭
                        襥  祭,  祬  ࠪ⨪  .


           ࠢ ࠢ,   ஫㥬 

    ।      ࠢ ࠢ ⨯   (..,
RINT,  RNUMBER,  RMONEY)    ஫ . ࠢ ࠢ,
஫     㦤  ⥬ 뤠 类
⮣ ,    ६   ᯮ    .

᫨  ᮧ ,   ᮤন ࠢ ࠢ, ஫㥬
,  SQL*Forms  뤠  ।०  ( த ࠡ) 
樨 .

                    13                     

 ᯫ뢠騥      -          ࠭,    뢠 
     뤠  ࠭   ࠡ  .    
ᯫ뢠      ।  ࠧ    ᯮ    
⥫ ࠪ⨪ 뤠.

  ⨯  ᯫ뢠饣      ᢮  㭪樮쭮 祭.
,   ⨯      
ଠ,  ᮮ⢥⢨  ⥪⮬.

 ⮩  뢠 ᭮ ࠪ⨪ ᯫ뢠  
⠫ ᫥騥 ⨯ ᯫ뢠 :
     * ᯫ뢠騩 । 
     * ᯫ뢠騩 ᯨ᮪ 祭
     * ᯫ뢠騥 ࠭

 ⮩   뢠  ᮧ ᯫ뢠騥 .
易몥 ⥬: ᯫ뢠騥  ,  짮⥫᪨ ணࠬ 室

      




                                   -- 132 --



  ᯫ뢠騩 ।      ᯮ짮 ᡥॣ騥
६      ஢   .  맮 ।
 (।⢮   ਣ),  SQL*Forms  ᮧ  ᯫ뢠饥
,   ஥ 樨 ।   ᮮ⢥饥 ,  ஬
।    맢.       ਫ  ,   
            ᬮ७    ।஢.  
। ⨢ - ଠ 室  ०   ஢.        ⮬
०    SQL*Forms ਮ⠭   ࠡ       ⨢
祢 ਣ.

ᯫ뢠騩 ।        맢     뤠 .

뤠   ࠪ⨪: ᯫ뢠騩 ।   直 ࠧ,
   [Edit]  ਣ 뢠  楤
EDIT_FIELD.  ⨥ [Edit]    [Exit/Cansel]  㤠 ᯫ뢠騩
। .

ਭ    ᯫ뢠饣  ,   樨஢   ।஬ 
⠭   㬮砭    ᮧ   䨪樨  .  
ࠧ   ᮣ⭮ ࠧࠬ 室 :
     * ᫨ 室      ࠢ  60,    ᯫ뢠饥
         ,  ࠢ ਭ        ᨬ.
     * ᫨  室          60,      ᯫ뢠饥
             ࠢ  60   ,    室 
       ࠧ饭   ,        6 ப.

     ਬ, ᫨   - 150,  ᯫ뢠饬 । ॡ 
   60- ᨬ ப.    ਬ ᯫ뢠騩 । 뢠
      ᨬ쭮 ࠭⢠, 祬 室  , ⠪ 
   ⢥ ப    ࠢ  . (᫨  
   ଠ樨  । ,  SQL*Forms 뤠 ।०    ⮬, 
        १.)

SQL*Forms   ᯮ   ᯫ뢠騩   ।   ᮣ⭮ ࠪ⨪
 ᯮ  .  ᫨ ⠪ ᯮ   ਢ   
⮬,        । ᯮ  ࠭,   SQL*Forms  ᤢ
ᯫ뢠饥   ࠧ, ⮡ ࠢ쭮  ᯮ.

    ஢  ,  ਭ    ᯮ ᯫ뢠饣
।     १      楤 EDIT_FIELD.

  㭮  13-1  뢠 ᯫ뢠騩 ।    LONG.
            
            
            
            C L I E N T    D A T A
            
             Client ID        108
             Name             JUST TENNIS
             Address          NORTHSIDE MALL
             City             BURLINGAME
            
             State            CA    Zip   17544
               
             Ph 3/12/88
                The JUST TENNIS account is 12 days overdue. No explanation.
ᯫ뢠騩> Turn over to collections in 18 days.
pp      Cr

                                   -- 133 --



           
             Co
               Count: *0                                           <Replace>
            

 筮 ᯮ짮: ᯫ뢠騩 ।  ᯮ  
讣 ⢠  (ᮡ ⥪)        
।⠢        ।஢  .
       筮        맢
ᯫ뢠騩  ।.   ࠧ,  ᯫ뢠騩 । 
ᯮ       ਠ,   ⠪    ਨ  
⠫ 樨,   ⥫  ﭭ ᬮ
஬.

 ⠪,  ⮣,   ᯫ뢠騩 ।  ਢ  ०
஢,   ।     㯭묨  ।஢
,         㯭   筮 ०.  
 㭪樨 ᪠, १  ᪫.
⢥ : EDIT_FIELD, ⭠ 楤 16-13
                  ࠪ⨪  ᯮ    
                  ࠪ⨪     室       ப

     ᮪ 祭

  ᯫ뢠騩  ᯨ᮪  祭    ⥦   ᮡ    㭪樮
,    ᯨ᮪ 祭,         
䥩   (ࠡ稪)    SQL*Forms.

  ᯨ᮪  祭,      ।     SQL
SELECT   ᯫ뢠饬  .   ᯨ᮪ 祭,   
।  ᯨ᮪ 祭 ⨯ V2       ᯫ뢠饬  ,
  ⮣, 믮 ந室    ।  SQL*Forms.

ࠪ⨪    뤠:    ᯫ뢠騩   ᯨ᮪   祭   
    [List]     ਣ 뢠     楤
LIST_VALUES.   롮   祭,   室  ᯨ᪠  祭
뢠  㤠 ᯫ뢠饣 .

      ᮧ   ᯨ᮪   祭      ,    ⠭
ࠪ⨪  ,      । ᫥騥 :
     *  ᯨ᪠ 祭
     * ᯮ  ᯨ᪠  祭    ࠭  (..,   न X  Y
         孥 㣫)
     * ⥪  SQL,    롨ࠥ  祭    ᯨ᮪   祭

᮪ 祭 ࠧࠡ⠭  ஫㥬  ⨪쭮   뢠 
 10  祭 ६.  ( 㭮 13-2.)   । ,
ᮤঠ   ᯨ᪠ 祭 । ਭ ᯫ뢠饣 .

ਬ,  ᫨  ᯨ᮪  祭  ᮤন  祭 ࠧ ,   ᯨ᮪
祭  ,  ⮡  ⨫     뤠
祭.  ,     ਭ ᯨ᪠ 祭.  ᫨ ᯨ᮪
祭 㤥 ⮫쪮 ப,      ࠭,  SQL*Forms
० (ࠢ)   ᯨ᪠ 祭.

              13-2    ਬ ᯫ뢠饣  ᪠ 祭

 O R D E R S

                                   -- 134 --



      Order ID  622               Order Date  03-JUN-89
      Client ID                   Client Names
          
 ĳ                      Client Names
 I T E M S
              Find:
          
            EVERY MOUNTAIN                                     104
          Ĵ JOCKSPORTS                                         100
      Orde  JUST TENNIS                                        103
            K + T SPORTS                                       105
            NORTH WOODS HEALTH AND FITNESS SUPPLY CENTER       108
            SHAPE UP                                           106
            TKB SPORT SHOP                                     101
            VOLLYRITE                                          102
          Ĵ WOMENS SPORTS                                      107
          
 Count: *0                                                   <Replace>


  筮    ᯮ짮:    ᯫ뢠騩   ᯨ᮪   祭 ᯮ
      ண  ⢠    祭   
.        ।   ࠢ쭮
롮,  ⠪     ᬮ    祭      ।
 ࠢ쭮 祭.      ⠪      ᭨ 
⨯  訡,  ⠪        ਢ  ᯨ᪥
祭 אַ  .
⢥ :    ᮪ 祭 ࠪ⨪   Pos
                     ᮪ 祭 ࠪ⨪   sql
                     ᮪ 祭 ࠪ⨪  

     ᯫ뢠     ࠭

  ᯫ뢠 ࠭ -   ࠭.   ࠭  ⭮ 
⥪饩 ଥ  맧뢠 ଥ.  뤠   ࠭    ⮫쪮
  ࠭,    ࠪ⨪      
  믮 .

࠭  ⮫쪮  ⮣     ᯫ뢠 ࠭,  
।     ࠪ⨪  ࠭ ᯫ뢠.  㣮
஭, 뤠 ࠭   ࠭  (  ᫨  䨧ᨪ  ࠧ
࠭  ॢ蠥 ࠭).

  ࠪ⨪  뤠:  ᯫ뢠  ࠭  뢠   
      ⮩  ࠭   ਣ    뤠  
।⢮  ⭮   楤 SHOW_PAGE.    ,  
ᯫ뢠  ࠭  ⨢   ,        
  ⮩ ࠭.

ᯫ뢠   ࠭   㤠        ࠭ 
ࠪ⨪   室  祭    ⭠ 楤
HIDE_PAGE  㤠 .

    ।  ࠭  ᯫ뢠 ࠭ ( ଥ ।
࠭    ७  ⠡),     ।  ࠪ⨪
࠭  ,           ࠭.   
ࠪ⨪ । ᫥騥 ᯥ䬪樨:
  * 砫 ࠧ  (..,    ࠧ    ࠭  )

                                   -- 135 --



  * 砫쭮 ᯮ   ࠭ (,   ࠭  
  * 砫쭮 ᯮ   ࠭ ( ࠭  㢨  ࠭)
  *  
  * 㤥  ࠭  ࠬ
  * 㤥  ࠭  ஫ 

,   ࠧ , ᯮ   ࠭,  ᯮ
      ࠭   -        ᪨ ࠪ⨪.  ,  
     믮  ।⢮  楤
RESIZE_VIEW, ANCHOR_VIEW  MOVE_VIEW. ᯮ   ࠭ ⠪
   ।⢮ 樨  믮.

   㭪 13-3 ਢ ਬ ᯫ뢠饩 ࠭,  ⠪     㤥
   ࠭ 㤮.    㭪  13-4  뢠  
  ⮩  ࠭     ࠭.
            13-3 ਬ ᯫ뢠饩 ࠭

                          ========  CUSTOMERS  ========

             CUSTID
               NAME
            ADDRESS
               CITY
              STATE                                     ZIP
               AREA                                   PHONE
              REPID                             CREDITLIMIT
           COMMENTS


          13-4 ਬ  ᯫ뢠饩 ࠭

                              SUMMIT SPORTING GOODS
         Ŀ
                                    COMPANY                           
         Ĵ
         Ĵ       CUSTID                                              
                   NAME                                              
                ADDRESS                                              
                   CITY                                              
         Ĵ                                                           
  ORD    v        STATE                                   Zip        NTOT
  ID     

              Char Mode: Replace  Page 2                  Count: *0


    ᫨      祬  ࠭   ࠧ,  
  ⮫쪮  ⨢ ࠭.  ⨢ ࠭ ᥣ
.  ᫨  ⨢ ࠭ ४뢠  㣨 , 
⨢ ࠭ 뢠   㣮 ࠭.

筮  ᯮ짮:  ᯫ뢠騥  ࠭ ᯮ   ⥩
  ᮮ⢥⢨  ⥪⮬  ⥪饩  ࠭    ᮮ⢥  ⮬㦥
뢠饬 .  ᯮ  ᯫ뢠 ࠭   
 ᮡ     ଥ  ᮮ⢥⢨  ⥪⮬.




                                   -- 136 --



ਬ, ᯮ ᯫ뢠騥 ࠭  믮 ᫥ ⢨:
    * 뤠 ଠ樨  ᮡ     ᯫ饬    
      ᭮      
    * 뤠        ᯫ뢠饬  ,     
      ᬠਢ 㦭 ଠ  ᮮ⢥⢨  ⥪⮬
    * ᮧ 襩 ᮡ⢥  ࠬ      祭  ଠ樨  
      ஢
    * 뤠 ⥪      ਫ  室   ⥩ ⥪饩
      뤠
⢥ :  ANCHOR_VIEW, ⭠ 楤 16-5
                   HIDE_VIEW, ⭠ 楤 16-18
                   MOVE_VIEW, ⭠ 楤 16-20
                   ࠭, ࠪ⨪ 10-4
                   ࠪ⨪ ࠭   室 10-7
                   RESIZE_VIEW, ⭠ 楤 16-25
                   SHOW_PAGE, ⭠ 楤 16-28











































                                   -- 137 --
