


                ਫ  F                        V2

   ਣ V2  ਣࠬ SQL*Forms, ।묨  ⨯  ਣ஢
V2. ਣ  V2 ⮨     蠣.   蠣  ਣ
⮨  筮     ࠪ⨪,  ।      蠣
믮.

   ਫ  ।⠢  ଠ  蠣 ਣ. ।⠢
᫥騥 ⥬:
   - । 蠣 ਣ
   - ࠪ⨪ 蠣 ਣ
   -   蠣 ਣ
   - 㭪樮  V2
   -  CASE
   - ६  蠣 ਣ
   - ஢ ਣ V2

᫨   ⮫쪮 ਣࠬ V3,  ਫ   㦭.

砭:  ௮ Oracle ⥫쭮 ४ 짮 
            ஥஢  ਪ  ணࠬ ਣࠬ V3.
:  ᨨ ਣ஢ V2  V3              4-2


        । ਣ஢ V2

  ᮧ   ஢  ਣ V2 ⠪    ਣ V3,
ᯮ    Trigger Definiyion  ⠡  ७ (spread table)
Trigger Definition  䥩 SQL*Forms. , ⮡ । ਣ
V2,  ⠪  । 蠣 ਣ १  Trigger Step
Definition  ⠡ ७ Trigger Step Definition.

a:  । ਣ஢  14-2

ଠ         ଠ   Trigger  Step  Definition      ⮬
Trigger       䥩  SQL*Forms  (஥஢)    ஬  
Step          ᮧ,   㭨⮦ 蠣 ਣ஢.
Definition      ଠ     ࠧ     ଠ
Form           蠣 ਣ.

              砭:  ᫨    ଠ  ᪮쪨
              蠣  ਣ ࠧ,  ᯮ  ⠡  ७
              Trigger Step Definition.

. 1  Ŀ
ଠ     Action Form Block Field Trigger Procedure Image Help Option 
Trigger    Trigger Step Deffinition  
Step      Ŀ 
Defini-    Step Number: 1             --Step Attributes--          
tion                                                               
           Label:   STEP1             [ ] Abort on Failure         
           --Success/Failure Labels-- [ ] Reverse Return Code      
           Success: STEP3             [ ] Succeed on Abort         
           Failure: STEP2             [ ] Separate Cursor Area     
          Ĵ 
           Failure Messages:                                        
          Ĵ 
             Trigger Step Text    

                                    -- 91 --



                                                                    
           SEXDMACRO PRUREC:                                        
          ĳ 
             Comment    
           Navigate to the previous record.                         
           
         Enter the sequence number for trigger step.                  
         Frm: ORDER_EMIR BIR: ORDERS Fld: ORDID  Try: KEY-MXIFLD <REP>
        

     Trigger Step Definition   Trigger  Definition
   ⠡   ७  Trigger Definition.   ⠪ 
ᮮ⢥⢮ ਣ, 饬 V2  ࠪ⨪ ਣ Trigger Style.

⮡     Trigger Step Definition  ⠡ ७  
Trigger Definition,  [Zoom In]. ᫨  ⠡  ७
⮡ࠦ,   [Change Display Type].

         ७  Trigger  Step  Definition  
७    ⮬ 䥩 SQL*Forms (஥஢),  
Trigger       ᮧ,   㭨⮦ 蠣 ਣ஢.
Step             ⠡          ଠ 
Definition    ᪮쪨 蠣 ਣ ६. ,  
                ⮩  ⠡    ६.

              砭:  ᫨     ଠ  ,
              ६, ᯮ  Trigger Step Definition.

               .2   ⠡ ७  Trigger Step Definition.
. F-2
      Ŀ
       Action Form Block Field Trigger Procedure Image Help Options 
        Trigger Step Definition  
       Ŀ 
       Ĵ Step          Success   Failure    Abort       R  
          Num    Label   Label     Label    on Fail         
         Ĵ 
                                                            
          :     STEP1   STEP3     STEP2      [  ]           
          2     STEP2                                       
          3     STEP3                                       
                                                            
       Ĵ                                                   
       Ĵ           
                                                               
        
                                                                    
        Enter the sequence number for the trigger step.             
        Frm: ORDER_ENTER  Blk: ORDID  Trg: KEY-PRYFLD        <Rep>  
                                                                    
      

    ⠡  ७  Trigger  Step Definition ⮫쪮  
  Trigger  Definition   ⠡ ७  Trigger Definition.
   ᮮ⢥⢮ ਣ, 饬 ࠪ⨪ V2
ਣ Trigger Style.



                                    -- 92 --



⮡   ⠡ ७  Trigger  Step Definition    ⠡
७  Trigger Definition,  [Zoom In]. ᫨ ଠ  Trigger Step
Definition ⮡ࠦ,  [Change Display Type].


        ࠪ⨪ 蠣 ਣ

 । 蠣 ਣ ⮨   ⠭ ࠪ⨪ 
 蠣 ਣ.     ࠪ⨪  室 ᫥饥:
  - ᭠ ଠ,   ᥡ  蠣  ਣ
  - ⢨ 蠣

 ⮬ ࠧ ।⠢ ࠪ⨪ 蠣 ਣ  䠢⭮ 浪.
,   ࠪ⨪ 蠣  ਣ  ᮮ⢥ 
⮢   Trigger  Step  Definition       ⠡ ७
Trigger  Step  Definition.  ਬ,   Step Number  ଥ Trigger  Step
Definition   ⮬, ।騬 ࠪ⨪ 蠣  ਣ
Step Number.

砭:   ࠪ⨪ 蠣  ਣ    ᮪   
           䥩 SQL*Forms (஥஢).  ⮬ ࠧ ᫥ 
           ᪮  ᮪饭 (ਬ, Step Number (Step Num)).

 ᢠ  ࠪ⨪蠣 ਣ    ᫥ ⮢ 䥩
  ᯮᮡ:

 䥩    ᢮ ࠪ⨪ 

஫        몫 ࠪ⨪
                   祭
⮪ ப⪨     祭

    ࠧ  ᢮, ᪮    
ᠭ ࠪ⨪. ਬ, ࠪ⨪,  ᢮  ஫쭮
   ᠭ  Default Setting ( ,  몫). 
ࠪ⨪, ᢮  ,   ᠭ Required/Optional,
뢠,       , । 蠣 ਣ.
:   䥩   5-1

Abort on      ࠪ⨪ 蠣 ਣ Abort on Failure 뢠,
Failure        ᫨  蠣 ਣ  뤠  "ᯥ",   SQL*Forms
(Abort on     믮  ਩  襭  ਣ,  ᮤঠ饣
Fail)          蠣.

᫨  ᯥ஢ ஢ "ᯥ"  蠣 (.. । ࠪ-
⨪ 蠣 ਣ Failure), ਣ  室    㪠 蠣   
믮 ਩ 襭.   筮    ࠪ⨪ 蠣
ਣ  Reverse  Return Code  ।  ᯥ  ᯥ  蠣  ਣ
(  ᥣ ਣ).

砭:  ᫨    ᯮ짮  ࠪ⨪   ਩
襭    짮⥫᪮ ਣ  ਣ 맢襣 , 
 । ࠪ⨪     ਣ஢. ᫨  ।
ࠪ⨪ ⮫쪮   ਣ 짮⥫, 뢠騩 ਣ
 㤥  ਩ 襭  砥 ᯥ.

⠭  㬮砭:  on


                                    -- 93 --



:  ࠪ⨪  蠣  ਣ  Failure  Label   F-5
          ࠪ⨪ 蠣 ਣ Reverse Return Code  F-7

Comment       ࠪ⨪ 蠣  ਣ Comment  । 
              ଠ   蠣  ਣ.   ࠪ⨪ - 
              㬥  ᭥  楫  ࠪ⨪ 蠣 ਣ.
               ᢮⢮   ᮡ    ,
              ᯮ饣    ꥪ   ਪ ணࠬ,  ⠪  
               ,    ⫠   ਪ ணࠬ.

              Required/Optional:  optional
----------
Failure       ࠪ⨪ 蠣 ਣ Failure Label ᯥ
Label         㣨  蠣 ਣ,   SQL*Forms 室 
(Failure)     "ᯥ"  ⥪饣  蠣.  稭   ࠪ⨪
              Failure  Label      ᮯ⠢    稭
              ࠪ⨪ Label  筮  蠣  ਣ.

              砭:  ࠪ⨪ Reverse Return Code  筮 
              ।  ᯥ    ᯥ  蠣  ਣ (  ᥣ
              ਣ).
              : ࠪ⨪ 蠣 ਣ Label  F-6
                       ࠪ⨪蠣 ਣ Reverse Return Code  F-7
                       Success/Failure   ਣ V2  F-43

饭     ࠪ⨪ 蠣 ਣ Failure Message ।
 "ᯥ"  ᮮ饭, ஥   ப ᮮ饭, 
              蠣 ਣ 뤠 ᯥ.
              :  ਣ V2 F-41

