



         VII                

ਫ  A                             

     ਫ   ᢮⢠ ᨨ 3.0 SQL*Forms, ⫨e
  । ᨩ.   :
  -  ᢮⢠
  -  ᢮⢠

         ᢮⢠
   騥 ᢮⢠ ᨨ  3.0    묨  SQL*Forms:
  - 祭 ᯮ⥫쭠 ⥬
  - ᯮᮡ  뢠  SQL*Forms    ணࠬ  3GL, 饩
    ணࠬ   몥
  - ᯥ祭 ⢠  㬮砭
  - প ᮧ ᫥⥫쭮 㬥樨
  - ᯮᮡ  ᨫ ࠭祭 楫⭮
  - 譨 ணࠬ 
  - ᯥ祭 ࠡ 
  - ᪨ ࠪ⨪ 
  - ᪨ ⮡ࠦ 
  - । 孥 
  - 孨 ࠭
  - ᯮᮡ ஢   뫪  ꥪ
  - ꥤ (⥣) PL/SQL
  - ᯮᮡ ᪠ SQL*Menu  ਪ ணࠬ SQL*Forms
  -  ਣ:

     On-Database-Record       On-Remove-Record
     On-Delete                On-Update
     On-Error                 On-Validate-Field
     On-Insert                On-Validate-Record
     On-Lock                  Post-Commit
     On-Message               Pre-Commit
     On-New-Record


  楤 (⠪ 뢠 ):

     ANCHOR_VIEW              LAST_RECORD
     BREAK                    MOVE_VIEW
     CLEAR_EOL                POST
     COPY                     RESIZE_VIEW
     DISPLAY_FIELD            SET_FIELD
     FIRST_RECORD             SHOW_PAGE
     GO_RECORD                USER_EXIT
     HIDE_PAGE

-  㭪樨:

     BLOCK_CHARACTERISTIC     FORM_FAILURE
     ERROR_CODE               FORM_FATAL
     ERROR_TEXT               FORM_SUCCESS
     ERROR_TYPE               NAME_IN
     FORM_CHARACTERISTIC

-  ⥬ ६

                                    -- 28 --



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

- DATETIME data type
- LONG data type
- Column-level security
- User preference file

         ᢮⢠

騥 ᢮⢠, 訥   ।  SQL*Forms,  ᨨ 3.0
:
-  㬥  ᬮ७  
- ᮣᮢ SQL*Forms (஥஢)  ᬮ७
-   ⠭ ࠧ ᨢ  ᭮  
- ᨫ ० ⫠
-  ᬮ७ ଠ INP 䠩
- "࠭ "  ⥫ 

     - ᯮ짮  [Previous Block],  [Next Block], [Previous Page] 
                      [Next Page]
     -   X  Y न 
     - ப⪠,  ᮧ ,  ࠧ஢, 祬 ࠭

-    ⮡ࠦ  ᯨ᮪  稭, ⠪   孥 ,   
   ᯨ᮪    Select.
- ⨬묨   ⨯ ਣ஢ (V2  V3).
- 襥 ᫮ 㭪権  ।஢ ਣ.
- C騥    㬥:
     CALL                     CLEAR_FORM
     CALL_QUERY               EXIT_FORM
     CLEAR_BLOCK

- ࠭  Show  Keys    믮  ப, ⮡   
  ᠭ  㭪樮  祩.
-  । SQL*Forms ( ଠ) ⥯   
  .
-  ।  ⠡ SQL*Forms - .
- ப  SQL*Forms ( ଠ) .
-  ᮮ饭  訡 ஭㬥஢  祭 䨪樨.
- Oracle*Terminal  ⨫ CRT.


        ਫ  B

                                        

 ⮬  ਫ  ᬠਢ    ⮬,  ਪ  ணࠬ,
ᮧ  ।   SQL*Forms,   ᮢ    ᨥ  3.0
SQL*Forms.   ।⠢ ᫥騥 ⥬:
   - ࠭ (ॢ) ਣ஢  PL/SQL
   -  ⨯ 

        ࠭ ਣ஢  PL/SQL



                                    -- 29 --



   ࠧ 뢠,   㦭 ࠭᫨஢ ᨨ   2.0/2.2/2.3
