


                                     16
         

   楤 -    ஥  楤  PL/SQL, 
㯭   .   㯠 楤 믮 㭪
SQL*Forms,  ⠪,   뫪   믮  .  ᯮ
㯠  楤,    뢠  ਣ஢  設⢮
㭪権,   뢠   ࠬ     㭪樮  蠬,
   㭪樨,       뢠  ⮫쪮   ਣ஢.

   ᯮ짮   㯠   楤    ஥
ਣ஢,      믮  ᫥騥 :

     -   㬥  ⢮      ᫮   権 
          짮⥫ﬨ;
     -   ࠢ   宦   ਫ,   ⠢   
         ⢮  ।⥫쭮 ।   ;
     -   ᯥ稢   筮    ᫥⥫쭮   ⢨
         ஢  ᯮ짮 ;
     -  ஢ ࠬ SQL*Forms  㬮砭    ᮢ ⨯
        ஢   ஢.

       ᯮ짮  㯠  楤  ⮫쪮    ਣ V3
 楤 ஢ .  ࠧ ⨯  㯠  楤
  ࠭祭    ⨯   ᯮ짮  ⤥ ਣ.

砭:  ᫨  ࠡ⠫  ।騬  ﬨ SQL*Forms,   
            ᯮ짮    㯠 楤 - ""
            (ਬ,  CALL ).

  砥  ᥡ  ᫥騥 ⥬:
     - 㭪樨 SQL*Forms  㯠 楤;
     - । 㯠 楤;
     - ࠭祭 㯠 楤;
     - ࠭祭 㯠 楤.

      祭 ࠡ⪠ 㯠 楤.   祭 
㭪権  V2,      ⠬ 㯠   楤  
।    SQL*Forms   ᯮ  ਣ V2.

⢥ ⥬:   ࠡ⪠ ਣ஢
                     㭪権 V2


         㭪樨  㯠 楤

    㭪樨 SQL*Forms (Run Form)    ᮮ⢥ 㯠
 楤.   㭪樨  ᯮ  믮 ਣࠬ,  ..
  믮 ନ    ⥬ ࠢ 䥩ᮬ
짮⥫,   SQL*Forms.

[Beginning of Line]           [Last Line]
[Cut]                         [Menu]
[Delete Backward]             [Move Left]
[Delete Character]            [Move Right]
[Delete Line]                 [Paste]
[End of Line]                 [Scroll Left]


                                   -- 165 --



[First Line]                  [Scroll Right]
[Insert Line]                 [Search]
[Insert/Replace]

         । 㯠 楤

    ᥪ  ।⠢    㯠 楤  䠢⭮ 浪.
  ᨭ  㯠 楤   ᠭ.

    ⠫쭮  ଠ樨   ࠡ  㯠 楤 (
 砨   ⨪)  ᬮ  ᮮ⢥ -奬  
21, "ࠡ⪠ ᮡ⨩".

⢥ ⥬:   ࠡ⪠ ᮡ⨩

         㬥 㯠 楤

    㯠 楤 ॡ  㬥⮢    ப
ᨬ    .    ⪮ ࠬ ᨭ⠪ 㯠
楤 ।⠢  㬥  ,   뢠,  
   㬥. ਬ, 㯠 楤 GO_FIELD 
㬥,  뢠  field_name.   ᨭ⠪      ⮬,  
㯠  楤  GO_FIELD ॡ 㬥 ⨯ ப ᨬ,
 ᮮ⢥   -     砥    ,  㤠  
  । ࠢ.

     ࠧ ᯮᮡ ᮧ ⨬ 㬥   
ப ᨬ  ᥫ.  ⮡ ࠢ쭮 ᯮ짮 㯠 楤,
  㡥,              㬥 
.     ଠ ⠫  ࠦ,   
  ᯮ짮   ⢥  㬥⮢  㯠 楤  
  ⨯   ப ᨬ,  ᫠.

।⢥    'argument_string'  number
뫪              :

                    'argument_string' ப ᨬ,  㤮⢮
                                      ॡ 㬥.

                    number            楫, ஥ 㤮⢮ ॡ
                                      㬥.

뫪            :field_name
祭 
                     field_name   ,  祭 - ப
                                   ᨬ  楫   ᫮,  ஥
                                   㤮⢮  ॡ   㬥.

뫪            :variable_name  
६          TO_NUMBER(:variable_name)
SQL*Forms     
                    varable_name    ६  SQL*Forms, 
                    祭 - ப ᨬ  楫 ᫮, ஥
                    㤮⢮ ॡ    㬥.

                     ६   ⥬ ६
                     쭮   ६.


                                   -- 166 --



뫪            variable_name
६
PL/SQL           variable_name   쭮 ६ PL/SQL,
                     祭 - ப ᨬ  楫  ᫮,  ஥
                    㤮⢮    ॡ    㬥.

                        "PL/SQL  User's  Guide  and Reference"  
                    ଠ樥      ६ PL/SQL.

ᢥ           NAME_IN(argument_reference)
뫪       
                    argument_reference           뫪 
                  㬥 (  ᢥ 뫪),  ࠦ
                     ६,  祭 - ப ᨬ 
                  楫 ᫮, ஥ 㤮⢮ ॡ 㬥.
                      ᯮ ᢥ 뫪  ᫮ 㬥⮢!

  㬥  ⠪   ᪮஢  樥   ࠦ.
ਬ,    ᯮ짮 뫪    祭 , ஥
뫠  ,  ᮤঠ饥 뫪  ६ SQL*Forms.   
⠪ ᯮ짮 㣨 ᭮ ࠦ PL/SQL  ⨯ ⥭樨
㬥⮢  ப ᨬ  ᫮ ᫮ 㬥⮢.

砭:  㬥, 뢠  field_name,  ।⠢ ᮡ
ப,   砥 䨪   ଥ blockname.fieldname.
 㬥,  뢠 form.name,  ।⠢ ᮡ ப, -
 ᮤন    䠩   , ࠪ୮   ⥬.

⢥ ⥬:    ६
                     㭪 NAME_IN   17-10
                    ⥬ ६

        ABORT_QUERY

⠪:  ABORT_QUERY;
ᠭ:  ABORT_QUERY 뢠 ,     ⥪饬 .
⢥ ⥬:    ABORT_QUERY, -奬

        ANCHOR_VIEW

⠪:   ANCHOR_VIEW(page_number,x_coordinate,y_coordinate);
:
page_number         । 楫 ᫮  ࠭    ⥪饩
                    ଥ,    ன    㠫쭠 ⠡.

x_coordinate        । 楫᫥ न X  ࠭, 㤠 
                      孨  㣮 㠫쭮 ⠡.

Y_coordinate        । 楫᫥ न   Y     ࠭,
                    㤠         孨       㣮
                    㠫쭮 ⠡.

ᠭ:  ANCHOR_VIEW  ६頥   㠫   ⠡ ࠭   
            ࠭.   楤 ᯮ   ⮯-
            㠫쭮 ⠡  ࠭.




                                   -- 167 --



砭:
     -     ६  㠫  ⠡  ⠪, ⮡ -
               ࠭.  ६饭 뢠
       訡.
     -   ᯮ짮  ANCHOR_VIEW  ⮫쪮     ᯫ뢠 .
⢥ ⥬:   ANCHOR_VIEW, -奬
                    MOVE_VIEW, 㯠 楤  16-20
                    ࠭, ࠪ⨪
                    "ᯫ뢠騥" ࠭

           BELL

⠪: BELL;
ᠭ:  BELL ⠢ ନ 뤠 㪮 ᨣ
              ७ ﭨ .
⢥ ⥬:    BELL, -奬

           BLOCK_MENU

⠪: BLOCK_MENU;
ᠭ:  BLOCK_MENU 뢮    ਭ ᪨ .  ᫨
             ࠢ 롮, BLOCK_MENU । ࠢ 
           ᮮ⢥騩 .
⢥ ⥬:    BLOCK_MENU, -奬

            BREAK

⠪:  BREAK;
ᠭ: ᫨ ⥪ ଠ  饭    ०  ⫠, BREAK ⠭-
            믮    뢮  Debug Mode Options, ᫨ 
          - 祣  .
⢥ ⥬:   BREAK, -奬
                    ।⢠ ⫠

           CALL

⠪: CALL (form_name [, { HIDE | NO_HIDE }
                        [, { REPLACE | NO_REPLACE } ] ] );

ᠭ: CALL ᪠ 㪠 , ⠢ ஦  ⨢.
SQL*Forms ᪠ 뢠    ⥬    ﬨ SQL*Forms(Run Form),
    ஦饩  .   뢠 ଠ 蠥 -  㭪樨
EXIT       १   ࠢ쭮   । ࠢ  - ࠡ⪠
頥  ஦   , 㤠 室 맮 CALL.

 㬮砭 CALL ᯮ ࠬ  HIDE    NO_REPLACE.