Label         ࠪ⨪  蠣  ਣ Label  㪠뢠  , ஥
              SQL*Forms  ᯮ    䨪樨 蠣 ਣ. 
                   ᮤঠ  ஡     ᮮ⢥⢮
              饯ਭ  祭.

               ࠪ⨪      ,  ⮫쪮  ᫨ ਣ,
              ஬  ਭ  蠣, ᯮ ࠪ⨪  
              室  蠣.

               蠣, ਭ騥  ਣ,   
                ࠪ⨪ Label.
              : ࠪ⨪ 蠣 ਣ Failure Label  F-5
                       ࠪ⨪ 蠣 ਣ Success Label  F-8

New Cursor    ࠪ⨪ 蠣 ਣ New Cursor Area ࠭,
Area (New       蠣 ਣ, ᮤঠ饬    SQL ᢮
Cursor)       ⤥  .

               㬮砭, SQL*Forms ᢠ  蠣 ਣ ⤥
               .   ࠪ⨪  ᯥ稢 ᢮ 
              蠣 ਣ ⤥ ,  ᫨   믮  
                 -o ४⥫  ࠡ祩  樨 Share Cursors
              for Trigger  SQL,  ⠢ SQL*Forms  ᯮ짮
               ꥤ    ஢ SQL  ਣ V2.

              ⠭  㬮砭:  off



                                    -- 94 --



              :  ,    22-3 -o ४⥫, SQL*Forms
                        ( ଠ)  23-18
                          Share Cursors for Trigger SQL  26-4

Reverse       ࠪ⨪  蠣  ਣ  Reverse  Return  Code
Return        뢠,  SQL*Forms   ᯥ/ᯥ
Code           . ਬ, ᫨ 蠣 ਣ 뤠 ᯥ,
(Reverse        ࠡ 室 ࠪ⨪ Reverse Return Code,
Return)       SQL*Forms ⠥    蠣  ᯥ.

              ࠪ⨪ Reverse Return Code  뢠 
              ﭨ, ᫨ 蠣 ਣ 맢 ⠫ 訡.
              ⠭  㬮砭:  off
              :   ਣ஢  F-41


Step Number   ࠪ⨪ 蠣 ਣ Step Number 㪠뢠 
(Step Num)    浪    蠣    ਣ,  ..  冷,
               ஬ SQL*Forms 믮 蠣 ਣ.

               砥 믮      ᫥  ,
              SQL*Forms ७㬥஢뢠  ⠫ 蠣 ਣ:

                - ᢮ 浪  蠣 ਣ, 
                  㦥 ਭ 㣮 蠣 ਣ
                - 㤠 蠣  ਣ,   饣  ᫥
                  蠣  ਣ
                - ⠢  蠣 ਣ    Trigger  Step
                  Definition   ⠡ ७


㬥 蠣  ਣ஢    뢭.      
ਣ      蠣,   1,2,3  5.

祭    㬮砭:    㬮砭  祭 ࠪ⨪ Step Number
ᠬ 讥  ਣ.

Succeed       ࠪ⨪ 蠣 ਣ Succeed On Abort 뢠,
On Abort       믮  蠣  ਣ 맮 ਣ, 騩
                  ਩  襭,     SQL*Forms  㤥
              த 믮 ਣ.

  ࠪ⨪   , ⮫쪮  ᫨  ⠪    蠣
ࠪ⨪  蠣 ਣ Abort On Failure.     ࠪ⨪
祭   蠣 ਣ  뤠   ᯥ,   SQL*Forms   ⠭
믮    ਣ    砥 ਣ,  ᯥ  த
஢.
⠭  㬮砭:  off
:  ࠪ⨪ 蠣 ਣ Abort On Failure  F-5

Success       ࠪ⨪ 蠣 ਣ Success Label ᯥ
Label         ᫥騩 蠣 ਣ,   ஬ SQL*Forms  室
(Success)       ᯥ  ।饣  蠣. 祭  ࠪ⨪
              Success  Label      ᮯ⠢    祭
              ࠪ⨪ Label  筮 蠣 ਣ.




                                    -- 95 --



砭:  ࠪ⨪ Reverse Return Code  筮 
। ᯥ  ᯥ 蠣 ਣ (  ᥣ
ਣ).
: ࠪ⨪ 蠣 ਣ Label  F-6
         ࠪ⨪蠣 ਣ Reverse Return Code  F-7
         Success/Failure   ਣ V2  F-43

Trigger       ࠪ⨪ 蠣 ਣ Trigger Step Text ।
Step Text       SQL    SQL*Forms,    믮  
              ᪥ 蠣 ਣ.

          蠣 ਣ஢

  ⨯ ,        蠣 ਣ஢:
   -  SQL
   -  SQL*Forms
   - 맮 짮⥫᪮ 室

  । 蠣  ਣ,    אַ    ⮪
ப⪨  Trigger  Step  Text  Trigger Step Definition.

 SQL     SQL, ਬ塞   蠣  ਣ,  
 蠣         SQL,    ᯮ    ਣ  V3.
ਣ         ᯥ᪨ ࠢ ⮫쪮
               蠣 ਣ.  ࠢ   SQL
              ࠡ    ꥪ⠬  SQL*Forms.

               蠣 ਣ   稢  SQL 窮 
              ⮩.

            SQL 頩   SQL*Forms  ,
SQL*Forms     ।    ஥⨢  䥩    
 SQL         ६. ।    稥 (:).

              :[block.]field
              :GLOBAL.variablename

ᯮ 筥  (.. block.field),   뫠  , 
ண   㭨   ⥪饩  ଥ. ᫨     믮, 
᪥ ਣ  訡.

砭:    ᮢ⨬    ଠ, ᮧ묨    
࠭   ᨩ  SQL*Forms,      ᯮ짮      
ᨬ  &.  , ௮ Oracle ४  ᯮ짮 稥.

ࠧ Into      뢠  祭   ⮫    
 Select      SQL*Forms, ᯮ  SQLSELECT  ࠧ INTO.  
               롨ࠥ  ப      , ᨬ 
              ⮣,  ⢮ ப 㤮⢮ ᫮ 
              SELECT.
⠪  ࠧ INTO:

        INTO [:] [block.] field[, [:] [block.] field...]

 ࠧ ᥣ   祢 ᫮ SELECT  ࠧ FROM.
ਬ:
SELECT NAME


                                    -- 96 --



    INTO :ORDERS.NAME
    FROM CLIENT
    WHERE CLIENT.CLIENTID = :ORDERS.ORDID

᫨  SELECT ⡨ࠥ 祭  祬   ,  冷
ᮮ⢥   ⮫殢        ⥬  ᠬ.
ਬ:

SELECT NAME, CREDIT_LIMIT
    INTO :ORDERS.NAME, :ORDERS.CREDIT_LIMIT
    FROM CLIENT
    WHERE CLIENT.CLIENTID = :ORDERS.ORDERID

砭:    ᮢ⨬    ଠ, ᮧ묨    
࠭   ᨩ  SQL*Forms,      ᯮ짮      
ᨬ  &.  , ௮ Oracle ४  ᯮ짮 稥.

         SQL*Forms -   ,      
SQL*Forms     ᯮ짮  ⮫쪮    ਣ  V2  SQL*Forms.  
 蠣         ᯥ稢  蠣  ਣ  ।⢠  
ਣ      믮  㭪権.

                :
                    - #COPY
                    - #ERASE
                    - #EXEMACRO
                    - #HOST

 #COPY  ⠪:  #COPY sourse [INTO] destination :
        sourse               । (value) 祭
        destination          । (variable) ६

  ஡  ଠ樥   value   variable, 頩    "V2
Function  Code  Arguments".

ᠭ:   #COPY  室  祭     祭.
室  祭     ⠭⮩, 祭  ,  쭮
६, ⥬  ६;  ⮬  祭    ,
⥬ ६  쭠 ६.

 #OPY  㭪樮  V2, COPY - 믮     㭪樨.


       ⠪:  #ERASE GLOBAL.variablename
#ERASE
              ᠭ:   #ERASE 㤠    ६-
               ⠪ ࠧ,    ⠥ ⢮. ᫨ 
              ⠥ 㤠 祭   ६,
              SQL*Forms     #ERASE.

               #ERASE  㭪樮  V2, ERASE 믮
                  㭪樨.


       ⠪:  #EXEMACRO statement [statement...]
#EXEMACRO
              : statement  㭪樮  V2 SQL*Forms
                CASE.

                                    -- 97 --



              ᠭ:   #EXEMACRO 믮 ஢
              㭪樮 ,  CASE   .

              :   CASE   F-38
                        㭪樮  V2   F-12


       ⠪:  #HOST system_command
#HOST
              ᠭ:   #HOST 믮  樮
              ⥬.
                  ஡  ଠ樥   system_command,
              頩    "V2  Function  Code  Arguments".