ਣ஢,  ᠭ    몥 㭪樮쭮   ,     PL/SQL.  
 ᯥ祭  אַ ࠭樨  ⠪  ࠧ,  ⮡   ਣ
  ᥡ  筮  ஬.

 ਣ V2  ࠡ  ᨨ 3.0 SQL*Forms, Oracle  Corporation
४  ८ࠧ    ਣ  ⨯  V2  ⨯ V3. 
८ࠧ      믮 ਪ
ணࠬ.
:   ਣ ᨩ V2  V3              4-2

騥         ⮡   ॢ   ਣ   V2      V3,  室
       ਤন ᫥饩 ,  ८ࠧ
࠭樨      蠣  ਣ  V2        PL/SQL 
              墠뢠騬  ⬮   ஢  楤ன
              ᯥ/⪠.
              ࠭᫨஢ ਣ ਭ ᫥騩 :


              DECLARE
                  abort_trigger BOOLEAN;
                  return_code BOOLEAN;
                  ignore_failure BOOLEAN;
                  ignore_trigger_failure EXEPTION;
              BEGIN
                  trigger_step_block;
                  [trigger_step_block;
                  trigger_step_block;
                  ...]
              EXEPTION
                  WHEN ignore_trigger_failure THEN NULL;
              END;
               trigger_step_block :
              { <step_n>}  <step_label> }
              DECLARE
                  fail EXEPTION;

BEGIN
    step_logic;
    abort_trigger := FALSE;
    ignore_failure :=FALSE;
    return_code := TRUE;

EXEPTION
    WHEN fail THEN
    abort_trigger := TRUE; ignore_failure := FALSE;   ;1
    abort_trigger := TRUE; ignore_failure := TRUE;   ;2
    abort_trigger := FALSE: ignore_failure := FALSE   ;3

END;

IF abort_trigger
    THEN IF ignore_failure
           THEN RAISE ignore_trigger_failure;
           ELSE RAISE form_trigger_failure;

    END IF;


                                    -- 30 --



    ELSIF return_code
           THEN GOTO {-1success_label-0  step_n+1};
    ELSE GOTO {-1 failure_label-0  step_n+1};

END IF;
:
;1          ᯮ ⮫쪮  祭 ࠪ⨪ Abort On Failure

;2             ᯮ  祭 ࠪ⨪ 蠣 ਣ஢
               Abort On Failure  Succeed on Abort

;3             ᯮ, ᫨   祭 ࠪ⨪  蠣
               ਣ஢ Abort On Failure  Succeed on Abort

step_n         ।   蠣
step_label     ।     蠣. ⪠ 蠣 । 
               蠣 (step_n)
step_logic     । ࠭ 蠣 

success_label   ࠪ⨪ 蠣 ਣ Success Label, ᫨
                

step_n+1       ।    ᫥饣  蠣   ᫥⥫쭮

failure_label   ࠪ⨪ 蠣 ਣ Failure Label 
               蠣, ᫨  ।

祭:  ᫨    success_label, failure_label, step_label,   
            step_n   ਢ    騬  ⪠,   
            GOTO ࠦ RAISE ignore_trigger_failure.

:  PL/SQL                                15-1


        ࠭  SQL

  ॢ 蠣 ਣ, ᮤঠ騥    SQL   PL/SQL.
  ⨯ 蠣 SQL,     ॢ:
              - 蠣, ᮤঠ騥  SELECT
              - 蠣, ᮤঠ騥 ࠧ DML

࠭      ⨯ ஢ SELECT,   
஢     ॢ:
SELECT
              -    ।ﬨ INTO
              -   । INTO

,     ᯥ樠 ࠧ 뢠 , ࠢ騥
      믮騥 ⥬᪨ ࠦ.   뢠  