ࠬ  HIDE ⠢ SQL*Forms  뢠    ࠭  ।
ᮢ  뢠  .   ᫨    ᯮ   ࠬ   NO_HIDE,
SQL*Forms  ࠥ 뢠   ।  ᮢ  뢠 .
 砥,  ᫨  뢠   ࠬ஬ NO_HIDE  
࠭  뢠    ࠭, 뢠 ଠ 뤠
䮭.

ࠬ  NO_REPLACE   ⠢   SQL*Forms   ন ࠪ⨪
Default  Menu  Application 뢠饩 .  ᫨  ᯮ  ࠬ
REPLACE,  SQL*Forms   ࠪ⨪  Default Menu Application
뢠饩   ࠪ⨪ Default Menu Application 뢠 .


                                   -- 168 --



   뢠  ,  SQL*Forms  ⠭   ࠭
뢠  .     㭪  CLEAR_FORM 뢠  ⪠    ⥪饩
뢠  ଥ,  SQL*Forms 頥    ࠭  ந
    ࠭.
⢥ ⥬:  CALL, -奬 ࠪ⨪ 
                   Default Menu Application
                   ࠪ⨪ ࠭ Page Size    10-6
                   窨 ࠭  맮     3-18

            CALL_INPUT

⠪:  CALL_INPUT;

ᠭ:   CALL_INPUT   ਭ      ࠡ뢠    㭪樮
  .   CALL_INPUT 蠥,  ࠡ⪠ த 
ଥ    窨,   뢠 CALL_INPUT.

砭:  CALL_INPUT  祭    SQL*Forms ᨨ 3.0  ᮢ⨬  
।騬  ﬨ.  ௮  Oracle ४    ᯮ짮
 㯠 楤   ਫ.
⢥ ⥬:    CALL_INPUT, -奬

           CALL_QUERY

⠪: CALL_QUERY (form_name [, { HIDE | NO_HIDE }
                              [, { REPLACE | NO_REPLACE } ] ] );

ᠭ:  CALL_QUERY  ᪠  㪠  ,  ⠢ ஦
 ⨢.  SQL*Forms ᪠ 뢠    ⥬    ﬨ
SQL*Forms(Run  Form),       ஦饩        ⮫쪮 
ᮢ.   뢠  ଠ  蠥  -    㭪樨  EXIT    
१  ࠢ쭮  ।  ࠢ  -  ࠡ⪠ 頥 
஦     ,  㤠  室 맮 CALL_QUERY.

 㬮砭   CALL_QUERY   ᯮ  ࠬ  HIDE   NO_REPLACE.
ࠬ  HIDE  ⠢  SQL*Forms   뢠   ࠭
। ᮢ 뢠 .

᫨   ᯮ ࠬ NO_HIDE,  SQL*Forms  ࠥ 뢠 
।  ᮢ  뢠  .   砥,  ᫨  뢠
  ࠬ஬ NO_HIDE    ࠭  뢠  
 ࠭, 뢠 ଠ 뤠 䮭.

ࠬ  NO_REPLACE   ⠢   SQL*Forms   ন ࠪ⨪
Default  Menu  Application 뢠饩 .  ᫨  ᯮ  ࠬ
REPLACE,  SQL*Forms   ࠪ⨪  Default Menu Application
뢠饩   ࠪ⨪ Default Menu Application 뢠 .

      뢠  ,  SQL*Forms  ⠭   ࠭
뢠  .     㭪  CLEAR_FORM 뢠  ⪠    ⥪饩
뢠  ଥ,  SQL*Forms 頥    ࠭  ந
    ࠭.

⢥ ⥬:  CALL_QUERY, -奬 ࠪ⨪ 
                   Default Menu Application ࠪ⨪ ࠭ Page Size
                   窨 ࠭  맮     3-18



                                   -- 169 --



        CLEAR_BLOCK

⠪:
    CLEAR_BLOCK [( ASK_COMMIT  | DO_COMMIT | NO_COMMIT | NO_VALIDATE ) ];


ᠭ: CLEAR_BLOCK 頥 ⥪騩 .  ᫨  ⮬   ,
  뫨 ᫠  ࠭ ( posted )    ࠭ ( commited ),
  CLEAR_BLOCK   ࠬ஢,   㪠:

ࠬ                      ⢨

 ࠬ஢      SQL*Forms ।  ࠭  
                    ࠡ    CLEAR_BLOCK.

ASK_COMMIT          SQL*Forms ।  ࠭  
                    ࠡ    CLEAR_BLOCK.

DO_COMMIT           SQL*Forms  , 믮 ࠭ 
                       ⥪騩    .

NO_COMMIT           SQL*Forms       ⥪騩 
                     믮   ࠭   .

NO_VALIDATE         SQL*Forms  ⥪騩     ஢
                        ࠭   .
⢥ ⥬:    CLEAR_BLOCK, -奬

           CLEAR_EOL

⠪: CLEAR_EOL;

ᠭ:  CLEAR_EOL 頥 ⥪饥 祭    ⥪饩 樨 
            ப,  .
⢥ ⥬:    CLEAR_EOL, -奬

           CLEAR_FIELD
⠪: CLEAR_FIELD;

ᠭ:  CLEAR_FIELD  ࠥ  祭 ⥪饣  - ᨬ 
           ⥪饩 樨    -    祭   NULL.
⢥ ⥬:    CLEAR_FIELD, -奬


        CLEAR_FORM

⠪:
         CLEAR_FORM [ ( ASK_COMMIT  | DO_COMMIT | NO_COMMIT | NO_VALIDATE ) ];

ᠭ: CLEAR_FORM 頥 ⥪ .  ᫨  ⮩ ଥ  ,
  뫨 ᫠  ࠭ (posted)   ࠭ (committed),
  CLEAR_FORM   ࠬ஢,   㪠:

ࠬ            ⢨

 ࠬ஢    SQL*Forms ।  ࠭  
                  ࠡ    CLEAR_FORM.


                                   -- 170 --



ASK_COMMIT        SQL*Forms ।  ࠭   ࠡ
                     CLEAR_FORM.

DO_COMMIT         SQL*Forms  ,   믮 ࠭ 
                     ⥪    .

NO_COMMIT         SQL*Forms       ⥪
                    믮   ࠭   .

NO_VALIDATE       SQL*Forms  ⥪     ஢
                             ࠭   .

   CLEAR_FORM   ⬥  ,    뫨 ࠭, 
⥪ ଠ ࠡ뢠    ६ ⥪饩  ᨨ SQL*Forms(Run  Form).
᫨  ⥪  ଠ 뢠  㣨  ,   ᮤঠ  ᫠
 ࠭ , CLEAR_FORM ⢥࣠   .

砭: ᫨  ᯮ  ROLLBACK  PL/SQL    
  楤  ஢  ,   SQL*Forms    㯠
楤 CLEAR_FORM   ࠬ஢.

⢥ ⥬:   CLEAR_FORM, -奬
                    窨 ࠭  ᯮ짮   楤 POST

          CLEAR_RECORD
⠪:CLEAR_RECORD;

ᠭ: CLEAR_RECORD 頥 ⥪   .  ᫨   
    ⮬ ,  SQL*Forms 뢠   ୮  .

⢥ ⥬:    CLEAR_RECORD, -奬


           COMMIT_FORM
⠪: COMMIT_FORM;

ᠭ:  COMMIT_FORM      ᮮ⢥ᢨ  묨  ଥ.
SQL*Forms 砫  .  ᫨  ,  㦭 -
  ,       SQL*Forms 뫠 室 㤠,
⠢   ४஢    ࠭     .
   楤   COMMIT   蠥,    SQL*Forms ᢮ 
஢  ⠡    ப,   ᤥ ஬.

᫨  ᫠ -   ࠭       ६   ⥪饩
ᨨ  SQL*Forms(Run  Form),   COMMIT_FORM ࠭     .

砭: ᫨  ᯮ  COMMIT   PL/SQL     
             楤  ஢  ,   SQL*Forms   
           㯠 楤 COMMIT_FORM.
⢥ ⥬:   COMMIT_FORM, -奬
                    POST, 㯠 楤

          COPY
⠪:COPY(value_string,field_name);





                                   -- 171 --



ᠭ: COPY 뢠 㪠 祭    .  COPY ᯮ,  
⭮,    祭  ,   ஥ 뫠  
㯠  楤  NAME_IN.   ᢮⢮    ⮬,   
  ᯮ짮 ⠭ ᨭ⠪ PL/SQL  ⠭ ,  
஬    뫪, ࠢ । 祭.

⢥ ⥬:    COPY, -奬

           COUNT_QUERY

⠪: COUNT_QUERY;
ᠭ:  COUNT_QUERY । ᫮ ப,     
⥪饣  .  ᫨     ,   㦭  ࠭  
,   SQL*Forms   ᪠뢠   ⮬  ࠡ⪥ COUNT_QUERY.
⢥ ⥬:    COUNT_QUERY, -奬

           CREATE_RECORD
⠪: CREATE_RECORD;
ᠭ:  CREATE_RECORD ᮧ    ⥪饬  ᫥ ⥪饩
.  ⥬ SQL*Forms ३    .
⢥ ⥬:    CREATE_RECORD, -奬

           DEFAULT_VALUE