맮         짮⥫᪨  室   蠣 ਣ  믮
짮-     ⠪,      ਣ V3. , ᨭ⠪  
⥫᪮     ਬ 㣮.
室
              ⠪:  # [#] exitname parameters              :

              exitname          C    뢠  
                                짮⥫᪮ 室.

              parameters        C  ࠬ,    
                                ।  짮⥫᪨ 室.

              :  짮⥫᪨ 室   19-1

        㭪樮  V2

  ࠧ 㭪樮  SQL*Forms V2   䠢⭮ 浪.
 ⠪ ।⠢ ᨭ⠪   ᠭ   㭪樮쭮
.

砭:  ᫨     ᯮ  ।騥  ᨨ SQL*Forms,   
  뫠   㭪樮  V2,   .

:   #EXEMACRO   F-11
          C⠢ 㭪樮  V2 c V3 ⠬   F-36

         㭪樮쭥    ।⠢   㬥  ⠪
㭪樮-      ࠧ,     ࠭ ਪ ணࠬ,
       ᮧ    ।    SQL*Forms.   
 V2       ࠧ ।⠢  㭪樮 ,  
               ।  :
   ANCHORVIEW        LASTREC
   BREAK             MOVEVIEW
   CLREOL            POST
   DISPLAY           REPLACEMENU
   EDITFIELD         RESIZEVIEW
   FIRSTREC          SET
   GOREC             SHOWMENU
   HIDEMENU          SHOWPAGE
   HIDEPAGE

     ᯮ짮  㭪樮     
   ਪ  ணࠬ  ﬨ, 騬    ᨨ 3.0.

                                    -- 98 --



ࠬ      ⪮,  ࠬ 㭪樮 
㭪樮-         ᮪饭  ଥ.   ࠢ   
       ᮪饭  頩  ᫥饩 ⠡:
              ࠬ          ।
              
              field             {fieldname  blockname.fieldname}
              message           value
              system_command    {'command_string'  field 
                                variable_reference}

              'text'                ப      78 ᨬ.
                                ᫨   ᯮ짮   (')
                                 ⥪ ᮮ饭, ᯮ  ⠪ 
                                 ப (ਬ, 'Record isn''t available').

              value             {'text'  variable}

              variable          {[:] field  [:] GLOBAL.variablename 
                                [:] SYSTEM.variablename 
                                variable_reference}

              variable_         & variable
              reference

-       㭪樮  V2, ਭ騩  祭, 
         ࠬ,    ࠦ  ⥭  (
ࠬ஢    ꥤ  ᫥⥫쭮⥩  ) ᪮쪨
㭪樮-      祭. ⮡  ⥭஢ 祭, ᯮ
쭮      ᫥騩 ᨭ⠪:
 V2
              expression = value[  value]...

              ਬ, ᫥騩   뢠  ᮮ饭 
              ࠭  ⮡ࠦ 祭 :

          #EXEMACRO MESSAGE ' The field value '  :ordid  is too small.';

        ABTQRY        ⠪:  ABTQRY;

ᠭ:  ABTQRY 믮 ਩ 襭 , ᫨   
           ⥪饬 .

        ANCHORVIEW
⠪:  ANCHORVIEW page_number x_coordinate y_coordinate;
:
page_number          ࠭  ⥪饩  ଥ, 
                ன  ⮨ ।⠢.

x_coordinate      ।  ࠭ x न ⮩ 窨,   
                  孨 㣮 ।⠢.

y_coordinate      ।  ࠭ y न ⮩ 窨,   
                  孨 㣮 ।⠢.

ᠭ:  ANCHORVIEW ᤢ ।⠢ ࠭  㣮 .




                                    -- 99 --



砭:
         -  ᤢ ।⠢ ⠪ ࠧ, ⮡  
             । ࠭.
         -   ᯮ짮 ANCHORVIEW ⮫쪮  ᯫ뢠 ࠭.

:  ࠭, ࠪ⨪  10-4
          ᯫ뢠騥 ࠭  13-5
          㭪樮  V2, MOVEVIEW  F-27

BELL          ⠪: BELL;
              ᠭ:  ᫥ ᨭ஭樨  㪮 ᨣ.

BREAK         ⠪: BREAK;
              ᠭ:  ᫨ ⥪ ଠ ࠡ⠥  ० ⫠,
                         BREAK   ⠭   믮    
                         ⮡ࠦ  Debug Mode Options.  㣨
                         ० BREAK  믮  ⢨.
              :  ।⢠ ⫠   28-1


CALL          ⠪:  CALL formname [ { HIDE  NO_HIDE }
                          NO_REPLACE ]];

ᠭ:  CALL 믮 ஢ ,   ६   
"த⥫᪠"  (parent)   ଠ  ⠥ ⨢. SQL*Forms   믮
뢠            権,      த⥫.  
뢠  ଠ  蠥  १  㭪  EXIT     १
ᯥ   ६饭,  ஢ த    த⥫᪮  ଥ
   CALL.

 㬮砭, CALL  ᯮ  祢  ᫮  HIDE  NO_REPLACE. 祢
᫮ HIDE ⠢  SQL*Forms  뢠     ࠭ ।
⠢ 뢠 . SQL*Forms  ந ⮣ ⢨, ᫨
  ᯮ짮  祢  ᫮  NO_HIDE.   砥, ,  ᫨  
뢠       NO_HIDE,   ࠭  뢠 
, 祬  ࠭,  뢠 ଠ ⮡ࠦ   .

祢 ᫮ NO_REPLACE ⠢ SQL*Forms ࠭  㬮砭 
ਪ ணࠬ 뢠 .

  뢠  , SQL*Forms  訢  ࠭  뢠
ଥ. ᫨ 㭪 CLEAR_FORM ਢ   ப⪥  ,   뢠
ଠ  ⥪饩,  SQL*Forms 믮 ப  易
(uncommited) ⮩ 窨.
:  ࠪ⨪    Default  Menu
          Application   9-3
          ࠪ⨪ ࠭ Page Size  10-6
          窠 ࠭   3-18


        CALLINPUT     ⠪:  CALLINPUT;

ᠭ:  CALLINPUT  ਭ   ࠡ⠥   㭪樮
箬.   CALLINPUT  ⮡ࠦ १ 㭪 EXIT   १
㤠 ६饭, ஢   த    窥   
CALLINPUT.



                                   -- 100 --



砭: CALLINPUT  祭    SQL*Forms  3.0   ࠢ   ।騬
ﬨ. ௮  Oracle  ४   ᯮ짮  㭪樮
 V2     ਪ  ணࠬ.

        CALLQRY       ⠪:  CALLQRY formname [{1HIDE0  NO_HIDE}
                                          [ REPLACE 1 NO_REPLACE0]];

ᠭ:  CALLQRY 믮 㪠 ,   ६  த⥫᪠
⠥  ⨢ ﭨ.SQL*Forms 믮  뢠      ⥬
  ﬨ,   த⥫      ⮫쪮- (query-only).
 뢠 ଠ  १ 㭪 EXIT   १ 㤠
६饭,  ஢ த    窥   CALLQRY.

 㬮砭, CALL  ᯮ  祢  ᫮  HIDE  NO_REPLACE. 祢
᫮ HIDE ⠢  SQL*Forms  뢠     ࠭ ।
⠢ 뢠 . SQL*Forms  ந ⮣ ⢨, ᫨
  ᯮ짮  祢  ᫮  NO_HIDE.   砥, ,  ᫨  
뢠       NO_HIDE,   ࠭  뢠 
, 祬  ࠭,  뢠 ଠ ⮡ࠦ   .

祢 ᫮ NO_REPLACE ⠢ SQL*Forms ࠭  㬮砭 
ਪ ணࠬ 뢠 .  ᫨   ᯮ짮 祢 ᫮
REPLACE, SQL*Forms         㬮砭  ਪ  ணࠬ
뢠         㬮砭  ਪ ணࠬ  맢
.
  뢠  , SQL*Forms  訢  ࠭  뢠
ଥ. ᫨ 㭪 CLEAR_FORM ਢ   ப⪥  ,   뢠
ଠ  ⥪饩,  SQL*Forms 믮 ப  易
(uncommited) ⮩ 窨.
:  ࠪ⨪    Default  Menu
          Application   9-3
          ࠪ⨪ ࠭ Page Size  10-6
          窨 ࠭   3-18

        CHRMODE       ⠪:  CHRMODE;
----------
ᠭ:  CHRMODE  砥  ०  . ᫨ ଠ    
ࠡ⠥  ० ⠢,  CHRMODE 頥     ० .  ᫨
ଠ     ࠡ⠥    ० ,  CHRMODE  頥 
  ०  ⠢.


        CLRBLK        ⠪:  CLRBLK [ASK_COMMIT0]  DO_COMMIT 
                                  NO_OMMIT  NO_VALIDATE];
----------
ᠭ:     CLRBLK   砥      ⥪饣   .  ᫨  ⥪饬
                ,   뫨 ।  易
              (committed),   CLRBLK   ਬ塞  
              祢  ᫮.