㫥  ࠦ.   ਡ       
,   믮     뢠.  ਬ, ᬮਬ
ਣ, ᮤঠ騩  ᫥騥  蠣:

STEP1          Success Label = STEP 3
               Failure Label = STEP 2
               SELECT 'X ' FROM DUAL
               WHERE :SAL > : ENDRTIG;


                                    -- 31 --



STEP2          #EXEMACRO MESSAGE 'Comission cannot be
               greater than salary.'; ENDTRIG;

STEP3          #EXEMACRO NXTFLD;

  ८ࠧ    ᫥騩   PL/SQL:
IF : SAL > :COMM
     THEN NEXT_FIELD;
     ELSE MESSAGE ('Commission cannot be greater than
     salary.');
END IF;

 ஢  SELECT   । INTO 室   ᫥騥
㭪  ᥪ樨 DECLARE 蠣_:

FAIL EXEPTION;
dummy_into_buffer CHAR (240);
CURSOR dummy_select_into_cursor IS

    SELECT select_list
    FROM    table_list
    [where_clause]

 ।⠢ ⥪ 蠣_⬠   SELECT  । INTO
OPEN dummy_select_into_cursor;
FETCH dummy_select_into_cursor
    INTO dummy_into_buffer;

IF dummy_select_into_cursor #NOTFOUND
    THEN RAISE fail;
END IF;

 ஢ SELECT c ࠧ INTO  ᥪ DECLARE  ᫥騥
㭪:

CURSOR DUMMY_SELECT_INTO_CURSOR IS
    SELECT select_list
    FROM   table_list
    [where_clause]

 ।⠢ ⥪ ⬠  ஢ SELECT  ࠧ INTO:

OPEN dummy_select_into_cursor;
FETCH dummi_select_into_cursor
    INTO :[block.]field_name], :[block.]field_name2,...;

IF dummy_select_into_cursor #NOTFOUND
    THEN RAISE fail;
END IF;


࠭᫨-     ஢ DML (஬ SELECT) ᯮ ᫥騩
         :
஢
DML           DML_statement;




                                    -- 32 --



              IF SQL#NOTFOUND
                  THEN RAISE fail;
              END IF;

               DML_statement ﬠ  蠣.

              砭:  SQL -     㬮砭.

࠭᫨-       㭪樮쭮      ᫥饩   
         ࠭᫨    ᮮ⢥    楤
஢    SQL*Forms:
㭪樮-
      #EXEMACRO function_code; [function_code;
              function_code;...]

              ,        㭪樮      
              ࠭᫨       楤  V3.

              :  ࠢ  㭪樮    V2
                        c ⠬ V3  F-36

࠭᫨-      CASE  ࠭᫨    PL/SQL    
         ஢  IF  ELSIF  ELSE. 騩  CASE
஢ CASE

CASE selector IS
    WHEN criteria_1 THEN action_list_1
    WHEN criteria_2 THEN action_list_2
    WHEN OTHERS THEN action_list_3
END CASE;

   ࠭᫨ ᫥騬 ࠧ:

IF selector = criteria_1
    THEN action_list_1;
    ELSIF selector = criteria_2
    THEN action_list_2;
    ELSE action_list_3;
END IF;

:   CASE  F-38


࠭᫨-        ࠧ  ᪠뢠    ⮬,    㦭
         ࠭᫨஢ SQL*Forms , ⫨  #EXEMACRO.

SQL*Forms

#COPY           設⢥  砥 #COPY  ࠭᫨    PL/SQL.
              ᫨  室 㭪   㭪  祭   
              ᢥ     ᯮ짮   뫮 ६, 
                #COPY  ࠭᫨  ᫥騬 ࠧ:

               V2

              #COPY {sourse  quoted_string} [INTO] [:]target[;]

              ࠭᫨ :

                                    -- 33 --



              :target := {sourse  quoted_string};

        #ERASE
   #ERASE ࠭᫨ אַ   楤,  㪠 
᫥饬 ਬ.  #ERASE

#ERASE {[&]GLOBAL.variable_name  [&][block.] field_name}[;]

࠭᫨ :