⠪: DEFAULT_VALUE(value_string,variable_name);

ᠭ:  DEFAULT_VALUE   㪠 祭  㪠 ६,
᫨  ⥪饥  祭 ६ - NULL,  - DEFAULT_VALUE  
祣.  ( ⮬        㯠 楤 ࠡ⠥ 筮
㯠 楤 COPY   NULL.)  ᫨ ६ 
।  쭮  ६,  SQL*Forms ᮧ  ६.

砭:  楤 DEFAULT_VALUE   믮 㭪樨,
           筮 ࠪ⨪  Default Value.

⢥ ⥬:  DEFAULT_VALUE, -奬 ࠪ⨪  Default
                   Value   12-10

           DELETE_RECORD
⠪: DELETE_RECORD;

ᠭ:  DELETE_RECORD  㤠  ⥪    .  ᫨ 
ᮮ⢥ ப  ,  SQL*Forms    । 㤠  
砥   㤠.  ᫨      ,  SQL*Forms
뢠     ୮    室.
⢥ ⥬:  DELETE_RECORD, -奬

           DISPLAY_ERROR
⠪: DISPLAY_ERROR;

ᠭ:  DISPLAY_ERROR  뢮 ࠭ Display Error,  ᫨ 
ॣ஢ 訡.       㭪樮
,  SQL*Forms ᮢ뢠 .
⢥ ⥬:    DISPLAY_ERROR, -奬

           DISPLAY_FIELD
⠪: DISPLAY_FIELD(variable_name,display_attribute_name);



                                   -- 172 --



ᠭ:  DISPLAY_FIELD    ᯮᮡ,       
ନ,  稢 㪠 ਡ 뢮 ⮬ .   
ਡ⮢ 뢮 ࠭    Oracle*Terminal,   ன ଠ ᪠-
. ᫨  ।    ਡ  뢮,  SQL*Forms 砥
ਡ  뢮    㬮砭      ,   । 
⥪饩 .

  뫠     ⥪饩 ଥ.  ⨬,  DISPLAY_FIELD
  ⮫쪮    ࠭ 뢮 ⥪饣  ;  㣨
 㪠   楤  .  砥,  ᫨ 
।   뢮    ,  ஥   ᭮
, DISPLAY_FIELD ⮫쪮   ⮣ , ஥ ਭ
⥪饩  .

쮥 , ᤥ  㯠 楤ன DISPLAY_FIELD, ⢨⥫-
    ,     㣠 DISPLAY_FIELD    ⮬  
⥪ ଠ  .
⢥ ⥬:   DISPLAY_FIELD, -奬
                    Oracle*Terminal

          DOWN
⠪:DOWN;

ᠭ: DOWN । ࠢ  ।⠢ ⥪饣     
 ᫥騬  訬 ᫥⥫ ஬.  ᫨ 室,
SQL*Forms 뢠  ࠭   , ன । ࠢ. ᫨
SQL*Forms  ᮧ   ,   ன   ।  ࠢ,   DOWN
६頥    ࢮ        ⮩   .
⢥ ⥬:    DOWN, -奬

           DUPLICATE_FIELD
⠪: DUPLICATE_FIELD;

ᠭ:  DUPLICATE_FIELD  砥  ⥪饬      祭, 
               ।饩 .
⢥ ⥬:    DUPLICATE_FIELD, -奬

          DUPLICATE_RECORD
⠪:DUPLICATE_RECORD;

ᠭ: DUPLICATE_RECORD  祭      ।-
騬 訬 ஬  ᮮ⢥騥  ⥪饩 .  
 㦥  ᮮ⢥⢮  ப  ,  -  訡.
⢥ ⥬:  DUPLICATE_RECORD, -奬

            EDIT_FIELD
⠪:  EDIT_FIELD [ (x_coordinate,y_coordinate,width,height) ];
:
x_coordinate  । 楫 ᫮ न X    ࠭,  㤠 
                 孨    㣮 ᯫ뢠饣 ।
              .

y_coordinate  । 楫 ᫮ न Y    ࠭,  㤠  
                孨    㣮 ᯫ뢠饣 ।
              .

width         । 楫 ᫮  ਭ  ᨬ ᯫ뢠饣
              । .

                                   -- 173 --



height        । 楫 ᫮    ᨬ ᯫ뢠饣
              । .

ᠭ: EDIT_FIELD 뢠  ।    SQL*Forms(Run Form) 
          ⥪饣   ॢ   ० Edit.

    ᯮ짮   ࠬ EDIT_FIELD  ।
  ࠭  ࠧ஢ ᯫ뢠饣 ,     易  ।
.  ᫨   ᯮ  ࠬ,  SQL*Forms 뢠 ।
    ࠬࠬ न  ࠧ஢  㬮砭.
⢥ ⥬:   EDIT_FIELD, -奬
                     

           ENTER
⠪: ENTER;

ᠭ:  ENTER        ⥪饬  ஢塞 㫥.
⢥ ⥬:   ENTER, -奬
                     ஢ન

              ENTER_QUERY
⠪:    ENTER_QUERY [ ( { ALL_RECORDS [, FOR_UPDATE ] | FOR_UPDATE })];

ᠭ:  ENTER_QUERY     ᨬ   ᯮ㥬
          ࠬ஢.

     - ENTER_QUERY;  蠥  ࠡ   ⥪騬     ॢ 
        ० Enter Query. ᫨  ⮬     ,  㦭
       ࠭,  SQL*Forms   ।    ᤥ      ६
       ᮡ   ENTER_QUERY.


     - ENTER_QUERY(ALL_RECORDS); 믮   ⢨,   ENTER_QUERY,
        ᪫祭 ⮣,      뢠 EXECUTE_QUERY,   SQL*Forms
       뢠      ࠭ .

     - ENTER_QUERY(FOR_UPDATE); 믮   ⢨,   ENTER_QUERY,
        ᪫祭 ⮣,       뢠 EXECUTE_QUERY, SQL*Forms
       ⠥   ஢  ࠭ .

     - ENTER_QUERY(ALL_RECORDS,FOR_UPDATE); 믮     ⢨,  
   ENTER_QUERY,  ᪫祭 ⮣,       뢠  EXECUTE_QUERY,
   SQL*Forms  ⠥     ஢    ࠭   
      뢠 .

砭:  ௮  Oracle  ४  ᯮ짮 ࠬ
ALL_RECORDS  FOR_UPDATE  祭  ஦.  맮 祭   讣   ᫠
ப    ॡ  让 প.  ६  ஢
讣  ᫠  ப ॡ  ᮢ.
⢥ ⥬:   ENTER_QUERY, -奬
                    EXECUTE_QUERY, -奬

          ERASE
⠪:ERASE(global_variable_name);

ᠭ: ERASE 㤠 㪠  ६ ⠪,     
       ,  ᢮  , 易  쭮 ६.
⢥ ⥬:    ERASE, -奬

                                   -- 174 --



           EXECUTE_QUERY
⠪: EXECUTE_QUERY [( {ALL_RECORDS [, FOR_UPDATE ] | FOR_UPDATE} )];

ᠭ:  EXECUTE_QUERY   ᨬ   ᯮ㥬
ࠬ஢.

     -  EXECUTE_QUERY;  蠥  ࠡ  ⥪騬 ,   뢠
     뢮 ஥  ᫮  ࠭   ᥩ.  ᫨    ⮬
     ,   㦭  ࠭,  SQL*Forms ।
      ᤥ   ६ ࠡ⪨ EXECUTE_QUERY.

     -  EXECUTE_QUERY(ALL_RECORDS);    믮         ⢨,   
   EXECUTE_QUERY,   ᪫祭  ⮣,    SQL*Forms 뢠 
   ࠭ .

     - EXECUTE_QUERY(FOR_UPDATE); 믮   ⢨,      
   EXECUTE_QUERY,     ᪫祭  ⮣,      SQL*Forms  ⠥
      ஢      ࠭ .

     - EXECUTE_QUERY(ALL_RECORDS,FOR_UPDATE);  믮     ⢨,
     EXECUTE_QUERY,  ᪫祭 ⮣,    SQL*Forms ⠥
     ஢     ࠭   뢠 .

砭:  ௮  Oracle  ४  ᯮ짮 ࠬ
ALL_RECORDS  FOR_UPDATE  祭  ஦.  맮 祭   讣   ᫠
ப    ॡ  让 প.  ६  ஢
讣  ᫠  ப ॡ  ᮢ.
⢥ ⥬:    EXECUTE_QUERY, -奬

           EXECUTE_TRIGGER
⠪: EXECUTE_TRIGGER(trigger_name);

ᠭ:  EXECUTE_TRIGGER  믮  㪠  ਣ  , 
           짮⥫.
⢥ ⥬:    EXECUTE_TRIGGER, -奬


          EXIT_FORM
⠪:
          EXIT_FORM [ ( ASK_COMMIT  | DO_COMMIT | NO_COMMIT | NO_VALIDATE ) ];