no keywords       SQL*Forms ।  易    ६
                  ࠡ CLRBLK.
ASK_COMMIT        SQL*Forms ।  易    ६
                  ࠡ CLRBLK.





                                   -- 101 --



DO_COMMIT         SQL*Forms        砥  ⥪饩
                    饭  .
NO_COMMIT         SQL*Forms        砥  ⥪饩
                    饭  .

NO_VALIDATE       SQL*Forms 砥   ⥪饩     樨
                  , 뢠    饭  .

        CLREOL        ⠪:  CLREOL;
----------
ᠭ:  CLREOL 뢠 祭  ⥪饣     ⥪饩  樨
              ப  .

        CLRFLD        ⠪:  CLRFLD;
----------
ᠭ:  CLRFLD  뢠  楫  祭 ⥪饣  - ᬮ  
           ⥪   -  祭   .

        CLRFRM        ⠪:  CLRBLK [1ASK_COMMIT0]  DO_COMMIT 
                          NO_OMMIT  NO_VALIDATE];


ᠭ:     CLRFRM   砥      ⥪饣   .  ᫨
               ⥪饬   ,   뫨 । 
易 (committed),   CLRFRM   ਬ塞  
祢  ᫮.

no keywords       SQL*Forms ।  易    ६
                  ࠡ CLRFRM.
ASK_COMMIT        SQL*Forms ।  易    ६
                  ࠡ CLRFRM.
DO_COMMIT         SQL*Forms        , 믮 뢠 
                  砥  ⥪饩   饭  .

NO_COMMIT         SQL*Forms         砥 
                  ⥪饩   믮  뢠     饭 
                  .

NO_VALIDATE       SQL*Forms 砥   ⥪饩     樨
                  , 뢠    饭  .

        CLRREC        C⠪:  CLRREC;
----------
ᠭ: CLRREC 砥  ⥪饣 .  ᫨     
          ,   SQL*Forms 롨ࠥ    १ .

        COMMIT        ⠪:  COMMIT
----------
ᠭ:  OMMIT          ᮯ⠢   
  ଥ.  砫  SQL*Forms   .  ᫨     
뢠    ,         SQL*Forms ।
㤠, ⠢         믮  뢠  
.   뢠 祭, SQL*Forms ᢮  ⠡ 
࠭ ப, ࠭訥  .

᫨  ।      ६ ⥪饣 ᥠ SQL*Forms
( ଠ), COMMIT 뢠      .


                                   -- 102 --



:  㭪樮  V2, POST   F-29

        COPY          ⠪:  COPY sourse INTO destination;
----------
ᠭ:  COPY   室  祭  㭪 祭. 室
祭     ⠭⮩, 祭  ,  쭮  ६
 ⥬ ६;  㭪  祭        
쭮 ६.

㭪樮  COPY   #COPY ந     ⢨.
:   #COPY    F-10

        QUERY        ⠪:  CQUERY;
----------
ᠭ:  CQUERY     ப,  㤥 ᪠ .
᫨  ,   뫨 ।      易   (committed),
   SQL*Forms ।   믮   뢠   ६ ࠡ
CQUERY.

        CREREC        ⠪:  CREREC;
----------
ᠭ:  CREREC ᮧ    ⥪饬  ᫥  ⥪饩  .
⥬  SQL*Forms  ६頥       .

        DEFAULT       ⠪:  DEFAULT value INTO variable;
----------
ᠭ:  DEFAULT  祭  ६, ᫨ ⥪饥 祭
६ ࠢ .  ᫨  ⥪饩 ६ 㫥 祭, 
DEFAULT  믮    ⢨.   ᫨    ६    
஢    쭮   ६,   SQL*Forms  ᮧ
६.

        DELBACK       ⠪:  DELBACK;
----------
ᠭ:  DELBACK 㤠 ᨬ  ᫥  .

        DELCHR        ⠪:  DELCHR;
----------
ᠭ:  DELCHR 㤠 ⥪   . ᫨   ᮮ⢥
ப    ,  SQL*Forms 믮 ࠭  । 㤠,
ન    㤠. ᫨    , SQL*Forms 롨ࠥ
  १ .

        DERROR
----------
⠪:  DERROR  ⮡ࠦ   ࠭ Display Error, ᫨  室
            訡.       㭪樮 ,
            SQL*Forms ८⮡ࠦ .

        DISPLAY
----------
⠪:  DISPLAY variable display_attribute;

ᠭ:  DISPLAY  ᯮᮡ   (variable)  ନ,
  ᯥ஢ ਡ   ⮡ࠦ (display_attribute).  
⨬ ਡ⮢ ᮡ࠭    ⮡ࠦ Oracle*Terminal,  ன



                                   -- 103 --



ࠡ⠥ ଠ. ᫨  ᯥ  ⨬   ਡ ⮡ࠦ,
SQL*Forms ᢠ ਡ ⮡ࠦ  㬮砭  ,    
।    ⥪饩  ⮡ࠦ.

   뫪      ⥪饩 .  ,  DISPLAY
  ⮫쪮  ⥪騩  .  砥,  ᫨ 
ᯥ   ⮡ࠦ  , 饣    
⢮   ᥩ,  DISPLAY  ⮫쪮      ,
ਭ饣 ⥪饩  .

 , ᤥ 㭪樮  DISPLAY, 䥪⨢   
,   㣮q    DISPLAY        ࠪ⨪    
 ᥠ SQL*Forms ( ଠ).
:  Oracle*Terminal  25-10

        DKEYS         ⠪:  DKEYS;
----------
ᠭ:  DKEYS  ⮡ࠦ   ࠭  Show Keys.    
           㭪樮  ,  SQL*Forms ८⮡ࠦ  .

        DOWN          ⠪: DOWN;
----------
ᠭ: DOWN  ६頥      ⥪饣       
᫥騬  浪  ஬.  室,  SQL*Forms  ᮧ  
   롨ࠥ       ६饭.

        DUPLFLD       ⠪: DUPFLD;
----------
ᠭ:  DUPFLD  ᢠ  ⥪饬       祭,   
  ⮣     ।饩 .

        DUPREC        C⠪:  DUPREC;
----------
ᠭ:  DUPREC     祭      ।饩    
ᮮ⢥騥  ⥪饩 .     ᮮ⢥⢮
ப  .

        EDITFIELD
----------
     ⠪: EDITFIELD [x_coordinate y_coordinate width height];
           :
x_coordinate       楫  न X  ࠭,  
                    孨    㣮  ᯫ뢠饣
                  ।  .
y_coordinate       楫  न Y  ࠭,  
                    孨    㣮  ᯫ뢠饣
                  ।  .
width                ਭ ᨬ ᯫ뢠饣 ।
                  .
heigh                ᨬ ᯫ뢠饣 ।
                  .

ᠭ:  EDITFIELD ⨢ ।  ⥪饣   SQL*Forms
( ଠ)    頥    ०  Edit.





                                   -- 104 --



  ᯮ짮 易⥫   ࠬ EDITFIELD    ᯥ䨪樨
   ࠧ஢ ᯫ뢠饣  ,    易 ।  .
᫨     ᯮ    ࠬ஢, SQL*Forms ᪠  ।
   ࠧࠬ    㬮砭.
:      13-2

        ENDSTEP
----------
⠪:  ENDSTEP [FAIL] [MESSAGE message];

ᠭ: ENDSTEP ⠭ ஢ ⥪饣 蠣 ਣ. 
᫨    ᯥ஢  祢 ᫮  FAIL, 蠣  ਣ  뤠  ᯥ.
  ᯮ짮   ࠧ  MESSAGE    뫪  ᮮ饭 (message)   
ப   ᮮ饭.   ,    ࠪ⨪ 蠣  ਣ  
뢠 ﭨ   ENDSTEP.

        ENDTRIG       ENDTRIG [FAIL] [MESSAGE message];
----------
ᠭ: ENDTRIG ⠭ ஢ ⥪饣 蠣 ਣ. 
᫨    ᯥ஢  祢 ᫮  FAIL, 蠣  ਣ  뤠  ᯥ.
  ᯮ짮   ࠧ  MESSAGE    뫪  ᮮ饭 (message) 
ப  ᮮ饭.  ,    ENDTRIG   ஢
success/failure   ⥪饣 蠣 ਣ.

        ENTER         ⠪:  ENTER;
---------
ᠭ: ENTER       ⥪   樨.

        ENTQRY        ⠪: ENTQRY [ALL] [FOR UPDATE];
----------
ᠭ:  ENTQRY   ⠢     ⥪騩     頥   
०  Enter  Query.  ᫨  ,      뫨  易,  
SQL*Forms ।  믮   뢠   ६ ࠡ
ENTQRY.

᫨   ᯮ  祢  ᫮ ALL,  SQL*Forms 뢠   
⮡࠭        롮ન.  ᫨    ᯮ  ࠧ  FOR
UPDATE,   SQL*Forms ⠥    ⮡࠭ .

        ERASE         ERASE GLOBAL.variablename;