ERASE({[NAME_IN(]'GLOBAL.variable_name'[)] [NAME_IN(]'[block.] field_name'});

:  ⭠ 楤 ERASE              16-14

        #HOST

 #HOST ࠭᫨   楤 SQL*Forms,   
᫥饬 ਬ.
 #HOST

#HOST {quoted_string  &{[block] field_name  GLOBAL.variable_name})[;]

࠭᫨ :

#HOST ({quoted_string  NAME_IN ('{[bock] field_name GLOBAL.variable_name]});

:  ⭠ 楤 HOST               16-18

࠭᫨-    맮 짮⥫᪮ 室 믮  㪠
         . 맮  ᫥饩 ଥ
짮-
⥫᪮     # [#] user_exit_name_parameter_list
室
              ࠭᫨ :

              USER_EXIT ('user_exit_name'.'parameter_list');

              :  짮⥫᪨ 室, 맮  ਣ V3


         ⨯ 

  3.0   ন ⨯  ORACLE RDBMS. 
।   SQL*Forms c  ᥬ ⨯   樨 ந-
   ப ᨬ,    ᨨ  3.0,   ⢨ ஢ 
,   ॠ묨 ⨯ .    맢 ஡ 
७ ਪ  ணࠬ  ᨨ 3.0.

稭  ᨨ 2.3 SQL*Forms,   ᮧ  DATE,    
⨬     㯮ॡ  姭  ᥫ    祭
,  ⠪   姭. ᫨    ,   
  ⮪     姭筮 ᫠,       
          ᫥  .

ਬ,  ᫨        31-DEC-88    , 饥  
⮪    姭筮 ᫠,    SQL*Forms   
  ,   31-DEC-0088.   㭪樮஢  易    몮 SQL
      ࠭,      ।   DATE.

                                    -- 34 --



⮡  ஢   饥    DATE  ⠪ ࠧ, ⮡ 
뢠 姭筮 祭 , 室 㢥   
 ஡,  祣 ᯮ [Resize Field].

砭:    ᢮⢮    ⭮      JDATE  EDATE.


        ਫ  

              A D V I S O R Y  (         )

 ਫ  ।⠢  ଠ  ⮬,    
䥪⨢  ࠡ     ਪ ணࠬ.

  ଠ  ࠧ    .   㪠 ᮯ஢
ᯨ᪮ , 騬 ࠢ  ⮬,     㪮⢠  
 ᮮ⢥ ଠ.

                                    

㭤-      ⠩ ।뢠       । 3-4
⠫쭠       ।,  
ࠡ⪠     ।    ਣ,
              ᪠  ६ ।.

              ,  ᫥ ஢ન    ஢ઠ  3-9
               稭 ஢塞
              .

               稭      ஢ 3-15
               ப ,  SQL
               室  ਣ.

                ᪫騥     ஢ 3-16
              ஢  ⠡ ਪ
              ணࠬ.

               ஦         3-21
                    
              १ ਣ  ६ 
              裡.

               ० Enyer Query ਣ     Enter Query 3-29
              ᪠.


楯     ஥  ਪ      ᨨ ਣ஢
ਣ஢     ணࠬ  ਣࠬ V3,         V2 V3  4-2
              ਣ ⨯ V2 
              ਣࠬ V3.

              C   ࠢ              믮 ஢
              ᯮ짮 ஢ DML       SQL  4-5
              (Data Manipulation Language)
               ਣ.




                                    -- 35 --



               ᯮ  DDL       믮 ஢
              (Data Definition Language)         SQL  4-5
               ਣ.


࠭       । 孨 ࠭,   ࠪ⨪
              ᫥ ࠢ ࠧ饭      ࠧ饭
              ࠧ஢  ⮡ࠦ.             ⮡ࠦ  10-8

                                                 ࠪ⨪ ࠧ饭
                                                 ࠭  10-9

                                                 ࠪ⨪ ࠧ஢
                                                 ⮡ࠦ  10-9


           ।      ࠪ⨪
              ᥩ,            Records
              ஢   .        Buffered  11-15

              ᫨  㦭 ⠢      ࠪ⨪
                ,  뤥     Select
              ⮫           Column  11-16
               ।   NOT NULL.

              ᫨   ⠭          䨣
              䨣 宧鶴-稭    宧鶴-稭
              ⮬᪨,   ᮧ   (Master-detail)  11-20
              ᮦ ࠡ稩   ଥ
              Default Block.


             ஦              ࠪ⨪
              ஢ ࠪ⨪        12-4
              ,   
              .

                  אַ 訢      LONG  12-8
                LONG    ࠧ WHERE 
              ORDER BY   SELECT.

              ⮡    ᫠        ࠪ⨪
              ᮮ⭮襭  "㦮  ",        Enforce Foreign
               室 न஢      Key 12-12
              ᯮ짮 ࠪ⨪ 
              Enforce Foreign Key  Input Allowed.

                 ⨯  NUMBER    ࠪ⨪ 
                 㡥,    Field Length  12-14
               筠  ⮣, ⮡
               ந諮 祭.

                 ᮧ ,       ࠪ⨪ 
              ᭮  㦨 ⮫,    Field Name  12-14
               ண ᮤন ஡.




                                    -- 36 --



                ⠭       ࠪ⨪ 
               ,   ⠢      Format Mask  12-15
                ⮢ ଠ ᪨.

                  ᥣ      ࠪ⨪ 
                  ࠢ       Query Length  12-21
               .

                 १          ࠪ⨪ 
              ⠢   "࠭          Sequence Number 12-22
              ", SQL*Forms 
              祭 浪   㬮砭.


ਣ      ᫨         ࠪ⨪
              ਣ   짮⥫           ਣ Trigger
                 ਪ          Name  14-7
              ணࠬ, 㡥  ⮬,
                ⠪   뫪.

              ,        ਣ஢  14-18
              ⨬묨  ࠧ ਣ.

               ६ । ࠭権       ਣ On-Delete 14-13
              ਣ On-Insert, On-Update     ਣ On-Insert 14-14
               On-Delete  믮    ਣ On-Update 14-16
              SQL*Forms ⢨  㬮砭,
              ⠪  ⠢,  
              㭨⮦.

              ਣ On-Error  On-Message     ਣ On-Error 14-14
                ᮮ饭        ਣ
              㬮砭.                         On-Message  14-15

              ਣ  On-Lock           ਣ On-Lock   14-15
              믮 SQL*Forms ⢨
               ஢ ப.

                ਣ஢            ਣ
              짮⥫, ᯮ          짮⥫  14-25
              楤 ଠ-஢.
              㬮砭.


PL/SQL        ਤন ࠢ,            PL/SQL, ࠭祭
              ⭮  楤ࠬ PL/SQL,    SQL*Forms 15-7
               ꥪ⮢  㭪権
              SQL*Forms.

              ᫨  ਪ ணࠬ     ⭠ 楤,
              ন  몠     ⪠  15-8
              ணࠬ஢, 
              㯮ॡ 室 ਣ஢,
                ⭮ 楤
              ERROR_TEXT.




                                    -- 37 --




⭠       ࠢ, ⭮騬     ⭠ 楤
楤      ⮡ࠦ, ᤢ,   ANCHOR_VIEW  16-5
              ࠧ஢,  ࠡ  孨    ⭠ 楤
              ࠭栬.                        HIDE_PAGE  16-18
                                                 ⭠ 楤
                                                 MOVE_VIEW  16-20
                                                 ⭠ 楤
                                                 RESIZE_VIEW  16-25
                                                 ⭠ 楤
                                                 SHOW_PAGE  16-28

              ᫨  ᯮ       ⭠ 楤
              PL/SQL COMMIT  ROLLBACK         CLEAR_FORM  16-9
                  楤    ⭠ 楤
              ଠ-஢, SQL*Forms           COMMIT_FORM  16-10
                 
               COMMIT_FORM  CLEAR_FORM
              ᮮ⢥⢥.

              ᢥ            ⭠ 楤
              楤   ENTER_QUERY           ENTER_QUERY  16-15
                EXECUTE_QUERY,             ⭠ 楤
              㯮ॡ   ࠬ஢          EXECUTE_QUERY  16-15
              ALL_RECORDS    FOR_UPDATE.

              ਤ ᮮ⢥    ⭠ 楤
              ࠢ,  ᯮ          SET_FIELD  16-26
               楤 SET_FIELD
               䨪樨 ࠪ⨪
              .

               楤        饭 
              饭묨                  楤  16-29
              ᯮ짮 ⮫쪮  
              ਣ஢.


       V3 ਣ  뫮    ⭠ 㭪
㭪樨       ६ ᯮ     NAME_IN  17-10
              㭪 NAME_IN.



६    SYSTEM.CURRENT_BLOCK,              SYSTEM.CURRENT_BLOCK
              SYSTEM.CURRENT_FIELD              18-5
              SYSTEM.CURRENT_VALUE 祭      SYSTEM.CURRENT_FIELD
                3.0 SQL*Forms.            18-6
              ௮ Oracle ४   SYSTEM.CURRENT_VALUE
              ୠ⨢   ⥬         18-6
              ६, ।ᬮ७ 
              ᨨ 3.0.

                 ᯮ짮          SYSTEM.MESSAGE_LEVEL
              ⥬ ६               18-10
              SYSTEM.MESSAGE_LEVEL  
              ।   ᮮ饭 
              訡.

                                    -- 38 --




짮-      ஢ ப      EXEC SQL
⥫᪨                       19-4
室        짮⥫᪨ 室  ᫨
               ଠ  , 
              ।     맮
              짮⥫᪮ 室.

               ࠢ, ⭮騬    짮⥫᪨
               室 짮⥫     室,  19-8
              믮 I/O  짮⥫᪮
              室.

              ᨨ ⮢ 짮⥫᪨      IAPXTB  19-9
              室 室 ঠ 
              ⤥쭮 ⠡ IAPXTB.


        SQL*Forms  ন          ᫮ 祭,
 ꥪ⠬   ᫮ 祭  묨    ꥪ  20-2
              窠, ਭ  ORACLE.

               ᯮ 㦥 ᫮      㦥 ᫮  20-2
              ORACLE  䨪樨 ꥪ⮢
              SQL*Forms.

              ᢥ              ஢
               䨪樨 ꥪ⮢ 뫮.   ꥪ 뫮  20-4


࠭祭   ᢥ             ࠭祭
楫⭮   ࠭祭 楫⭮ ꥪ⮢  楫⭮  22-1
               ஢,  ⠪ 
              ࠭祭 楫⭮ 
              襩 樮 ⥬.


    ᫥   樨         ஢
              ४⥫  ப    ४⥫
               맢 訡,        ப 23-8
              ⠥ 믮 .

              騥 ४⥫          -n ४⥫ 
                ᨨ 3.0 SQL*Forms:  SQL*Forms
                                                 (஥஢) 23-12
              -n ४⥫  SQL*Forms     -o ४⥫ 
              (஥஢)                   SQL*Forms
                                                 (஢) 23-14
              -o ४⥫  SQL*Forms     -s ४⥫ 
              (஢)                    SQL*Forms (஢)
              -s ४⥫  SQL*Forms

              -o ४⥫  SQL*Forms     -o ४⥫ 
              ( ଠ)   뢠      SQL*Forms (
              ﭨ    ਣ   ଠ)  23-18
              V3.



                                    -- 39 --



              -t ४⥫  SQL*Forms     -t ४⥫ 
              ( ଠ)  뢠       SQL*Forms (
               ﭨ          ଠ) 23-20
              ⠭⭮ ஢
              SQL*Forms  On-Insert, On-Update
               On-Delete ਣ.



    ⠩ 뫠       쭮 
            ⨯        ⥬  24-3
              㣮, 뫠 INP 䠩.

                  ᯮ 쭮 
              ⠡ IAP 11 unless 11 筠  ⥬  24-3
                          
              ⥬      .

              Oracle Corporation ࠭      ⠡
              ᮡ ࠢ         SQL*Forms
              ⠡ SQL*Forms (஥஢) (஥஢)
                ६  㢥.     24-4

               ࠡ⠩  묨 ⠡栬   ⠡
              SQL*Forms (஥஢) १   SQL*Forms
              SQL*Plus.                          (஥஢)

              ஢ INP 䠩     ଠ INP 䠩 24-13
                ਪ ணࠬ.
              Oracle Corporation  ন
              ।஢  䠩.


           뢠 ମ   맮  
 㣨        室   짮⥫.        ணࠬ  25-10
த⠬    ਬ  楤 CALL.


樨           Share Cursors for     
              Implicit SQL  뢠  Share Cursor for
              ⢨, ᫨       Implicit SQL  26-4
              ⠭⭮   ஢
              SQL*Forms  ਣ On-Insert,
              On-Update  On-Delete.

                Share Cursors for     
              Implicit SQL  뢠  Share Cursor for
              ⢨            Implicit SQL  26-4
              ਣ V3.


樠   ᫨  ஥       । 筮
ᮮࠦ   । 筮 ०   ,   ०  D-2
              室  ᢥ  
              ᯥ樠 ᮮࠦ.




                                    -- 40 --



              ᫨  ஥       । 筮
              ஢  ।      ,     ०  D-2
              室  ᢥ  
              ᯥ樠 ᮮࠦ.


ਫ  D
              C                       

   SQL*Forms  ࠡ⠥  ⥬ ࠧ  䨣権.    
ਢ ᠭ ⮣,  SQL*Forms ࠡ⠥  ।  ⥪⮢  ०.
ᠭ   室    ᥬ  ।,      
ࠧ,        ᢥ,  ࠧࠡ뢠 ᢮
ਪ  ணࠬ    । ⥪⮢  ० / ᫨ 
ਪ ணࠬ  믮    ।  ⥪⮢  ०.

  ਫ 㦤 ᯥ樠 ᮮࠦ ⭮⥫쭮
ࠧࠡ⪨ ਪ  ணࠬ  SQL*Forms  ᫥ ।:
  - । 筮 ०
  - ஢ ।

:  ࠭祭 楫⭮ 16-⮢ ।  22-4

        । 筮 ०

   ᫨  ࠧࠡ뢠 ਪ ணࠬ  SQL*Forms   ।  筮
०,  室 뢠 ࠢ, ⭮騥    ᫥騬 ⢨:
   - ⠭ ஢筮 
   - ᯮ짮 ਣ஢
   - ᮧ 

 ⠪  ᫥ , ࠪ   ᯮ짮 ନ
筮 ०:
   - ନ  筮 ०,   ⫨稥   ନ ᨬ쭮 ०,
      ᯮ,     ⥪饥 祭  
     .
   - ࢠ 㪢  롮     ࠡ⠥  ନ 筮 ०.
   -  । 筮 ० SQL*Forms  ᥣ,  祭
     ࠪ⨪  Automatic Hint.

:  ࠪ⨪  Automatic Hint  12-3
          Cﭨ ஢ન , Changed  3-7


⠭      ।  筮  ०  ஢筮  楩  
஢筮   㬮砭  . ᪮   ।
       ஢      ।,    ࠡ
                ஢묨  栬    -
              襣 ᫠  뢠.

᫨  ஥ ਪ ணࠬ,     ࠡ  ।
筮 ०,   ࠡ⠥  ।  ⥪⮢  ०, ᯮ
ࠡ  Set Block Validation as Default.    । , 
    ⢥  ஢筮  ,  砥  ᮧ 
஢ , ࠡ饩  ନ 筮 ०.

:    Set Block Validation as Default
          ஢筠   3-7

                                    -- 41 --




ᯮ짮-      㬮砭, , ஥㥬   । 筮
         ०,    ਬ  ஢    .
ਣ஢       १,    ஥ ,  
 筮     易⥫쭮  뢠,   SQL*Forms  ᪠ ⮫쪮
०        ਣ  ।   (..  Post-Field, Pre-Block) c ஢
              ࠧ襭   訬    ࠢ  ஢筮 .  ᫨ 
              ᯮ ஢    । 筮 ०, 
              冷,  ஬      , 
              㭪樥 ᯮ㥬  ନ.

              :  ਣ, ஢ ࠧ襭  4-2

      ᫨   ࠧࠡ뢠 ,     ࠡ
          ।  筮  ०,     ᮧ  
筮        ਤন ᫥ ࠢ:
०
-  ଥ ।  ᫥       ஡.  ⠪
  ଠ १ࢨ   䠩  ᢮, 饣  ⢠
  .  ᫨      ﬨ       ⥪⮢ ⠭⮩  
  ஡,    ଠ     㤥 믮.  ,     ᮧ
    㬮砭   ஡  ⠢  ⮬᪨.

- ࠩ  ᯮ    ⥪⮢ ⠭  ᫥
  ⮫ ࠭.

-    ⮬,    ⥪⮢ ⠭  ᯮ 
  ࠭  ७, ᪮     ਢ    訡  
  ᫥饨 ࠭.


ᯮ짮-        ନ,    ।  筮
         ०, ᯮ ப⪠ ࠭, ப稢
⥪⮢     楫  ࠭      ࠧ.    뢠
⠭      ⥫ , ᫨    ⥪⮢ ⠭
      ⮩   ப,      , ਭ饥    
०        ⢮  ᥩ.     ⮣    室 
              ࠭    ப⪥,  ⥪⮢  ⠭  ⠪ 祧 
                ७.  . 1    ⠪ 砩.

㭮 D-3   Ŀ
ப⪠                                                            
⥪⮢      Before Scrolling              After Scrolling         
⠭      Ŀ          Ŀ   
               Emplouer Emplouer           Emplouer Emplouer     
               Number   Name               Number   Name         
               7369     SMITH           >  7521     WARD       < 
               7499     ALLEN             7566     IONES       
                                                               
⮢                 
⠭    
襤訥                                                             
࠭        


        ஢ ।



                                    -- 42 --



   ᫨  ࠧࠡ뢠 ਪ  ணࠬ  SQL*Forms  ஢ ।,
   ଠ  ⮬, 祬 짮⥫᪨  䥩  ,
祬  ⥪⮢ ०.    ,  ࠧ   ᯮ짮
㭪樮  .

᫨  ࠧࠡ뢠 ਪ  ணࠬ SQL*Forms,   ࠡ
 ஢ ।,   ,     । (navigation),
᫨   ᯮ  .

       ஢ । 䥩 SQL*Forms (஥஢)
ᮯ殮      ⫨  ⮣   뢠  
 ஢   .  ਬ,  ஫      
।         ॠ   㭪  ᪮.  ࠧ
              ,  ᪮  SQL*Forms  ᯮ  
              ᮯ殮  ஢묨 ⥬  ࠫ쭮 ଥ.


㭪樮-   ஢ ।   짮 㭪樮묨
    蠬  SQL*Forms      믮   ⠭
 ஢   ஥⨢   㭪権.  ,     
।           ᯮ짮    믮  㭪権.

              [Select]         ࠭  㭪.
                            ⠪ ᯮ짮   祭 
                          몫祭 ஫쭮 .

               㣨  ᫨ 㭪樮  ᮮ⢥  
                          襬 ࠭,       ,
                          ᮮ⢥饩  㭪樨.

६饭   ᫨   ࠧࠡ뢠  ਪ ணࠬ  SQL*Forms
 ஢    ࠡ    ஢ ।,  ᮡ 
।           ࠪ⨪    Mouse  Navigation  Limit. 
              ࠪ⨪  ।,   (  ) 
                ᤥ  ⥪騬         .

               㬮砭,     ⦠ (click on) 
                .        ⠭  
                  ਪ  ணࠬ  ⢨  .




















                                    -- 43 --