ᠭ: EXIT_FORM 蠥 㭪 CALL_INPUT  ६  ࠡ.   
㣨 ⥪  EXIT_FORM   । ࠢ "" .  ᫨  ⥪饩
ଥ  ,    뫨  ᫠    ࠭ (posted) 
࠭ (committed),   EXIT_FORM   ࠬ஢, 
 㪠:
ࠬ                     ⢨

 ࠬ஢    SQL*Forms ।  ࠭  
                  ࠡ    EXIT_FORM.

ASK_COMMIT        SQL*Forms ।  ࠭  
                  ࠡ    EXIT_FORM.

DO_COMMIT         SQL*Forms  ,   믮 ࠭
                      멤  ⥪饩   
                    .


                                   -- 175 --



NO_COMMIT         SQL*Forms      멤  ⥪饩
                      믮 ࠭     .


NO_VALIDATE       SQL*Forms 멤  ⥪饩      ஢
                          ࠭   .
⢥ ⥬:    EXIT_FORM, -奬


           FIRST_RECORD
⠪: FIRST_RECORD;

ᠭ:  FIRST_RECORD  । ࠢ ࢮ   ᯨ᪥ 
            .
⢥ ⥬:    FIRST_RECORD, -奬

          GO_BLOCK
⠪:GO_BLOCK(block_name);

ᠭ: GO_BLOCK  ।  ࠢ  㪠  .
᫨    室,  訡.
⢥ ⥬:    GO_BLOCK, -奬

          GO_FIELD
⠪:GO_FIELD(field_name);
ᠭ: GO_FIELD । ࠢ  㪠 .
⢥ ⥬:    GO_FIELD, -奬

           GO_RECORD
⠪: GO_RECORD(record_number);

 record_number । 楫 祭,  ஥ PL/SQL 
                   .    ᯮ짮 祭 ⨯

     TO_NUMBER(:SYSTEM.TRIGGER_RECORD+8).

ᠭ:  GO_RECORD  ᯮ  ᫥⥫   ।
           ࠢ  㪠 .

砭:      ᯮ짮  ⥬   ६
            SYSTEM.CURSOR_RECORD  SYSTEM.TRIGGER_RECORD  ।
            ᫥⥫쭮  .
⢥ ⥬:   GO_RECORD, -奬
                    SYSTEM.CURSOR_RECORD
                    SYSTEM.TRIGGER_RECORD   18-12

           HELP
⠪: HELP;

ᠭ:  HELP 뤠 饥 ᮮ饭  ⥪饬   ப
ᮮ饭.  ᫨ ⠪ ᮮ饭 㦥  뢥,  HELP 뢮 ⠫
help-࠭   .
⢥ ⥬:    HELP, -奬


        HIDE_MENU



                                   -- 176 --



⠪:    HIDE_MENU;
ᠭ:   HIDE_MENU   ⠢   ⥪饥    SQL*Menu 祧,  ᫨
    뫮 뢥   ࠭, 뢠     뢮 ,
 뫠  ⨬ .   ᭮ 뢥  ࠭  맮
㯠 楤    SH0W_MENU            ⨨ ஬
㭪樮쭮  [Menu].
⢥ ⥬:    HIDE_MENU, -奬
                     SHOW_MENU, 㯠 楤  16-27
                       SQL*Menu


        HIDE_PAGE

⠪:    HIDE_PAGE(page_number);

    page_number - 楫᫥    ࠭    ⥪饩 ଥ, 
                    "".

ᠭ: HIDE_PAGE ⠢ 㪠 ࠭ 祧  ࠭.
砭:
     -            楤   ⥪饩 ࠭楩 .
     -   ᯮ짮 HIDE_PAGE ⮫쪮   ᯫ뢠 ࠭.

⢥ ⥬:   HIDE_PAGE, -奬
                    ࠭, ࠪ⨪
                    ᯫ뢠騥 ࠭



        HOST

⠪: HOST(system_command_string [,NO_SCREEN] );

ᠭ:  HOST  믮  㪠    .  ᫨  ᯮ
ࠬ NO_SCREEN, SQL*Forms  頥 ࠭   訢  
室  .

⢥ ⥬:    HOST, -奬


        LAST_RECORD

⠪:    LAST_RECORD;

ᠭ:  LAST_RECORD  ।  ࠢ     ᫥   ᯨ᪥
 ᥩ.  ᫨    , SQL*Forms 뢠  ⠢訥
࠭      ᯨ᮪  ᥩ.

⢥ ⥬:    LAST_RECORD, -奬


        LIST_VALUES

⠪:    LIST_VALUES(NO_RESTRICT  | RESTRICT);

ᠭ:  LIST_VALUES  뢮 ᯨ᮪ 祭  ⥪饣 .  ᮪
祭 ⠥  ࠭    ,       
[Exit/Cancel]   롥 祭  .

                                   -- 177 --



 㬮砭 LIST_VALUES  ᯮ  ࠬ  NO_RESTRICT, 
⠢   SQL*Forms    ᯮ짮  ᢮⢮ ⮬᪮ ᪠ 
襭.  ᫨    ᯮ ࠬ RESTRICT, SQL*Forms ᯮ
 ᢮⢮.


        ⮬᪨   襭

         ᯮ,   ᯨ᮪  祭 ᬠਢ
⥪饥 祭   祭 ᪠.  ,   ᫨ 
  [List]    ,  ஥  ᯨ᮪ 祭, SQL*Forms ஢,
ᮤন   祭.  ᫨  ᮤন ஥ 祭,  SQL*Forms
⮬᪨ ᯮ    祭  ⠪,    ᫨     
 祭   ᪠ ᯨ᪠ 祭   [List]  㦥 ᯨ᪠.

᫨ 祭    㦨  ᯨ᮪      祭, SQL*Forms 
뤠 ⠪ ᯨ᮪,   ⮬᪨ 뢠 ࠢ쭮 祭  .

⢥ ⥬:    LIST_VALUES, -奬


        LOCK_RECORD

⠪:    LOCK_RECORD;

ᠭ: LOCK_RECORD ⠥ ஢  ப    , 
          ᮮ⢥ ⥪饩 .
⢥ ⥬:    LOCK_RECORD



        MESSAGE

⠪:    MESSAGE(message_string);

ᠭ:   MESSAGE   뢮   㪠   ⥪    ப ᮮ饭.
  뢮 ᮮ饭     78  ᨬ.  ᫨ 㦭 뢥
   ᮮ饭,     ⮩ ப ( ਬ,
Record isn''t available. ).

⢥ ⥬:    MESSAGE, -奬


        MOVE_VIEW

⠪: MOVE_VIEW(page_number,X_coordinate,Y_coordinate);
:
page_number         । 楫᫥  ࠭  ⥪饩  ଥ,
                     ⭮   ⭮  㠫쭮   ⠡.

X_coordinate        । 楫 ᫮ न X  ࠭, 㤠 
                      孨  㣮 㠫쭮 ⠡.

Y_coordinate        । 楫 ᫮ न Y  ࠭, 㤠 
                      孨  㣮 㠫쭮 ⠡.




                                   -- 178 --



ᠭ:  MOVE_VIEW ६頥 㠫 ⠡ ࠭   
⮩  ࠭.    楤  䥪⨢    ,      
࠭       㠫쭮 ⠡.   㠫쭮
⠡   ࠭  .

砭:
     -       ⠪ ६ 㠫 ⠡,   ⮡  
               ࠭.      ६饭 맮 訡.
     -   MOVE_VIEW   ᯮ  ⮫쪮    ᯫ뢠   ࠭.

⢥ ⥬:   ANCHOR_VIEW, 㯠 楤  16-5
                    MOVE_VIEW, -奬
                    ࠭, ࠪ⨪
                    ᯫ뢠騥 ࠭


        NEW_FORM

⠪:  NEW_FORM(form_name);

ᠭ: NEW_FORM  蠥  ࠡ    ⥪饩  ମ   室   㪠-
 .  뢠 ଠ 蠥  ଠ-த⥫.  ᫨ 뢠
ଠ  ᠬ  뢠     ᮪ ஢, SQL*Forms ࠭
맮  ᮪  ஢  ⨢    ࠪ    맮 
.  SQL*Forms ᢮  (⨯ ஢  ),  뫠 
襭 ମ.


SQL*Forms   ᪠           ⥬    ﬨ SQL*Forms(Run
Form),           -த⥫.    ᫨ ଠ-த⥫  ᠬ  뫠
뢠,  SQL*Forms ᪠      ⥬    ࠬࠬ  (
ਬ,  HIDE   NO_REPLACE ),    -த⥫.

⢥ ⥬:   CALL, 㯠 楤
                    NEW_FORM, -奬


        NEXT_BLOCK

⠪:    NEXT_BLOCK;

ᠭ: NEXT_BLOCK । ࠢ  ⥪饣   믮塞 
 ᫥騬  訬  ᫥⥫ ஬.   ᫨  ⠪   ,