---------
ᠭ:  ERASE 㤠 㪠  ६ ⠪  ࠧ, ⮡
 ⠫ ⢮.  㭪樮  ERASE   #ERASE
믮     樨.

        ENTQRY        ⠪: ENTQRY [ALL] [FOR UPDATE];
---------
ᠭ:  ENTQRY   ⠢     ⥪騩     頥   
०  Enter  Query.  ᫨  ,      뫨  易,  
SQL*Forms ।  믮   뢠   ६ ࠡ
ENTQRY.

᫨   ᯮ  祢  ᫮ ALL,  SQL*Forms 뢠   
⮡࠭        롮ન.  ᫨    ᯮ  ࠧ  FOR
UPDATE,   SQL*Forms ⠥    ⮡࠭ .




                                   -- 105 --



        EXETRG        ⠪:  EXETRG triggername;
---------
ᠭ:  EXETRG 믮  㪠  ਣ 짮⥫.

        EXIT
---------
⠪:  EXIT [1ASK_COMMIT0  DO_COMMIT  NO_COMMIT  NO_VALIDATE];

ᠭ:  ६  CALLINPUT, EXIT  蠥  㭪 CALLINPUT.   㣨
⥪  EXIT  ६頥   ।   . ᫨   ⥪饬   
,   뫨 ।    易 (committed),  
EXIT    ਬ塞    祢 ᫮.

no keywords       SQL*Forms ।  易    ६
                  ࠡ EXIT.
ASK_COMMIT        SQL*Forms ।  易    ६
                  ࠡ EXIT.

DO_COMMIT         SQL*Forms        , 믯  뢠
                   室     饭   .

NO_COMMIT         SQL*Forms      室    ⥪饩 
                   뢠      饭  .

NO_VALIDATE       SQL*Forms  室  ⥪饩   樨
                  , 뢠     饭   .

        FIRDTREC      ⠪:  FIRSTREC;
---------
ᠭ: FIRSTREC ᤢ   ࢮ  ᯨ᪠  ᥩ   .

        GOBLK         ⠪:  GOBLK blockname;
---------
ᠭ:  GOBLK  ᤢ     㪠  .

        GOFLD         ⠪:  GOFLD field;
---------
ᠭ:  GOFLD ᤢ   㪠 .

        GOREC         ⠪:  GOREC record_number;
---------

record_number ᯥ  祭, ஥ SQL*Forms  業
 .  砥 ⠪ 祭 : SYSTEM.TRIGGER_RECORD + 8'.

ᠭ:  GOREC   ᯮ   浪     ६饭  
           㪠  .
砭:    ᯮ짮 ⥬ ६ SYSTEM.CURSOR_RECORD
   SYSTEM.TRIGGER_RECORD   ।  浪    .

:  SYSTEM.CURSOR_RECORD   18-8
          SYSTEM.TRIGGER_RECORD   18-12

        QOSTEP        ⠪: GOSTEP label;
---------
ᠭ:  GOSTEP 뢠 室 믮  ਣ   믮
            蠣 ਣ (label).


                                   -- 106 --



        HELP          ⠪:  HELP;
---------
ᠭ:  HELP ⮡ࠦ ᪠  ப ᮮ饭.  ᫨ ⪠
           ᪠ ⮫쪮  뫠  ⮡ࠦ,  HELP ⮡ࠦ ஡
           ࠢ ଠ  .

        HIDEMENU      ⠪:  HIDEMENU;
---------
ᠭ:  HIDEMENU 뢠 祧 ⥪饣  SQL*Menu, ᫨ 
⮡ࠦ   ,    ,  ४뢠 .
᫨ ⨢஢ 㭪樮    V2  SHOWMENU      
[Menu],    ᭮  ⮡ࠦ.
:    SQL*Menu   25-3

        HIDEPAGE      ⠪: HIDEPAGE page_namber;
---------
  page_namber -   ࠭,    ᤥ  .
ᠭ:  HIDEPAGE  뢠  祧  ࠭   ࠭.
砭:
  -     ᤥ    ⥪  ࠭ .
  -     ᯮ짮  HIDEPAGE  ⮫쪮   ᯫ뢠  ࠭.
: ࠪ⨪ ࠭  10-4
         ᯫ뢠騥 ࠭  13-5

        HOST          ⠪:  HOST system_command [NOSCREEN];
---------
ᠭ:  HOST 믮 㪠  樮 ⥬. ᫨ 
ᯮ  祢  ᫮ NOSCREEN,  SQL*Forms   
믮 .

㭪樮  HOST   #HOST 믮     㭪樨.
:   #HOST   F-11

        LASTREC       ⠪:  LASTREC;
---------
ᠭ: LASTREC ६頥   ᫥  ᯨ᪠  ᥩ  .
᫨    , SQL*Forms 롨ࠥ   १ 

        LISTVAL       ⠪: LISTVAL [1NO_RESTRICT0  RESTRICT];
---------
ᠭ: LISTVAL  ⮡ࠦ ᯨ᮪  祭 ⥪饣 . ᮪  祭
⠥ ⮡ࠦ   ,      [Exit/cancell] 
 롥 祭  .
 㬮砭, LISTVAL ᯮ 祢  ᫮ NO_RESTRICT.  祢
᫮  ⠢  SQL*Forms  ᯮ짮 ⮬᪨    
᢮⢮ (complete feature).  C    ⮣  ᢮⢠ ᯨ᮪ 祭
業 ⥪饥 祭     祭 ᪠.

        MENU          ⠪:  MENU;
---------
ᠭ:  MENU  ⮡ࠦ        ਭ   ஬
.  ᫨     ⨬   롮,    MENU    ६頥
   ᮮ⢥騩  .

        MESSAGE       ⠪:  MESSAGE message;
---------
ᠭ:  MESSAGE  ⮡ࠦ  ।  ᮮ饭   ப ᮮ饭.


                                   -- 107 --



        MOVEVIEW
---------
⠪:  MOVEVIEW page_namber x_coordinate y_coordinate;
:
page_number          ࠭   ⥪饩  ଥ,
                    ன  ⮨ ।⠢.

x_coordinate      ।  ࠭ x न ⮩ 窨,   
                    孨 㣮 ।⠢.

y_coordinate      ।  ࠭ y न ⮩ 窨,   
                    孨 㣮 ।⠢.

ᠭ:   MOVEVIEW  ᤢ  ।⠢  ࠭   㣮 .
 楤  ⥫쭣        ࠭,  
     ।⠢. 楤        
।⠢    ࠭.
砭:
         -  ᤢ ।⠢ ⠪ ࠧ, ⮡  
             । ࠭.
         -   ᯮ짮 MOVEVIEW ⮫쪮  ᯫ뢠 ࠭.

:  ࠭, ࠪ⨪  10-4
          ᯫ뢠騥 ࠭  13-5
          㭪樮  V2, ANCHORVIEW  F-14

        MOVLEFT       ⠪: MOVLEFT;
---------
ᠭ:  MOVLEFT ᤢ    ஡ .    室,
MOVLEFT  ப稢 祭 , ⮡    ᮮ⢥騩
ᨢ ஡.

        MOVRIGHT      ⠪: MOVRIGHT;
---------
ᠭ: MOVRIGHT ᤢ    ஡ .   室,
MOVRIGHT ப稢 祭 , ⮡    ᮮ⢥騩
ᨢ ஡.

        NEWFRM        ⠪: NEWFRM formname;
---------
ᠭ:  NEWFRM   뢮  ⥪       㪠 .
뢠 ଠ ४頥 믮 த⥫᪮ . ᫨ 뢠
ଠ 뫠 맢 ମ   ᮪  ஢,  SQL*Forms ࠭
   襣   ஢      ⨢   ﭨ   ᬠਢ  
  . SQL*Forms ᢮ ,  ᯮ짮
४饭 ଠ.

SQL*Forms 믮       ⮩  樨 SQL*Forms  (
ଠ),     த⥫᪮ .  ᫨  த⥫᪠ ଠ  뫠
뢠  ମ,  SQL*Forms 믮     ⥬   ࠬࠬ
(ਬ,  HIDE   NO_REPLACE),       த⥫᪮ .
: 㭪樮  V2,CALL   F-15

        NOOP          ⠪: NOOP;
---------
ᠭ:  NOOP  ⮡ࠦ  ᮮ饭,  "Unrecognised command"  (
). NOOP    믮  㭪権.


                                   -- 108 --



        NULL          ⠪:  NULL;
---------
ᠭ: NULL  믮  㭪権.

        NXTLBK        C⠪: NXTLBK;
---------
ᠭ:  NXTLBK ६頥        浪 ஬,
᫥騬  ⥪騬 . ᫨ ⠪     ,     NXTBLK
६頥      ,  饬 ।騩 浪 .
᫨ ⠪    ,   NXTBLK  ६頥     ⥪饬 .

        NXTFLD        C⠪: NXTFLD;