NEXT_BLOCK  । ࠢ  믮塞    ᫥-
⥫ ஬.   ᫨    ⠪   , NEXT_BLOCK । ࠢ
 ⥪騩 .

⢥ ⥬:    NEXT_BLOCK, -奬


        NEXT_FIELD

⠪:    NEXT_FIELD;

ᠭ:  NEXT_FIELD । ࠢ  ⥪饣     
᫥騬  訬  ᫥⥫  ஬.  ᫨  ⠪   ,



                                   -- 179 --



NEXT_FIELD । ࠢ     ᫥⥫
஬.  ᫨     ⠪ , NEXT_FIELD । ࠢ ⥪饬
.

᫨  㫥  ஢ન  ,  NEXT_FIELD      
᫥⥫묨  ࠬ  訬,  祬   ⥪饣 ,  訬,
祬   .

⢥ ⥬:    NEXT_FIELD, -奬


        NEXT_KEY

⠪:    NEXT_KEY;

ᠭ:  NEXT_KEY  ।  ࠢ      ࢨ筮 
  ᫥騬  ᫥⥫  ஬, 訬  ⥪饣 . ᫨
⠪  , NEXT_KEY ।  ࠢ       ࢨ筮
    ᫥⥫   ஬.   ᫨     ࢨ筮
  ⥪饬 ,  訡.

᫨ 㫥 ஢ન  ,  NEXT_KEY     ᫥-
⥫묨 ࠬ 訬,  祬   ⥪饣 ,  訬, 祬  -
 .

⢥ ⥬:  NEXT_KEY, -奬
                   ࢨ , ࠪ⨪   12-19


        NEXT_RECORD

⠪:    NEXT_RECORD;

ᠭ:  NEXT_RECORD  ।  ࠢ       ᫥騬
᫥⥫ ஬,  訬,  祬  ⥪饩 .  ᫨  ⠪
  ,  SQL*Forms  맢  ᮧ   .
᫨  ⥪    - , NEXT_RECORD 뤠 訡.

⢥ ⥬:    NEXT_RECORD, -奬


        NEXT_SET

⠪:    NEXT_SET;

ᠭ:  NEXT_SET  뢠   㯯 ᥩ    ।
ࠢ     맢  .  NEXT_SET ᯥ譮  믮
⮫쪮  ⮣,      ⥪饬 .
⢥ ⥬:    NEXT_SET, -奬


        PAUSE

⠪:    PAUSE;
ᠭ: PAUSE ਮ⠭ ࠡ      ,    
  㭪樮 . PAUSE  뢮 ।०饥
ᮮ饭.
⢥ ⥬:    PAUSE, -奬

                                   -- 180 --




        POST

⠪:    POST;

ᠭ: POST 뢠     ,   믮-   樨
commit  .  SQL*Forms 砫 ஢ .  ᫨  ,
 㦭   ,            ଥ SQL*Forms
뢠 㤠, ⠢  ४஢  .

 ,   뢠  , ࠭    ᫥饩
楤 COMMIT_FORM,   믮   ६  ⥪饩 ᨨ
SQL*Forms(Run Form).     ⢥࣠  ᫥饩 楤
CLEAR_FORM.

⢥ ⥬: COMMIT_FORM, 㯠 楤   16-10
               POST, -奬
               窨 ࠭


        PREVIOUS_BLOCK

⠪:    PREVIOUS_BLOCK;

oᠭ: PREVIOUS_BLOCK । ࠢ   믮塞   ᨬ-
 ᫥⥫ ஬,  訬,  祬  ⥪饣 .  ᫨
⠪  ,  PREVIOUS_BLOCK ।  ࠢ    믮塞 
  ᨬ ᫥⥫  ஬.   ᫨        ⠪ ,
PREVIOUS_BLOCK । ࠢ  ⥪騩 .

⢥ ⥬:    PREVIOUS_BLOCK, -奬



        PREVIOUS_FIELD

⠪:    PREVIOUS_FIELD;

ᠭ:  PREVIOUS_FIELD  । ࠢ      ᫥騬
᫥⥫  ஬,   訬    ⥪饣 . ᫨ ⠪ 
, PREVIOUS_FIELD । ࠢ          ᨬ
᫥⥫ ஬.  ᫨      ⠪  ,   NEXT_FIELD  ।
ࠢ ⥪饬 .

⢥ ⥬:    PREVIOUS_BLOCK, -奬



        PREVIOUS_RECORD

⠪:    PREVIOUS_RECORD;

ᠭ:  PREVIOUS_RECORD  ।  ࠢ    ᨬ
           ᫥⥫ ஬,  訬,  祬   ⥪饩 .
⢥ ⥬:    PREVIOUS_RECORD, -奬


        PRINT

                                   -- 181 --



⠪:  PRINT;

ᠭ:  PRINT  뢠      ࠭   䠩.  SQL*Forms
訢    ࠭  ,  䠩, 㤠 뢠,
 㦭  뫠 䠩  ⥬ ਭ.

⢥ ⥬:    PRINT, -奬


        REDISPLAY

⠪:    REDISPLAY;

ᠭ: REDISPLAY ᮢ뢠 ࠭.  㭨⮦  ஭
          ⥬ ᮮ饭.
⢥ ⥬:    REDISPLAY, -奬


        REPLACE_MENU
⠪:
          REPLACE_MENU (menu_application_name
          [, {BAR | FULL_SCREEN | PULL_DOWN}
          [,starting_menu_name[,group_name]]]);

:

menu_               । ਫ SQL*Menu, -
application_        ஥  ⥪饥 ਫ -
name                .  ࠬ  ਫ,  ।  
                    ࠪ⨪    Default Menu Application.

BAR |               । ⨯ 뢮 .  -
FULL_SCREEN |       ࠬ  ⨯   㬮-
PULL_DOWN            ( PULL_DOWN ). ᫨   㪠 ⨯ , SQL*Forms
                    㤥   ᯮ짮 ⨯ PULL_DOWN.

                        SQL*Menu User's Guide   and Reference 
                    ᠭ    ⨯ .

starting_menu_name  ।    ਫ  ,   ஥ SQL*Forms
                    㤥 ᯮ짮     砫쭮  .   ࠬ
                     ,  㪠       ࠪ⨪ 
                    Starting Menu   Name.  ᫨   㪠  砫쭮
                    ,  SQL*Menu  㤥  ᯮ짮       ⥬  
                    ,         ਫ .

group_name          । 㯯 , ஥   SQL*Menu  㤥
                    ᯮ짮.     ࠬ      ࠪ⨪
                      Menu Security Group.  ᫨      㪠  
                    㯯,   SQL*Menu   ᯮ  ⥪饥  짮⥫
                     । 㯯.

ᠭ: REPLACE_MENU   ⥪饥    SQL*Menu   㪠  .
 楤 뢮    ࠭,       
⨢.  REPLACE_MENU  ⠪     冷 뢮  
㯯 ,  SQL*Menu ᯮ  ।  ,    樨
 뢮.


                                   -- 182 --



..  REPLACE_MENU     ⨢,  SQL*Forms  ࠧ蠥
 뢠    ⨢  ࠭.  ⮬    
    ࠭, ᫨  ࠭   ⨢ ࠭.

⢥ ⥬:   REPLACE_MENU, -奬
                    祭  SQL*Menu


        RESIZE_MENU

⠪:    RESIZE_MENU(page_number, width,height);
:

page_number       । 楫᫥  ࠭  ⥪饩 ଥ,
                   室    㠫 ⠡.

width             । 楫 ᫮  ਭ   㠫쭮 ⠡
                   ᨬ.

height            । 楫 ᫮     㠫쭮 ⠡
                   ᨬ.

ᠭ:  RESIZE_MENU    ࠧ 㠫쭮 ⠡ ࠭.
砭:
     -      ࠧ  㠫쭮  ⠡   ⠪  ࠧ,
       ⮡  ⠫  ࠭,   室饩   㠫 ⠡.

     -    ࠧ 㠫쭮  ⠡,     孨 
       㣮 筮 ⠥ . ,   ⠪    ࠡ⠥
       -㣮,  ᫨ 楤   맮 㠫 ⠡   뢮 
            ࠭.      ⮬  砥  SQL*Forms  ⮬᪨
       ६頥 㠫 ⠡  쭮    稭 
       㦭 樨 㠫쭮 ⠡.

     ⢥ ⥬:  RESIZE_MENU, -奬
                        ࠪ⨪ ࠭
                        ᯫ뢠騥 ࠭


        SCROLL_DOWN

⠪: SCROLL_DOWN;

ᠭ: SCROLL_DOWN ஫  ᯨ᮪  ᥩ  ⥪饣   
ਬ୮   80% 뢮 .   ⢨ 뢥 ,  室訥
"" ⥪饣 뢮  .

᫨  ⠬  뫨  㯭        , SQL*Forms
맮        ࠭     믮 SCROLL_DOWN.

᫥  ஫஢  SCROLL_DOWN  ।  ࠢ   ⭮ ,
  室 ,  뢥    ᫥⥫
஬.