---------
ᠭ:  NXTFLD ६頥        浪 ஬,
᫥騬  ⥪騬 . ᫨ ⠪     ,     NXTFLD
६頥      ,  饬 ।騩 浪 .
᫨ ⠪    ,   NXTFLD  ६頥     ⥪饬 .

᫨  樮 楩   ,  NXTFLD     
 浪묨 ࠬ 訬, 祬  ⥪饣   訬, 祬 
室 .

        NXTKEY        ⠪: NXTKEY;
---------
ᠭ: NXTKEY  ६頥        祢  ᫮  
浪  ஬, ᫥騬  ⥪騬  .  ᫨  ⠪    ,
  NXTKEY ६頥         祢 ᫮, 饬
।騩 浪 .

᫨ 樮 楩   ,  NXTKEY    
浪묨 ࠬ 訬, 祬  ⥪饣   訬, 祬 
室 .

        NXTREC        ⠪:  NXTREC;
---------
ᠭ: NXTREC ६頥     浪 ஬, ᫥騬
 ⥪饩 . ᫨ ⠪            , 
SQL*Forms 롨ࠥ    ६  ࠡ  NXTREC.

        NXTSET        ⠪: NXTSET;
---------
ᠭ: NXTSEC  墠뢠  ᫥騩    ᥩ    
६頥   ࢮ   롮ન.  NXTSET ᯥ譮  믮, ⮫쪮
᫨      ⥪饬 .

        PAUSE         ⠪:  PAUSE;
---------
ᠭ: PAUSE ਮ⠭ ஢   ,    
             㭪樮  .

        POST          ⠪:  POST;
---------
ᠭ: POST 뢠       ,    믮
뢠     .  砫 SQL*Forms   . ᫨  
  뢠    ,      
SQL*Forms  ।  㤠, ⠢       .



                                   -- 109 --



  , ।        뢠     
 COMMIT,  믮﫠  ६ ⥪饣  ᥠ  SQL*Forms
( ଠ).      ப稢       CLRFRM.
:  㭪樮  V2, COMMIT  F-29
          窨 ࠭   3-17

        PRINT         ⠪: PRINT;
---------
ᠭ:  PRINT 뢠     ࠭   䠩.  SQL*Forms
頥     㪠ﬨ  ⮬,  ࠭ 㦭 ,
   䠩,     ࠭   ᠭ  㦭 
뫠 䠩  ਭ.

        PRVBLK        ⠪: PRVBLK;
---------
ᠭ:  PRVLBK ६頥      , 饬 ।騩
浪 . ᫨ ⠪  ,    PRVBLK  ६頥    
    浪  ஬, ᫥騬    ⥪騬  .  ᫨
⠪    ,  PRVBLK  ६頥    ⥪饬 .

        PRVFLD        ⠪: PRVFLD;
---------
ᠭ:  PRVFLD ६頥      , 饬 ।騩
浪 . ᫨ ⠪  ,  PRVFLD  ६頥     
   浪 ஬, ᫥騬  ஬ ⥪饣 .  ᫨
⠪    ,   PRVBLK  ६頥     ⥪饬 .

        PRVREC        ⠪:  PRVREC;
---------
ᠭ:  PRVREC     , 饩 ।騩 浪  .

        REDISP        ⠪:  REDISP;
---------
ᠭ: REDISP ८⮡ࠦ ࠭.  㡨ࠥ  ஭ ᮮ饭.

        REPLACE
---------
 ⠪:  REPLACE menu_application [menu_type [starting_menu [group_name]]]
:
menu_application     ਪ  ணࠬ SQL*Menu,   
                       ⥪  ਪ  ணࠬ.  ࠬ
                       ਪ ࠬ,   ᯥ஢   
                   ࠪ⨪    Default Menu Application.

menu_type         । ⨯ ⮡ࠦ  (BARFULL_SCREENPULL_DOWN).
                   ࠬ  ⨯ ⮡ࠦ       㬮砭
                   (PULL_DOWN). ᫨    । ⨯ , SQL*Forms
                   ᯮ ⨯ PULL_DOWN.

                     ஡  ଠ    ⨯    
                       SQL*Menu User's  Guide and Reference.

starting_menu      ।   ᯮ⥫쭮 , ஥ SQL*Forms
                    ᯮ짮  ⢥ 砫쭮.   ࠬ
                       ᯥ஢   ࠪ⨪ 
                   Starting  Menu Name. ᫨   ।  砫쭮
                   ,  SQL*Menu  ᯮ   ⥬  ,  
                   ᯮ⥫쭮 .

                                   -- 110 --



group_name         । 㯯  (security),  ᯮ
                   SQL*Menu.  ࠬ    । 
                   ࠪ⨪  Menu Security Group. ᫨  
                   ।   㯯,   SQL*Menu  ᯮ ⥪饥
                     짮⥫   । 㯯.

ᠭ: REPLACEMENU   ⥪饥   SQL*Forms ᯥ஢
,          ⨢.  REPLACEMENU  ⠪  
   ᯮᮡ  ⮡ࠦ      㯯  ,  SQL*Menu
ᯮ   । ⮣,    ⮡ࠦ.

᪮ REPLACEMENU         ⨢, SQL*Forms  
   ४뢠  -   ⨢  ࠭. 
ࠧ,      , ᫨ ⨢ ࠭ 뢠 .
:   SQL*Menu  25-3

        RESIZEVIEW    ⠪:  RESIZEVIEW page_number width heigth;
---------
:
page_number       ।    ࠭  ⥪饩 ,      ன
                  ⮨ ।⠢.

width                ਭ ᨬ  ।⠢.

heigh                 ᨬ  ।⠢.

ᠭ:  RESIZEVIEW    ࠧ  ।⠢ ࠭.
砭:
    -     ࠧ ।⠢ ⠪ ࠧ,  ⮡ 
      뫮 , 祬 ࠭,  ன    㦨   ।⠢.  
      砥,  ।⠢ ⮡ࠦ , 室  ।
      ࠭,  SQL*Forms  ⮬᪨ ᤢ  ।⠢  
      쭮   ﭨ.
:  ࠪ⨪ ࠭   10-4
          ᯫ뢠騥 ࠭   13-5

        SCRDOWN       ⠪:  SCRDOWN;
---------
ᠭ: SCRDOWN  ப    ᥩ ⥪饣  
ਡ⥫쭮 80% ⮡ࠦ  .   ⢨  ⮡ࠦ  ,
  뫨  "" ⮡ࠦ  .  ᫨   㦭    
   ,  SQL*Forms ⡨ࠥ    ६ ࠡ  SCRDOWN.

᫥  ப⪨  SCRDOWN  ६頥     砫      
⮡ࠦ      ᫥騬 浪 ஬.

        SCRLEFT       ⠪:  SCRLEFT;
---------
ᠭ: SCRLEFT  ப稢  祭  ⥪饬  ࠢ ਬ୮ 
80% ⮡ࠦ .  ⢨ ⮡ࠦ  ,   뫨  ࠢ
 ⮡ࠦ .

        SCRRIGHT      ⠪:  SCRRIGHT;
---------
ᠭ: SCRRIGHT ப稢  祭  ⥪饬  ࠢ ਬ୮ 
80% ⮡ࠦ .  ⢨ ⮡ࠦ  ,   뫨  ᫥
 ⮡ࠦ .


                                   -- 111 --



        SCRUP         ⠪: SCRUP;
---------
ᠭ: SCRUP   ப    ᥩ ⥪饣  
ਡ⥫쭮 80% ⮡ࠦ  .   ⢨ ⮡ࠦ  ,
  뫨  "" ⮡ࠦ  .

᫥  ப⪨  SCRDOWN  ६頥     砫      
⮡ࠦ      ।騬 浪   ஬.

        SET
              ⠪:  SET variable characteristic [1ATTR_ON  ATTR_OFF];
---------
:  characteristic  ।   祭 ᫥饩 ⠡:

祭          ⢥ ࠪ⨪

AUTO_HELP         Automatic Hint
AUTO_SKIP         Automatic Skip
FIXED_LENGTH      Fixed Length
ENTERABLE         Input Allowed
REQUIRED          Required
ECHO              Echo Input
QUERYABLE         Query Allowed
UPDATEABLE        Update Allowed
UPDATE_NULL       Update if Null
UPPER_CASE        Uppercase

ᠭ: SET  ,  ᯥ஢ ࠪ⨪ .
,    ࠧ    ⮫쪮  ࠪ⨪ .

  㬮砭  SET  ᯮ  ࠬ  ATTR_ON.  ࠬ    ⠢
SQL*Forms    ⠭ ᯥ஢   ࠪ⨪  "on". ᫨  
 ᯮ ࠬ ATTR_OFF, SQL*Forms ⠭ ᯥ஢
ࠪ⨪  "off".

  , ᤥ  㭪樮   SET,  ⢨  
,   㣮 㭪樮   SET       ࠪ⨪
    ᥠ SQL*Forms ( ଠ).

砭: 騥  ࠭祭  ᫮ ਬ,   ᯮ
           SET:
   - SET        ⬥  祭 ࠪ⨪
     Displayed     .

   - SET    ⬥  祭  ࠪ⨪ Input Allowed  
     ⥪饣 .

   - ᫨   ࠪ⨪ 뢠  ᫮ 䫨  㣨
     ࠪ⨪ , ਮ  ᫥ .
:  , ࠪ⨪   12-4

        SHOWMENU      ⠪:  SHOWMENU;
---------
ᠭ: SHOWMENU ⮡ࠦ 饥  SQL*Menu, ᫨   ⮡ࠦ 
                    .




                                   -- 112 --



᪮ SHOWMENU    ⨢, SQL*Forms    ४-
뢠 -  ⨢ ࠭.   ࠧ,  ⨢
࠭   ࠭,  ,      
 ࠭.
:    SQL*Menu   25-3

        SHOWPAGE      ⠪:  SHOWPAGE page_number;
---------

  page_number -  N ࠭ ⥪饩 ,    ⮡ࠧ.

 ᠭ:  SHOWPAGE  ⮡ࠦ  㪠  ࠭  ࠭.
砭:
   - SHOWPAGE  ⨢ ⮡ࠦ ࠭.
   -       ᯮ짮  SHOWPAGE   ⮫쪮   ᯫ뢠  ࠭.
:  ࠭, ࠪ⨪   10-4
          ᯫ뢠騥 ࠭   13-5


        SYNCRONIZE    ⠪:  SYNCRONIZE;
---------
   ᠭ: SYNCRONIZE ᨭ஭ ନ  ७ ﭨ .


        UP            ⠪:  UP;
---------
   ᠭ:  UP ६頥    砫  ⥪饣  , 饩
              ।騩 浪 .

        UPDREC        ⠪:  UPDREC;
---------
   ᠭ:  UPREC  ⠥  ஢  ப     ,
              ᮮ⢥  ⥪饩  .

᫮       ⮡ ᯮ짮  ᯥ/ᯥ  ਣ V2,
ᯥ      ᯮ饬 㭪樮 , 㦭  ᫮,
             㭪樮    뤠 ᯥ.  ⮡
㭪樮-      ।᪠   㭪樮쭮  V2, ᭠砫
       㦭   ஢    ᮮ⢥    
 V2      楤  ࠧ "⠢ 㭪樮  V2  c
              ⠬ V3"   ⥬  ஢  ᯥ ⭮
              楤     ᮮ⢥   -奬, ᠭ   㭪
              "室 ஢" s 21.

              :  室 -奬  21-2
                         ᯥ/ᯥ  ਣ V2   F-43

⠢-     ᫨   ८ࠧ ਣ V2  ਣ V3,
         ᯮ  ᫥  ⠡.  ⮩  ⠡  
㭪樮-      ᮮ⢥⢨    㭪樮    V2  
         V3.
 V2
 -      ,   ᮮ⢥饩  ⭮  楤