⢥ ⥬:    SCROLL_DOWN, -奬


        SCROLL_UP

                                   -- 183 --



⠪: SCROLL_UP;

ᠭ: SCROLL_DOWN ஫  ᯨ᮪  ᥩ  ⥪饣   
ਬ୮    80% 뢮 .   ⢨ 뢥 , 室訥
"" ⥪饣 뢮 .

᫥  ஫஢  SCROLL_UP  ।   ࠢ    ⭮ ,
  室 ,  뢥    ᫥⥫
஬.

⢥ ⥬:    SCROLL_UP, -奬



        SET_FIELD

SET_FIELD(field_name, {AUTO_HELP | AUTO_SKIP | FIXED_LENGTH |

ENTERABLE | REQUIRED | ECHO | QUERYABLE | UPDATEABLE | UPDATE_NULL |

UPPER_CASE} [,{ATTR_ON  | ATTR_OFF}]);


ᠭ:  SET_FIELD    ,   㪠 ࠪ⨪
⮣ .  ⬥⨬,      ⮫쪮  ࠪ⨪ 
 楤. ࠪ⨪ ᮮ⢥ ᫥騬 ࠬࠬ:

ࠬ            ࠪ⨪

AUTO_HELP           Automatic Hint
AUTO_HELP           Automatic Skip
FIXED_LENTGH        Fixed Lentgh
ENTERABLE           Input Allowed
REQUIRED            Required
ECHO                Echo Input
QUERYABLE           Query Allowed
UPDATEABLE          Update Allowed
UPDATE_NULL         Update if Null
UPPER_CASE          Uppercase

  㬮砭  SET_FIELD  ᯮ ࠬ ATTR_ON.   ࠬ
⠢   SQL*Forms    ⠭    㪠 ࠪ⨪    "on".
᫨      ᯮ ࠬ ATTR_OFF, SQL*Forms ⠭
㪠 ࠪ⨪  "off".

 , ᤥ 㯠 楤ன SET_FIELD, ⢨⥫쭮 
 ,   㣠 SET_FIELD     ࠪ⨪  ⥪
ଠ  .

砭:  ᫥騥 ࠭祭  ᫮ ᯮ짮 SET_FIELD:

     -  SET_FIELD               ⬥   ࠪ⨪
        Displayed   .
     -  SET_FIELD      ⬥ ࠪ⨪ Input   Allowed 
        ⥪饣 .
     - ᫨  xࠪ⨪ 뢠 ᪨   䫨  㣨
       ࠪ⨪ ,  ᢥ     २⢮.


                                   -- 184 --



⢥ ⥬:   ࠪ⨪ 
                    SET_FIELD, -奬



        SHOW_KEYS

⠪:    SHOW_KEYS;

ᠭ: SHOW_KEYS 뢮 ࠭ Show Keys.    
㭪樮  ,  SQL*Forms    뢮 ,  뫠 
࠭  맮 SHOW_KEYS.

⢥ ⥬:    SHOW_KEYS, -奬



        SHOW_MENU

⠪:    SHOW_MENU;

ᠭ:  SHOW_MENU  뢮  ⥪饥   SQL*Menu,  ᫨ ⮫쪮  㦥
 뢥.   楤       ⨢.

..   SHOW_MENU        ⨢,  SQL*Forms    
뢠      ⨢  ࠭.

⮬         ࠭, ᫨  
⨢ ࠭.

⢥ ⥬:   SHOW_MENU, -奬
                    祭  SQL*Menu


        SHOW_PAGE

⠪:    SHOW_PAGE(page_numder);

  page_number  -  楫᫥   ࠭  ⥪饩 ଥ, 
                       뢥  ࠭.

ᠭ: SHOW_PAGE 뢮 㪠 ࠭  ࠭,       
⠭  ⨢.  ᫨ ࠭  ࠭ ४뢠,   ࠭,
뢥     SHOW_PAGE ᫥,  㤥    ⨢  ࠭楩,
  㣨 뢥묨 ࠭栬.

砭:    ᯮ짮 SHOW_PAGE ⮫쪮  ᯫ뢠 ࠭.
⢥ ⥬:   SHOW_PAGE, -奬
                    ࠪ⨪ ࠭
                    ᯫ뢠騥 ࠭



        SYNCHRONIZE

⠪:    SYNCHRONIZE;



                                   -- 185 --



ᠭ:   SYNCHRONIZE  ᨭ஭  ࠭  ନ   ७
ﭨ .   ,  SYNCHRONIZE  뢮  ࠭ 
⮡ࠦ ଠ樨,  SQL*Forms   ᢮ ७
।⠢ ࠭.  ⢥ ⥬:    SYNCHRONIZE, -奬


        UP

⠪:    UP;

ᠭ:  UP  । ࠢ  ।⠢ ⥪饣    
      ᫥騬        ⥪騬 ᫥⥫ ஬.

⢥ ⥬:     UP, -奬


        USER_EXIT

⠪:    USER_EXIT(user_exit_string[,error_string]);
:

user_exit_string  ।  짮⥫᪮ -   室,   
                   맢,      ࠬ.

error_string      । ᮮ饭  訡, ஥ SQL*Forms 
                  㯭    ᡮ 짮⥫᪮ 室.

ᠭ:  USER_EXIT  뢠  짮⥫᪨  室    ,
           㪠  user_exit_string.

⢥ ⥬:   짮⥫᪨ 室
                    USER_EXIT, -奬


         ࠭祭 㯠 楤

  楤,      "⠫"    ᭮묨 㭪ﬨ
SQL*Forms,       ࠭祭    㯠 楤ன.   
ᯮ짮  ࠭祭  㯠 楤   ⨯ ਣ஢.

騩  ᯨ᮪  뢠      ࠭祭   㯠 楤:

ABORT_QUERY                   HIDE_PAGE
ANCHOR_VIEW                   HOST
BELL                          LOCK_RECORD
BREAK                         MESSAGE
CALL                          MOVE_VIEW
CALL_QUERY                    PAUSE
DEFAULT_VALUe                 PRINT
DISPLAY_ERROR                 REDISPLAY
DISPLAY_FIELD                 REPLACE_MENU
EDIT_FIELD                    RESIZE_VIEW
ERASE                         SET_FIELD
EXECUTE_TRIGGER(᫨ ਣ    SHOW_KEYS
짮⥫ ᯮ ⮫쪮  SHOW_MENU
࠭祭 楤)       SHOW_PAGE
HELP                            SYNCHRONIZE
HIDE_MENU                       USER_EXIT

                                   -- 186 --




         ࠭祭 㯠 楤

   楤,     ࠣ  ᭮  㭪樨 SQL*Forms,
 ࠭祭  㯠  楤ன.   ᯮ짮 ࠭祭-
 㯠 楤 ⮫쪮  祢 ਣ ( key triggers)  ਣ-
,  짮⥫ﬨ ( user-named triggers ) ,  뢠
祢묨 ਣࠬ.
  ᫥  ᯮ짮  ࠭祭  㯠  楤   ᫥
⨯ ਣ஢:

  -   ਣ   On-Error,   On-Database-Record,   On-Delete,
      On-Insert,   On-Lock,     On-Message,      On-New-Record,
On-Remove-Record, On-Update, On-Validate-Field    On-Validate-Record;

  - ਣ Pre-  Post-Field,  Pre-  Post-Record,  Pre-  
              Post-Block, Pre-  Post-Form;

  - ਣ Pre-  Post-Query;
  - ਣ Pre-  Post-Insert,  Pre-  Post-Update,  Pre- 
              Post-Delete, Pre-  Post-Commit;

  - ਣ,  짮⥫ﬨ,   뢠
    襯᫥묨 ਣࠬ.

  SQL*Forms(Design)        ਣ V3,   ᯮ
  㯠  楤  -  ࠭祭     ࠭祭.  ,
SQL*Forms(Run Form) 뤠 訡, ᫨  ⠥ 믮 ਣ,
ࠢ쭮 ᯮ騩  ࠭祭 㯠 楤.
   ४  ⨬   ⨯ ਣ஢!

  騥 㯠 楤  ࠭祭묨:

  BLOCK_MENU                    EXIT_FORM
  CALL_INPUT                    FIRST_RECORD
  CLEAR_BLOCK                   GO_BLOCK
  CLEAR_EOL                     GO_FIELD
  CLEAR_FIELD                   GO_RECORD
  CLEAR_FORM                    LAST_RECORD
  CLEAR_RECORD                  LIST_VALUES
  COMMIT_FORM                   NEW_FORM
  COUNT_QUERY                   NEXT_BLOCK
  CREATE_RECORD                 NEXT_FIELD
  DELETE_RECORD                 NEXT_KEY
  DOWN                          NEXT_RECORD
  DUPLICATE_RECORD              NEXT_SET
  DUPLICATE_FIELD               POST
  ENTER                         PREVIOUS_BLOCK
  ENTER_QUERY                   PREVIOUS_FIELD
  EXECUTE_QUERY                 PREVIOUS_RECORD
  EXECUTE_TRIGGER(᫨ ਣ  SCROLL_DOWN
  짮⥫ ᯮ       SCROLL_UP
  ࠭祭 㯠      UP
  楤)

  ⢥ ⥬:     ਣ஢



                                   -- 187 --



                 17

                     

   㭪 -  ஥ 㭪 PL/SQL,  㯭 ᥬ