⠬ V3    ,   ⠡  ।⠢    PL/SQL,  믮騩
              ⠪   㭪樨   ,    .




                                   -- 113 --



               㭪樮쭮        V3
                V2
              
              ABTQRY                    ABORT_QUERY
              ANCHORVIEW                ANCHOR_VIEW
              BELL                      BELL
              BREAK                     BREAK

              CALL                      CALL
              CALLINPUT                 CALL_INPUT
              CALLQRY                   CALL_QUERY
              COPY                      source := designation  COPY
              CHRMODE                    
              CLRBLK                    CLEAR_BLOCK
              CLREOL                    CLEAR_EOL
              CLRFLD                    CLEAR_FIELD
              CLRFRM                    CLEAR_FORM
              CLRREC                    CLEAR_RECORD
              COMMIT                    COMMIT
              CQUERY                    COUNT_QUERY
              CREREC                    CREATE_RECORD

              DEFAULT                   DEFAULT_VALUE
              DELBACK                    
              DELCHR                     
              DELREC                    DELETE_RECORD
              DERROR                    DISPLAY_ERROR
              DKEYS                     SHOW_KEYS
              DOWN                      DOWN
              DUPFLD                    DUPLICATE_FIELD
              DUPREC                    DUPLICATE_RECORD

              EDITFIELD                 EDIT_FIELD
              ENDSTEP                    
              ENDTRIG                    
              ENTER                     ENTER
              ENTQRY                    ENTER_QUERY
              ERASE                     ERASE
              EXEQRY                    EXECUTE_QUERY
              EXETRG                    EXECUTE_TRIGGER
              EXIT                      EXIT_FORM
              GOBLK                     GO_BLOCK
              GOFLD                     GO_FIELD
              GOREC                     GO_RECORD
              GOSTEP                     
              HELP                      HELP
              HIDEPAGE                  HIDE_PAGE
              HOST                      HOST
              LISTVAL                   LIST_VALUES
              MENU                      BLOCK_MENU
              MESSAGE                   MESSAGE
              MOVEVIEW                  MOVE_VIEW
              MOVLEFT                    
              MOVRIGHT                   
              NEWFRM                    NEW_FORM
              NOOP                      MESSAGE ('FRM-41000: You
                                        pressed an undefined function
                                        key.')

                                   -- 114 --



              NULL                      NULL
              NXTBLK                    NEXT_BLOCK
              NXTFLD                    NEXT_FIELD
              NXTKEY                    NEXT_KEY
              NXTREC                    NEXT_RECORD
              NXTSET                    NEXT_SET

              PAUSE                     PAUSE
              POST                      POST
              PRVBLK                    PREVIOUS_BLOCK
              PRVFLD                    PREVIOUS_FIELD
              PRVREC                    PREVIOUS_REC
              PRINT                     PRINT
              REDISP                    REDISPLAY
              RESIZEVIEW                RESIZE_VIEW
              SCRDOWN                   SCROLL_DOWN
              SCRLEFT                    
              SCRRIGHT                   
              SCRUP                     SCROLL_UP
              SET                       SET_FIELD
              SHOWPAGE                  SHOW_PAGE
              SYNCRONIZE                SYNCRONIZE
              UP                        UP
              UPDREC                    LOCK_RECORD

              :  楤   16-1
                       ⨬ ᭨   B-1

         CASE

  CASE -       SQL*Forms,    ᯮ ⮫쪮
  #EXEMACRO.   ਬ    CASE    ᫮
믮 㭪樮  .

  CASE        ,  ⠪   ᫥ 㭪樮 
    #EXEMACRO.  㭪樮  , 騩  
#EXEMACRO  ᫥   CASE  믮 ᨬ  ⮣, 
 믮   .

,     CASE  뤠  ᯥ, ᫨  ᮤন ⨬
ᨭ⠪  .

⠪: CASE selector IS alternative [alternative]...END CASE
:
selector           祭.
altenative         ᫥ :
                  WHEN choice [,choice]...
                  THEN statement [statement...]
choice             祭 祢 ᫮ OTHERS.
statement          㭪樮  V2   CASE.

  ஡ ଠ樥    祭  (value) 頩    ࠧ
"ࠬ   㭪樮쭮  V2".

ਬ: ।,     믮 ࠧ ⢨   
        ORDERS, 饣    祭    ORDERID.   騩   ਣ
        믮  ⠪ :
#EXEMACRO

                                   -- 115 --



    GOBLK ORDERS;
    CASE ORDERS.ORDID IS
        WHEN ''THEN CLRBLK;
        WHEN OTHERS THEN EXEQRY;
        END CASE;
    GOBLK ITEMS;

:   #EXEMACRO F-11

        ६  蠣 ਣ
---------
   蠣 ਣ   ᯮ짮 ᫥騥 ⨯ ६:
                -  ६
                - ⥬ ६
                - 뫮 ६

     蠣  ਣ    ६  ᯮ
६    ⠪,    ਣ V3,   ᪫祭 ⮣, 
 蠣             뫠      ६ 
ਣ       SQL.   ਣ V2  ६ ᢠ-
                 㭪樮쭮   COPY V2   #COPY.
              :   #COPY  F-10
                         ६  18-2
                        㭪樮  V2, COPY  F-19

⥬     ⥬ ६  蠣 ਣ ᯮ ⠪,
६        ਣ  V3.  蠥  ᯮ짮  
 蠣       ⥬  ६, ਬ塞    ਣ V3, ⠪
ਣ஢      ᫥ ६:

              SYSTEM.BLOCK_STATUS           SYSTEM.LAST_RECORD
              SYSTEM.CURSOR_RECORD          SYSTEM.RECORD_STATUS
              SYSTEM.FORM_STATUS            SYSTEM.TRIGGER_RECORD

              :   ⥬ ६   18-3

        뫮     ६
---------
  뫪    ६    ᢥ  뫪  祭  ,
  ६    ⥬ ६.

SQL*Forms  業  뫮  ६,    믮 
SQL*Forms    㭪樮  V2, ᮤঠ騩 뫪.

        ⠪:   & variable
---------
ਬ  SQL*Forms,  ᯮ饩   뫮 ६:

#COPY &ORDERS.LOCATION GLOBAL.LOCATION

 SQL*Forms  業  뫮  ६,   "뢠"  
ORDERS.LOCATION, ⮡ 㧭  ६, ᮤঠ饩 祭, ஥ 
᪮  GLOBAL.LOCATION.

   - ᫨ ORDERS.LOCATION ᮤন SYSTEN.CURSOR_VALUE,  SQL*Forms ᢠ-
      祭  ⥪饬 ,     ப ᨬ 'SYSTEM.CURSOR_VALUE'



                                   -- 116 --



   - ORDERS.LOCATION  ᮤন  祭  &GLOBAL.STATE, SQL*Forms   
     㣮  ६, ᮤঠ饩 祭,஥ 㦭 ᪮஢, 
     GLOBAL.STATE.  ,     ᫨     ᯮ   뫮
     ६ ४ᨢ,   ࠭஢,    ᮧ
     ᪮ 横 뫮.

   - ᫨  ORDERS.LOCATION  ᮤন 祭 &&GLOBAL.STATE, SQL*Forms
     ᬠਢ   &  ⤥.  砥,  SQL*Forms  
     GLOBAL.STATE   ६, ᮤঠ饩   㣮 ६,
     ᮤঠ饩  祭, ஥ 㦭 ᪮஢.
     :   ⭠ 㭪 NAME_IN  17-10

         ਣ஢ V2
---------
SQL*Forms      ਣ   V2   ⠪    ਣ  V3.  
 ⨯ ਣ ᪠  ६ । ᮡ⨩   ।
浪. ,   ⤥ ਣ஢  SQL*Forms  ਣ
V2  ⠪,   ਣ V3.

 ᪠ ਣ V2, SQL*Forms  믮 蠣 ਣ    
।  浪.  ,       冷,   ஬
SQL*Forms 믮  蠣 ਣ஢   । ࠢ
㭪樮쭮    GOSTEP  ࠪ⨪  蠣 ਣ Success Label
 Failure Label.
:  ਣ, ஢   4-5
           ᯥ/ᯥ  ਣ F-43

          ࠡ ਣ஢
---------
           ⮬ ࠡ ਣ   ᯥ  ᯥ.
success       ਣ 蠥 ᯥ譮, ᫨   蠣 稫
              ᯥ譮  ᫨    ᯥ 蠣  ਢ 
              ਩ 襭  ਣ  .

failure       襭 ਣ  ᯥ, ᫨    蠣
              뢠  ⠫ 訡  ᫨  ᯥ 蠣
              ਢ    ਩  襭     .

 㯥    ᯥ  ਣ  V2   ᮮ⢥騬
१⠬  ਣ  V3.
:  ࠪ⨪ 蠣 ਣ Abort On
          Failure   F-5
            ᯥ  ਣ  4-7
          ࠪ⨪ 蠣 ਣ   F-8

      ਣ   ᯥ宬, ᯥ宬 
ࠡ        ⠫쭮 訡.
蠣
ਣ஢     ᪮ 蠣  ਣ   ᮤঠ  ⮫쪮   ,
              १  ࠡ  蠣  ਣ  祭 १   ࠡ
              ,  ᮤঠ饩    蠣.  ਬ, ᫨ 蠣  ਣ
              ᮤন    SQL    뤠  ᯥ, 蠣
              ਣ  ⠪ 뤠  ᯥ.

  ࠡ  ⤥쭮  蠣  ਣ      ⮣,   ⮨
   蠣   ਣ    맮 짮⥫᪮ 室 ,  SQL 
 SQL*Forms.


                                   -- 117 --



   - SQL*Forms  ࠡ⠥   맮  짮⥫᪮ 室   ਣ
     V2  筮  ⮬,    ࠡ⠥   ਣ V3.

   - SQL*Forms ࠡ⠥  ࠬ SQL  ਣ V2 筮  ⮬, 
      ࠡ⠥   ਣ V3.  , ᪮ SQL*Forms  ஢
     ᨭ⠪ ਣ஢ V2,  SQL*Forms   ⠫쭮
     訡, ᫨  ᮤন ᨭ⠪ 訡.

   - ଠ  ࠡ SQL*Forms   SQL*Forms ᮤন   ࠧ
     "  SQL*Forms".

砭:    १ ࠡ 蠣 ਣ  ⨢-
               ࠪ⨪ 蠣 ਣ Reverse Return Code.

:    ஢  SQL   4-5
           맮 짮⥫᪮ 室  4-6
          ࠪ⨪  蠣  ਣ  Reverse
          Return  Code   F-7

        ⮬ ࠡ  SQL*Forms   ᯥ,
        ᯥ    ⠫쭠  訡.
SQL*Forms

success        SQL*Forms 蠥 ᯥ譮, ᫨  믮
               ࠧ.

failure        SQL*Forms 蠥 ᯥ譮, ᫨   -
              稭    믮  ᫨  ᮤন
              ᨭ⠪ 訡.

fatal error    SQL*Forms 뢠 ⠫ 訡,   ਢ 
              ⮬,  樮 ⥬ ࠡ⠥   (out ofmemory)

          SQL*Forms  ࠡ⠥     #EXEMACRO, 
㭪樮-      믮 㭪樮     ।
       浪.   ,  뢠  㭪樮
 V2           ᫥騥  㭪樮  .

   ⮬  ࠡ  㭪樮쭮   V2   ᯥ,  ᯥ
  ⠫쭠  訡.

success           㭪樮   V2  蠥 ᯥ譮, ᫨ 
                  믮  ࠧ.

failure           㭪樮   V2   蠥 ᯥ譮, ᫨  
                   - 稭    믮.

fatal error       㭪樮     V2  뢠 ⠫   訡,  ᫨
                   ਢ    ⮬,   樮 ⥬
                  ࠡ⠥  .

    ਣ V2 १ ࠡ  #EXEMACRO    १
ࠡ    㭪樮쭮  , ᮤঠ饣  .
   - ᫨   㭪樮      蠥  ᯥ譮, SQL*Forms த
     믮  #EXEMACRO.
   - ᫨  㭪樮    蠥  ᯥ譮, SQL*Forms 믮
     ᫥騥 ⢨:


                                   -- 118 --



       -  ᮮ饭  訡
       - த 믮  #EXEMACRO
       - ਢ  ᯥ 蠣 ਣ

   - ᫨ 㭪樮  뢠 ⠫ 訡, SQL*Forms 믮
     ᫥騥 ⢨:
       -  ᮮ饭  訡
       - ⠭ 믮  #EXEMACRO
       - ਢ  ⠫쭮 蠣 ਣ

        :   #EXEMACRO   F-11


        ᯮ짮  ᯥ/ᯥ  ਣ
ᯥ/        V2,  ⮡   ।   ࠧ      冷,
/ᯥ        SQL*Forms  믮 蠣 ਣ.
ਣ V2

⮡ ᯮ짮  ᯥ/ᯥ, ᯥ ࠪ⨪  蠣
ਣ  Label   蠣  ਣ.  ⥬ । ࠪ⨪
蠣 ਣ  Success  Label   Failure Label.    ⤥쭮 蠣
ਣ  Success Label  Failure Label ।,   蠣  ਣ
SQL*Forms  ࠥ   砥  ᯥ    ᯥ 蠣  ਣ.

ਬ:
।,   㦥 ਣ,  ८। [Previous Field],
  室   ITEMS.ORDERID (ࢮ  ).  㦭, ⮡
 ६⨫   ORDERS.TOTAL (᫥  )  ।-
 ᫮. ᮥ 祢 ਣ   ITEMS.ORDERID
 ᫥騬 ࠪ⨪:
   -  蠣  ᫥騥 ࠪ⨪:
      蠣:              1
     ⪠:                   STEP1
     ⪠ ᯥ:            STEP3
     ⪠ ᯥ:          STEP2
      蠣 ਣ:     #EXEMACRO PRVREC;

   - ன 蠣  ᫥騥 ࠪ⨪:
      蠣:              2
     ⪠:                   STEP2
      蠣 ਣ:     #EXEMACRO PRVBLK; GOFLD
                              ORDERS.TOTAL; ENDTRIG;

   - ன 蠣  ᫥騥 ࠪ⨪:
      蠣:              3
     ⪠:                   STEP3
      蠣 ਣ:     #EXEMACRO PRVFLD;

 ⮬  ਬ, ᫨      믮  ਣ 室  ࢮ
, STEP1 뤠 ᯥ, ਣ 室   STEP2,   ६-
  ᫥  ।饣  (ORDERS.TOTAL). ᫨   ६
믮 ਣ   室  ࢮ ,  STEP1 믮
ᯥ譮, ਣ 室  STEP3,   ६頥  ।饬 .






                                   -- 119 --