ଠ.   㯠  㭪  ࠦ ।  ᯥ  ⥪饩
ᨨ  SQL*Forms(Run Form)  頥  祭.   ᯮ  㯠
㭪樨    ਣ,          ଠ    ꥪ
SQL*Forms   ࠡ⪥  ६ 믮 ਫ.    ᯮ짮-
    ଠ   ⨯ ਣ஢  । 쭥襣 
ࠡ ਫ      ⫠.

     ।⠢  ।  㯠  㭪権 SQL*Forms.

         । 㯠 㭪権

  ᥪ    ।⠢    㯠  㭪    䠢⭮
浪.   ᨭ⠪  㯠 㭪樨   ᠭ.

         㬥 㯠 㭪権

 㯠 㭪樨 ॡ 㬥    ᨬ ப.
 ⪮ ࠬ ᨭ⠪  㯠 㭪権 ।⠢ 
㬥 ,  뢠 ,  祬  㬥 ᮮ⢥.
ਬ, 㯠 㭪 FIELD_CHARACTERISTIC  㬥, 뢠
field_name.   ᨭ⠪         ⮬,  㯠 㭪
FIELD_CHARACTERISTIC ॡ 㬥,  ᮮ⢥   - 
⮬ 砥  , ࠪ⨪ ண   .

  ࠧ ᯮᮡ ᮧ ࠢ쭮 㬥  
ᨬ쭮 ப. ⮡ ࠢ쭮 ᯮ짮 㯠 㭪樨,  
㦭    ।⠢  㬥⮢.   ଠ
⠫  ⨯  ࠦ,  ⨬   ᯮ짮   ⢥
㬥⮢ 㯠 㭪権,     ࠦ ᨬ묨
ப.

㪢 뫪        'argument_string'

                            argument_string    -    ப
                         ᨬ,       㤮⢮
                         ॡ 㬥.

뫪  祭   :field_name

                           field_name -  ,  祭 
                         ப ᨬ,  㤮⢮ ॡ
                         㬥.

뫪  ६    :variable_name
SQL*Forms
                           variable_name  -  ६   SQL*Forms,
                         祭   ப ᨬ,  㤮-
                       ⢮ ॡ 㬥.
                         ६         ⥬ 
                       쭮 ६.




                                   -- 188 --



뫪  ६   variable_name
PL/SQL
                           variable_name  -   쭮   ६
                       PL/SQL,      祭     ப ᨬ,
                          㤮⢮ ॡ 㬥.

                         .    PL/SQL   User's   Guide   and   Reference
                           ଠ樨        ६ PL/SQL.

ᢥ 뫪
                         NAME_IN(argument_reference)

                           argument_reference          
                       뫪  㬥 (   ᢥ 뫪),
                            ࠦ      ६, 
                         祭     ப ᨬ, 
                         㤮⢮ ॡ 㬥.

 㬥   樥   ࠦ.  ਬ,  
ᯮ짮 뫪  祭 ,  ஥ 뫠  ,  ᮤঠ饥
뫪    ६  SQL*Forms.    ⠪    ᯮ짮   㣨
᭮  ࠦ  PL/SQL  ⨯ ⥭樨.

砭:    㬥,  뢠  field_name,     ப,
             砥 䨪     blockname.fieldname.

⢥ ⥬:   ६
                     㭪 NAME_IN
                    ⥬ ६



         BLOCK_CHARACTERISTIC

⠪:   BLOCK_CHARACTERISTIC(block_name,

          {BASE_TABLE | ENTERABLE | FIRST_FIELD | LAST_FIELD})

ᠭ:        㭪     BLOCK_CHARACTERISTIC 頥
ଠ    㪠 .  ࠪ⨪  ᮮ⢥
᫥騬 ࠬࠬ:

BASE_TABLE   頥  ᭮ ⠡  㪠 . ᫨
                ᭮   ⠡,     㭪  頥
             NULL.    ⢥  ࠪ⨪    Base   Table.

ENTERABLE    頥 TRUE, ᫨ 㪠   室, 
               - FALSE.

FIRST_FIELD    頥  ࢮ 室  
               㪠 . ᫨    室
               , 頥 NULL.

LAST_FIELD     頥  ᫥ 室  
               㪠 . ᫨    室
               , 頥 NULL.

頥 ⨯:    CHAR

                                   -- 189 --



 ਬ
     ।,     ਣ,    ८।
     [Next Field]   ᫥  室       .    
     믮    㭪     祢 ਣ ஢    
     ᫥   室  .   ࠢ,   ,   ,  ਤ
        ⮬  쭮 ,  ⠪         
      㧭  ࠧ,           
     ᫥  室   .

     ⮬      ८।  祢  ਣ   ஢ ,
      믮 ॡ㥬 㭪     ।⥫쭮 㧭
     㦭  :

     IF :SYSTEM.CURSOR_FIELD = 'ORDERS' ||
         BLOCK_CHARACTERISTIC('ORDERS.',LAST_FIELD)
         THEN NEXT_BLOCK;
     ELSE NEXT_FIELD;
     END IF;

     ⨬,       ਬ  뢠         頥
   祭  BLOCK_CHARACTERISTIC,   ⮬  
   SYSTEM.CURSOR_FIELD  頥  祭   blockname.fieldname, 
   BLOCK_CHARACTERISTIC 頥   ⮫쪮 祭 fieldname.

⢥ ⥬:    ࠪ⨪ 



         ERROR_CODE

⠪:    ERROR_CODE

ᠭ:    㭪  ERROR_CODE  頥   訡  
㯠  楤,      믮﫠 ᫥  ६ ⥪饩
ᨨ SQL*Forms(Run Form).  ᫨ 㯠  楤   訫
ᯥ譮,   ERROR_CODE 頥 0.

    ᥪ樨  "饭  SQL*Forms(Run  Form)"   
ᯨ᪮ ᮮ饭   訡.

頥 ⨯:    NUMBER(5)

 ਬ
      ᫥饬    IF ᯮ   ERROR_CODE  
   ஢ન   室      㯠   楤 DUPLICATE_FIELD.

     DUPLICATE_FIELD;
     IF ERROR_CODE = 41803
          THEN DEFAULT_VALUE('1','QUANTITY');
     END IF;

⢥ ⥬:     饭 SQL*Forms(Run Form)
                       㯠 楤
                                                                                

         ERROR_TEXT

⠪:    ERROR_TEXT

                                   -- 190 --



ᠭ:    㭪  ERROR_TEXT 頥 ⥪ 訡  
㯠  楤,      믮﫠 ᫥  ६ ⥪饩
ᨨ SQL*Forms(Run Form).  ᫨ 㯠  楤   訫
ᯥ譮,   ERROR_CODE 頥 NULL.

砭:  ᫨  ਫ  ন  祬 
몮, ᯮ 㯠 㭪 ERROR_CODE  㯠
㭪樨  ERROR_TEXT.  ௮  Oracle ন   ⤥ 㭪樨
 祭 প 樮 몮.

頥 ⨯:    CHAR(78)
ਬ
   ᫥饬    IF ᯮ ERROR_TEXT  ஢ન
室  㯠 楤 DUPLICATE_FIELD.

DUPLICATE_FIELD;
IF ERROR_TEXT = 'No previous record to copy value from.'
   THEN DEFAULT_VALUE('1','QUANTITY');
END IF;

⢥ ⥬: 饭 SQL*Forms(Run Form)
                   㯠 楤



         ERROR_TYPE

⠪:    ERROR_TYPE

ᠭ:    㭪  ERROR_TYPE  頥  ⨯ ᮮ饭  
訡    㯠  楤,   믮﫠 ᫥  ६
⥪饩 ᨨ  SQL*Forms(Run Form).  ERROR_TYPE 頥   
祭  ⨯ ᮮ饭  訡:

FRM   뢠,  ந諠 訡 SQL*Forms.
MNU   뢠,  ந諠 訡 SQL*Menu.
ORA   뢠,  ந諠 訡 ORACLE.

᫨ 㯠 楤 訫  ᯥ譮,  ERROR_TYPE 頥 NULL.
頥 ⨯:    CHAR(3)

 ਬ
      ᫥饬    IF ᯮ   ERROR_TYPE   
     ஢ન   室     㯠   楤 CALL.

     CALL(FORM_2);
     IF ERROR_TYPE = 'ORA'
          THEN CLEAR_FORM;
     END IF;

⢥ ⥬:    ᮮ饭
                     㯠 楤
                                                                               1


         FIELD_



                                   -- 191 --



⠪:
          FIELD_CHARACTERISTIC(field_name, CHARACTERISTIC
          {AUTO_HELP | AUTO_SKIP | BASE_TABLE | DATATYPE |

          DISPLAYED | DISPLAY_LENTGH | ECHO |ENTERABLE |

          FIELD_LENTGH | FIXED_LENTGH | LIST | PAGE |

          PRIMARY_KEY | QUERY_LENTGH | QUERYABLE |

          REQUIRED | UPDATEABLE | UPDATE_NULL |

          UPPER_CASE | X_POS | Y_POS})

ᠭ:     㭪     FIELD_CHARACTERISTIC 頥
          ଠ  㪠 . ࠪ⨪  ᮮ⢥
          ᫥騬 ࠬࠬ:

AUTO_HELP    頥 TRUE, ᫨ 㪠     祭
             ࠪ⨪   Automatic   Hint,  - FALSE.

AUTO_SKIP    頥 TRUE, ᫨ 㪠     祭
             ࠪ⨪    Automatic   Skip,  - FALSE.

BASE_TABLE   頥 TRUE, ᫨ 㪠     祭
             ࠪ⨪  Base Table,    - FALSE.

DATATYPE     頥 ⨯   㪠 .    ⢥
             ࠪ⨪    Data   Type.

DISPLAYED    頥 TRUE, ᫨ 㪠     祭
             ࠪ⨪   Displayed,    - FALSE.

DISPLAY_LENTGH
             頥  뢮  ࠭ 㪠  .
             ⢥  ࠪ⨪    Display Lentgh.

ECHO         頥 TRUE, ᫨ 㪠     祭
             ࠪ⨪  Echo Input,    - FALSE.

ENTERABLE    頥 TRUE, ᫨ 㪠     祭
             ࠪ⨪      Input   Allowed,  - FALSE.

FIELD_LENTGH  頥  㪠 . ⢥ ࠪ⨪
               Field Lentgh.

FIXED_LENTGH  頥 TRUE, ᫨ 㪠     祭
              ࠪ⨪      Fixed   Lentgh,  - FALSE.

LIST         頥 TRUE, ᫨ 㪠     ᯨ᮪
             ।  祭,     -   FALSE.  ⢥
             ࠪ⨪    List of Values SQL Text.

PAGE         頥  ࠭  㪠   . ⢥
             ⠭ ࠭    ࠪ⨪  Screen Position.

PRIMARY_KEY  頥 TRUE, ᫨ 㪠     祭
             ࠪ⨪     Primary   Key,  - FALSE.

                                   -- 192 --



QUERY_LENTGH 頥    㪠   .  ⢥
             ࠪ⨪     Query Lentgh.

QUERYABLE    頥 TRUE, ᫨ 㪠     祭
             ࠪ⨪      Query   Allowed,  - FALSE.

REQUIRED     頥 TRUE, ᫨ 㪠     祭
             ࠪ⨪   Required,    - FALSE.

UPDATEABLE   頥 TRUE, ᫨ 㪠     祭
             ࠪ⨪      Update   Allowed,  - FALSE.

UPDATE_NULL  頥 TRUE, ᫨ 㪠     祭
             ࠪ⨪   Update if   Null,  - FALSE.

UPPER_CASE   頥 TRUE, ᫨ 㪠     祭
             ࠪ⨪   Uppercase,    - FALSE.

X_POS        頥 ਧ⠫ न -   樨      
             ࠭.   ⢥   ⠭ X  ࠪ⨪  
             Screen   Position.

Y_POS        頥 ⨪ न 樨     ࠭.
             ⢥ ⠭   Y  ࠪ⨪  Screen
             Position.

頥 ⨯:    CHAR

 ਬ
     ।,     ᮧ  楤  ஢   ,
      ४砥   ࠪ⨪      Automatic  Hint.
     楤  믮     :

     PROCEDURE TOGGLE_FIELD_HINT IS
     BEGIN
          IF FIELD_CHARACTERISTIC(:SYSTEM.CURSOR_FIELD,
                                      AUTO_HELP) = 'TRUE'
               THEN SET_FIELD(:SYSTEM.CURSOR_FIELD,
                                  AUTO_HELP,ATTR_OFF);
               ELSE SET_FIELD(:SYSTEM.CURSOR_FIELD,
                                   AUTO_HELP,ATTR_ON);
          END IF;
     END;

     ᫨  ࢠ  㯠  㭪  頥  TRUE -   뢠,  
      祭  ࠪ⨪   Automatic  Hint,  -    
   楤  몫砥    ࠪ⨪.  ᫨  㭪 頥
   FALSE  -   뢠,      몫祭 ࠪ⨪
   Automatic  Hint,  -      楤  砥     ࠪ⨪.

⢥ ⥬:    ࠪ⨪ 


         FORM_FAILURE

⠪:    FORM_FAILURE



                                   -- 193 --



ᠭ:      㭪   FORM_FAILURE  頥 祭,
஥   뢠   १    㯠 楤,  믮襩
᫥  ६ ⥪饩 ᨨ SQL*Forms(Run Form).

          頥 祭

ᯥ譮                  FALSE
ᯥ譮                TRUE
⠫쭠 訡         FALSE

᫨  㯠 楤  믮﫮    ६ ⥪饩 ᨨ
SQL*Forms(Run Form),  FORM_FAILURE 頥 FALSE.

頥 ⨯:    BOOLEAN

   ਬ
      ᫥饬    IF ᯮ   FORM_FAILURE  
     ஢ન   १   㯠   楤 NEXT_RECORD.

     NEXT_RECORD;
     IF FORM_FAILURE
          THEN FIRST_RECORD;
     END IF;

⢥ ⥬:    ⪠ 㯠 楤



         FORM_FATAL

⠪:    FORM_FATAL

ᠭ:  㭪  FORM_FATAL   頥 १ 㯠
楤, 믮襩 ᫥  ६ ⥪饩 ᨨ SQL*Forms(Run Form)

          頥 祭

ᯥ譮                  FALSE
ᯥ譮                FALSE
⠫쭠 訡         TRUE

頥 ⨯:    BOOLEAN

ਬ    ᫥饬    IF ᯮ   FORM_FATAL
          ஢ન   १   㯠   楤 USER_EXIT.

     USER_EXIT('CALC_TOTAL');
     IF FORM_FATAL
          THEN MESSAGE('Fatal error occured. Contact DBA.');
     END IF;

⢥ ⥬:    ⪠ 㯠 楤


         FORM_SUCCESS

⠪:    FORM_SUCCESS


                                   -- 194 --



ᠭ:     㭪   FORM_SUCCESS   頥 १
㯠 楤,  믮襩 ᫥  ६ ⥪饩 ᨨ
SQL*Forms(Run Form).

          頥 祭

ᯥ譮                  TRUE
ᯥ譮                FALSE
⠫쭠 訡         FALSE
頥 ⨯:        BOOLEAN

ਬ
      ᫥饬    IF ᯮ   FORM_SUCCESS  
     ஢ન १   㯠   楤 COMMIT.

     COMMIT;
     IF FORM_SUCCESS
          THEN SYNCHRONIZE;
     END IF;

⢥ ⥬:   ⪠ 㯠 楤


         NAME_IN

⠪:    NAME_IN(variable_name)

ᠭ:   㭪 NAME_IN 頥 ᮤন
           ६,  ன  ਬ  㭪.

祭 頥   ᨬ쭮 ப.  ,    ᯮ짮-
 NAME_IN  祭 ᥫ     ப  ᨬ   쭥襣
८ࠧ  ப  ᮮ⢥騥  ⨯   .    
ᯮ짮 \  祭 ⠪ ,     㣮 祭 
믮塞 .

᫨  "⠢"  㭪  NAME_IN    ,  SQL*Forms 
  㭪樨  NAME_IN     㡮   㤠 " 業".

砭:  㭪 NAME_IN ࠡ⠥   뫪  ६,
 ࠪ୮  ਣ஢ V2.   PL/SQL  ন 뫪 
६.

頥 ⨯:    CHAR

  ਬ
      ᫥饬 믮塞  NAME_IN    ⥪饥 祭
     BLOCK_CHOICE.

     GO_BLOCK(NAME_IN('BLOCK_CHOICE'));

     ਬ,  ᫨  ⥪饥  祭  BLOCK_CHOICE - ORD,  ਢ
        ⠢   SQL*Forms   । ࠢ   ORD.

      ᫥饬 믮塞  ७ 㭪   NAME_IN 
     ⥪饥 祭      CUSTOMER.    ।,   砥
     祭     㣮  ,     㭪 NAME_IN
        ⥪饥 祭  ⮬ .

                                   -- 195 --



     IF NAME_IN(NAME_IN('COMMENT')) = 'TKB SPORT SHOP'
          THEN NEXT_FIELD;
     END_IF;

     ਬ,   ᫨   ⥪騬   祭     COMMENT   
   CUSTOMER  ⥪騬  祭    CUSTOMER     TKB  SPORT SHOP,
     ⠢   SQL*Forms । ࠢ  ᫥饥
   .

⢥ ⥬:   맮 ꥪ⮢  PL/SQL
                    뫪  ६
















































                                   -- 196 --
