home *** CD-ROM | disk | FTP | other *** search
- ...
- ... $Header: release.doc,v 3001400.1 90/02/27 17:40:33 atam Exp $ release.doc Copyr (c) 1989 Oracle
- ...
- Release Bulletin
- SQL*Forms Version 3.0.14 (Production)
- February 26, 1990
-
- This bulletin contains important information about the production release of
- SQL*Forms. It is recommended that you read it before attempting to use this
- version. The bulletin includes function key mappings for this release for
- VT100 and VT200 terminals.
-
-
- New Features since Versions 2.0 and 2.3
- ---------------------------------------
- A complete list of new and changed features can be found in Appendix A of the
- SQL*Forms Designer's Reference Version 3.0. Major new features include:
-
- o Enhanced User Interface Portability
-
- o The SQL*Forms (Design) interface is completely revised and includes:
- o Streamlined Menu structure with pull-down menus
- o Ability to reference and copy application objects such as triggers
- o Ability to enforce referential integrity constraints
- o Context-sensitive online help
- o Enhanced Debug Mode
- o Integrated text editor
- o Automatic master-detail block coordination
-
- o PL/SQL Integration
-
- o Ability to integrate pull-down menus built with SQL*Menu
-
- o Enhanced SQL*Forms (Run Form) Capabilities:
- o Pop-up Pages, List-of-Values, and Field Editor
- o Format masks for formatting field contents
- o Dynamic field and display attributes
- o Mouse support for bitmap environments
-
-
- Documentation
- -------------
- Complete documentation is available with the release. All users are advised to
- obtain the most current documentation. The Version 3.0 documentation set
- includes:
-
- SQL*Forms Operator's Guide 3301-V3.0
- SQL*Forms Operator's Quick Reference 3704-V3.0
- SQL*Forms Designer's Tutorial 3302-V3.0
- SQL*Forms Designer's Quick Reference 3708-V3.0
- SQL*Forms Designer's Reference 3304-V3.0
- SQL*Forms Designer's Keyboard Card 755-V3.0
- SQL*Forms Operator's Keyboard Card 3906-V3.0
- Introduction to SQL*Forms and SQL*Menu 19192-V3
-
- For information on mapping function keys and video attributes or customizing
- key mappings, consult the Oracle*Terminal User's Guide, part no. 5206-V1.0.
-
- For complete information on PL/SQL, refer to the PL/SQL User's Guide and
- Reference, part no. 800-V1.0.
-
-
- Upgrading from Earlier Versions
- -------------------------------
- 1. Forms created prior to SQL*Forms Version 3.0 must have their .inp files
- converted, using CONVERT -Vxx, where xx is either 20 or 23, depending
- on if you are converting from Version 2.0 or 2.3 of SQL*Forms. Once the
- .inp files are converted to the Version 3.0 format, forms must be
- regenerated by using GENERATE form_name username/password. All forms
- created prior to Version 3.0.11 must be regenerated to be run against
- SQL*Forms Version 3.0.14.
-
- 2. For information on using Version 2 CRT files and key mappings with
- SQL*Forms 3.0, refer to the Key Mappings section below and the
- Oracle*Terminal Release Bulletin.
-
- 3. Oracle recommends that, if possible, you convert SQL*Forms Version 2.0
- forms to Version 2.3 forms, and then to Version 3.0 forms, rather than
- convert Version 2.0 forms directly to 3.0 forms. For information on
- this, refer to the README.SQLFORMS_UPGRADE release note that
- accompanies the Version 2.3 release. However, if you do convert
- Version 2.0 forms to Version 3.0, the convert utility has a new -f
- parameter that you may want to use. The -f parameter inserts the
- NOFAIL key-word after #exemacro in all trigger steps. For more
- information on the NOFAIL key-word, refer to the SQL*Forms
- Documentation Addendum Version 2.3.
-
- 4. To aid in your migration from SQL*Forms 2.3 to SQL*Forms 3.0, some of
- the symbols used to invoke SQL*Forms 2.3 have been retained for
- SQL*Forms 3.0. These symbols are IAC, IAD, IAG, IAP, RUNFORM,
- SQLFORMS, CONVERT, and GENERATE. While this prevents users from
- having to learn new ways to invoke SQL*Forms 3.0, it can cause
- problems for Oracle products which require SQL*Forms 2.3. These
- products include:
-
- CASE*Dictionary 4.1
- CASE*Generator for SQL*Forms 1.0
- CASE*Designer 1.1
- SQL*Menu 4.1
- Easy*SQL 2.3
- SQL*Plus 3.0
- SQL*TextRetrieval 1.1
-
- Before using any of these products, the user must type:
-
- @ORA_SQLFORMS:SQLFORMSUSER
-
- It might be convenient to have your system manager define this
- command as a symbol.
-
- After using this command and before using SQL*Forms 3.0 or
- SQL*Menu 5.0, the user must type:
-
- @ORA_SQLFORMS30:SQLFORMS30USER
-
- Alternatively, if you specify a "30" at the end of the above symbols
- (e.g. sqlforms30), they will run SQL*Forms 3.0, while a "23" will
- invoke SQL*Forms 2.3 (e.g. sqlforms23).
-
-
- Restrictions/Notes
- ------------------
- 1. All Oracle*Terminal resource files are stored in
- ORA_ROOT:[SQLFORMS30]oraterm.r. These files should not be moved or
- deleted.
-
- 2. On VMS systems, when SQL*Forms 3.0 is installed, the CONVERT and
- CONVERT30 symbols are created to invoke the SQL*Forms convert utility.
- As there is a DCL command that is also named CONVERT, you may wish
- to remove the SQL*Forms CONVERT symbol and just use the CONVERT30
- symbol to avoid any conflicts. Note that the SQL*Forms Designer's
- Reference only refers to CONVERT and not CONVERT30.
-
- 3. On page 23-4 of the SQL*Forms Designer's Reference, in the section
- named 'INP to INP Conversion' the text and the example are wrong.
- The example should read:
-
- CONVERT -v23 OLD OLD [username/password]
-
- where the second 'OLD' is the name of the old form that you want
- to convert.
-
- New Features in 3.0.14
- ----------------------
- 1. A new packaged procedure has been added which enables a form to
- 'activate' a menu in a character mode environment. The packaged
- procedure is:
-
- set_input_focus(MENU);
-
- where MENU is a constant. This procedure sets the input focus to the
- currently active menu. The next time SQL*Forms is ready to get input
- from the user in the current form (i.e. after trigger processing has
- completed), the menu will be active.
-
- 2. Four new link scripts were added to allow user-exits and Pro*C programs
- to be linked with SQL*Forms.
-
- (i) GLIAP: Link IAP executable with user-exit object files
-
- Usage: GLIAP <Object_List> [Options]
-
- Object_List: List of object modules that contain the user
- exit routines and EXITTABLE to be linked into
- IAP. Separate multiple modules with commas.
- DO NOT USE SPACES.
-
- Options: Link options identical to those given to
- LIAP. [S][D][M[F][X]]
-
- Example: GLIAP EXIT1,EXIT2 S
-
-
- (ii) PLIAP: Link IAP executable driven by a Pro*C program
-
- Usage: PLIAP <User_Program_List> <Executable_Name> [Options]
-
- User_Program_List: List of object modules that comprise
- the program to be linked with IAP.
- Separate multiple modules with commas.
- DO NOT USE SPACES.
-
- Executable_Name: Name of the executable image created
- by PLIAP.
-
- Options: Link options identical to those given
- to LIAP. [S][D][M[F][X]].
-
- Example: PLIAP MAIN,ROUTINE1,ROUTINE2 DEMO S
-
-
-
- (iii) PGLIAP: Link IAP executable driven by a Pro*C program that
- includes user-exits
-
- Usage: PGLIAP <User_Program_List> <Object_List>
- <Executable_Name> [Options]
-
- User_Program_List: List of object modules that comprise
- the program to be linked with IAP.
- Separate multiple modules with commas.
- DO NOT USE SPACES.
-
- Object_List: List of object modules that contain the
- user exit routines and EXITTABLE to be
- linked into IAP. Separate multiple
- modules with commas. DO NOT USE
- SPACES.
-
- Executable_Name: Name of the executable image created by
- PLIAP.
-
- Options: Link options identical to those given
- to LIAP. [S][D][M[F][X]]
-
- Example: PGLIAP MAIN,ROUTINE1,ROUTINE2 EXIT1,EXIT2 DEMO S
-
-
- (iv) GLAID: Link IAD executable with user-exit object files
-
- Usage: GLIAD <Object_List> [Options]
-
- Object_List: List of object modules that contain the user
- exit routines and EXITTABLE to be linked into
- IAD. separate multiple modules with commas.
- DO NOT USE SPACES.
-
- Options: Link options identical to those given to LIAD.
- [S][D][M[F][X]]
-
- Example: GLIAD EXIT1,EXIT2 S
-
-
-
- Changed Features in 3.0.14
- --------------------------
- 1. The CLEAR_FORM packaged procedure now has a second parameter which
- allows the form to do either a full rollback or a rollback to the
- current savepoint. The new procedure definition is:
-
- CLEAR_FORM
- (ASK_COMMIT | DO_COMMIT | NO_COMMIT | NO_VALIDATE,
- TO_SAVEPOINT | FULL_ROLLBACK);
-
- This affects the situation where a form is called from another form
- because SQL*Forms issues a savepoint when a form is called. This
- provides the developer with the option of either cancelling changes in
- the current called form only or all changes in this transaction.
-
- 2. The following SQL*Menu (Run Menu) keys were added to the VT100 and
- VT220 key mappings: Previous Menu, Main Menu, Enter Application
- Parameters, and Enter Menu Parameters. See the Key Mappings section
- at the end of this release bulletin for details. These same keys
- were added to the UPGRD100 and UPGRD220 key mappings as follows:
-
- Generic Function UPGRD220 UPGRD100
- -----------------------------------------------------------------
- Previous Menu F11 F11 Prev Screen, Esc F
- F11 F11 F9
- Main Menu F11 F11 F10 Esc G
- Enter Application Parameters F11 F11 Find Esc H
- Enter Menu Parameters F11 F11 Insert Here Esc T
-
- Note that for the above UPGRD100 and UPGRD220 SQL*Menu (Run Menu) key
- mappings, different keys had to be used than the original, older key
- mappings. This is because the older versions of SQL*Forms used the
- same keys as SQL*Menu and hence this conflict was resolved in favor of
- preserving the SQL*Forms key mappings.
-
- 3. When starting SQL*Forms (Design) or SQL*Forms (Run Form), the syntax
- for the command line switch used to specify a terminal mapping has
- changed. The new syntax is:
-
- -c filename:mapping
-
- where filename is the name of your Oracle*Terminal .R resource file and
- mapping is the name of the terminal mapping you wish to use. Some
- prior versions of SQL*Forms 3.0 used -c mapping:filename, which is no
- longer supported.
-
- 4. Prior to 3.0.14, if you renamed an .INP file and loaded it into
- SQL*Forms, a GENERATE would create an .INP file with the old name.
- SQL*Forms 3.0.14 will now use the name of the loaded file when
- generating, i.e., the default name values in the generate and execute
- dialog boxes will be the loaded filename, even if it is different
- from the form name.
-
-
- New Features in 3.0.13
- ----------------------------
- Four new packaged procedures have been added in 3.0.13 that did not get
- included in the documentation. These packaged procedures were added to make
- creation of the SQL*Forms default menu application possible with SQL*Menu
- Version 5.0. (The default menu is available as a sample SQL*Menu application
- starting in SQL*Menu Version 5.0.8.)
-
- The new packaged procedures are:
-
- CUT_REGION
- COPY_REGION
- PASTE_REGION
- DO_KEY
-
- CUT_REGION, COPY_REGION, and PASTE_REGION are the packaged procedure
- equivalents of the [Cut], [Copy], and [Paste] function keys, respectively.
-
- DO_KEY takes one argument, a string. The argument is a SQL*Forms packaged
- procedure name in single quotes. If a key trigger exists for the key
- corresponding to the packaged procedure specified, then the trigger will fire.
- If no key trigger exists, the packaged procedure will execute. This behavior
- is completely analogous to the user pressing the corresponding function key.
-
- For example, DO_KEY ('next_block') is equivalent to the user pressing
- the [Next Block] function key. If a Key-NXTBLK trigger exists, that
- trigger will fire; if there is no key trigger, the NEXT_BLOCK
- packaged procedure will be executed.
-
- Valid SQL*Forms packaged procedures to use with DO_KEY:
- =======================================================
- Packaged Procedure Trigger Type Associated Function Key
- ------------------ ------------ -----------------------
- ABORT_QUERY Key-EXIT [Abort Query]
- BLOCK_MENU Key-MENU [Block Menu]
- CLEAR_BLOCK Key-CLRBLK [Clear Block]
- CLEAR_FORM Key-CLRFRM [Clear Form]
- CLEAR_RECORD Key-CLRREC [Clear Record]
- COMMIT_FORM Key-COMMIT [Commit]
- COUNT_QUERY Key-CQUERY [Count Query Hits]
- CREATE_RECORD Key-CREREC [Create Record]
- DELETE_RECORD Key-DELREC [Delete Record]
- DOWN Key-DOWN [Down]
- DUPLICATE_FIELD Key-DUPFLD [Duplicate Field]
- DUPLICATE_RECORD Key-DUPREC [Duplicate Record]
- EDIT_FIELD Key-EDIT [Edit]
- ENTER Key-ENTER [Enter]
- ENTER_QUERY Key-ENTQRY [Enter Query]
- EXECUTE_QUERY Key-EXEQRY [Execute Query]
- EXIT_FORM Key-EXIT [Exit]
- HELP Key-HELP [Help]
- LIST_VALUES Key-LISTVAL [List]
- LOCK_RECORD Key-UPDREC [Lock Record]
- NEXT_BLOCK Key-NXTBLK [Next Block]
- NEXT_FIELD Key-NXTFLD [Next Field]
- NEXT_KEY Key-NXTKEY [Next Primary Key Fld]
- NEXT_RECORD Key-NXTREC [Next Record]
- NEXT_SET Key-NXTSET [Next Set of Records]
- PREVIOUS_BLOCK Key-PRVBLK [Next Block]
- PREVIOUS_FIELD Key-PRVFLD [Previous Field]
- PREVIOUS_RECORD Key-PRVREC [Previous Record]
- PRINT Key-PRINT [Print]
- SCROLL_DOWN Key-SCRDOWN [Scroll Down]
- SCROLL_UP Key-SCRUP [Scroll Up]
- UP Key-UP [Up]
-
-
- Changed Features in 3.0.13
- --------------------------
- 1. The following files in the SQL*Forms demo directory were changed
- because of porting restrictions on the lengths of file names:
-
- old ORA_ROOT:[SQLFORMS30.DEMO]sqlforms_demo.inp ==>
- 3.0.13 ORA_ROOT:[SQLFORMS30.DEMO]order.inp
-
- old ORA_ROOT:[SQLFORMS30.DEMO]sqlforms_customer.inp ==>
- 3.0.13 ORA_ROOT:[SQLFORMS30.DEMO]customer.inp
-
-
- 2. The following is a PC limitation extension in 3.0.13:
-
- There was a problem in Version 3.0.12 and before that limited the amount
- of text objects (field names, comments... and especially V2 trigger text) to
- 64k on the PC. These limitations have been expanded in Version 3.0.13 to
- 64k of all text objects OTHER THAN V2 trigger text, and 128k of just V2
- trigger text.
-
- Note: These limitations existed only on the PC where they use 2 byte
- offsets. The limitation on most machines (those with 4 byte offsets) is 4
- gigabytes for text objects other than V2 trigger text, and 8 gigabytes for V2
- trigger text alone.
-
-
- 3. UXWPUS pop-up window routine change:
-
- Before SQL*Forms 3.0.13 there was an inconsistency for the UXWPUS
- routine between the code and the documentation. This is especially
- important for all BETA sites to notice. The code had read:
-
- int uxwpus (window_pointer, char_string, length, x, y)
-
- It has been changed to be consistent with the documentation that reads:
-
- int uxwpus (window_pointer, char_string, x, y, length)
-
- The documentation now correctly explains the routine and its usage. Please
- refer to the chapter on User Exits in the SQL*Forms Designer's Reference
- Version 3.0 for complete information about the routine and its parameters.
-
-
- 4. Flash and Underline Escape Sequences Reversed
-
- The key mappings provided for SQL*Forms 3.0.12 and before used the
- escape sequence for flash and underline in error. Flash is 5m and underline
- is 4m. The VT100, VT220, UPGRD100, and UPGRD220 resource files for
- Version 3.0.13 have all been fixed. If you have copied and modified a
- resource file using Oracle*Terminal from Version 3.0.12 or before, you may
- want to correct this in your modified resource files.
-
-
- Key Mappings for SQL*Forms/SQL*Menu
- -----------------------------------
- As SQL*Forms 3.0 has added many new functions, the default key mappings have
- changed for both SQL*Forms (Design) and SQL*Forms (Run Form). For developers
- and operators familiar with the Version 2.0 and 2.3 key mappings for VT100 and
- VT220 terminals, the UPGRD100 and UPGRD220 key mappings are provided. To
- use these mappings, invoke SQL*Forms (Design) or SQL*Forms (Run Form) using
- the -c option. For example, to run a form using the Version 2 VT220 key
- mappings, you would use RUNFORM -C UPGRD220:UPGRD220 formname.
-
- For Oracle*Terminal terminal mappings, versions before SQL*Forms 3.0.13 opened
- a file with the same name as the mapping specified using the -c switch on the
- command line.
-
- In Version 3.0.14 and higher, SQL*Forms now opens the file ORATERM.R to read
- in all Oracle*Terminal resource files. This corresponds to the documentation.
-
- In addition, specifying -c FILENAME:MAPPING will read the terminal mapping
- from FILENAME.R. Hence old Oracle*Terminal resource files can be loaded by
- renaming the file ORATERM.R, or by this additional mechanism.
-
- For example, take a user-defined terminal mapping called MYVT100.R. In Version
- 3.0.12 and earlier, SQL*Forms 3.0 was started by specifying -c MYVT100 on the
- command line. In Version 3.0.14 there are two options:
-
- 1. Rename the file ORATERM.R and start SQL*Forms by specifying
- -c MYVT100 on the command line.
-
- 2. Specify -c MYVT100:MYVT100 on the command line
-
- The following mappings are for both SQL*Forms and SQL*Menu on VT100 and
- VT220 terminals.
-
- NOTE: These mappings are NEW starting with Version 3.0.12 of SQL*Forms, and
- Version 5.0.7 of SQL*Menu. The older mappings are now obsolete and will not be
- supported. The new mappings are called VT220.R and VT100.R.
-
- SQL*Forms (Design)/SQL*Menu (Design)
-
- Generic Function VT220 VT100
- ------------------------------------------------------
- Accept Do, Ctrl-O PF3, Ctrl-O
- Beginning of Line PF1 PF1 Left PF1 PF1 Left
- Bookmark PF1 Help PF1 PF2
- Cancel PF4, Ctrl-B PF4, Ctrl-B
- Change Display Type F11 Keypad-1
- Clear Field F17 Keypad-4
- Copy PF1 Find PF1 Keypad-.
- Copy Object F8 Keypad-8
- Cut PF1 Remove PF1 Keypad-3
- Define Field PF1 F17 Keypad-4
- Delete Backwards Bksp, Delete Bksp, Delete
- Delete Character Ctrl-D Ctrl-D
- Delete Line PF1 Delete PF1 Delete
- Delete Record Remove Keypad-3
- Down Down Down
- Draw Box/Line F19 Keypad-6
- End of Line PF1 PF1 Right PF1 PF1 Right
- First Line PF1 PF1 Up PF1 PF1 Up
- Help Help, Ctrl-W PF2, Ctrl-W
- Insert Record Insert Keypad-2
- Insert/Replace Ctrl-A Ctrl-A
- Last Line PF1 PF1 Down PF1 PF1 Down
- Left Left Left
- List Find, Ctrl-F Keypad-., Ctrl-F
- Menu F14, Ctrl-N, Ctrl-G Keypad-0, Ctrl-N, Ctrl-G
- Navigate F7 Keypad-7
- Next Block NextScrn Keypad--
- Next Field Return, Tab Return, Tab
- Next Page PF1 F10 PF1 Keypad-8
- Next Record PF1 NextScrn PF1 Keypad--
- Paste PF1 Insert PF1 Keypad-2
- Previous Block PrevScreen Keypad-9
- Previous Field PF1 Return, PF1 Tab PF1 Return, PF1 Tab
- Previous Page PF1 F9 PF1 Keypad-7
- Previous Record PF1 PrevScrn PF1 Keypad-9
- Print Ctrl-P Ctrl-P
- Refresh Ctrl-R Ctrl-R
- Resize Field F18 Keypad-5
- Right Right Right
- Screen Painter F12 PF1 PF3
- Scroll Down PF1-Down PF1 Down
- Scroll Left PF1-Left PF1 Left
- Scroll Right PF1-Right PF1 Right
- Scroll Up PF1-Up PF1 Up
- Search PF1-PF3 PF1 Enter
- Select Select, Ctrl-V Enter, Ctrl-V,
- sometimes Return sometimes Return
- Show Keys Ctrl-K Ctrl-K
- Undo F20 Keypad-,
- Up Up Up
- Zoom In F9 PF1 Keypad-6
- Zoom Out F10 PF1 Keypad-,
-
-
- SQL*Forms (Runform)/SQL*Menu (Run Menu)
-
- Generic Function VT220 VT100
- ------------------------------------------------------
- Application Menu F10 PF1 Keypad-,
- Background Menu F8 Keypad-8
- Beginning of Line PF1 PF1 Left PF1 PF1 Left
- Block Menu PF1 F14 PF1 Keypad-0
- Cancel PF4, Ctrl-B PF4, Ctrl-B
- Clear Block F19 PF1 Keypad-4
- Clear Field F17 Keypad-4
- Clear Form F20 PF1 Keypad-5
- Clear Record F18 Keypad-5
- Commit/Accept Do PF3
- Copy PF1 Find PF1 Keypad-.
- Count Query Hits PF3 PF1 PF3
- Cut PF1 Remove PF1 Keypad-3
- Debug Mode F9 PF1 Keypad-6
- Delete Backwards Delete Delete
- Delete Character Ctrl-D Ctrl-D
- Delete Line PF1 Delete PF1 Delete
- Delete Record Remove Keypad-3
- Display Error PF1 Help PF1 PF2
- Down Down Down
- Duplicate Field PF1 F11 PF1 PF1 PF2
- Duplicate Record PF1 F12 PF1 PF1 PF3
- Edit PF2 PF1 Keypad-1
- End of Line PF1 PF1 Right PF1 PF1 Right
- Enter Appl Params PF1 PF1 Find PF1 PF1 Keypad-5
- Enter Menu Params PF1 PF1 Insert PF1 PF1 Keypad-4
- Enter Query F11 Keypad-6
- Enter 1 OS Command PF1 F7 Not mapped
- Enter >1 OS Command F7 Keypad-7
- Execute Query F12 Keypad-,
- First Line PF1 PF1 Up PF1 PF1 Up
- Help Help, Ctrl-W PF2, Ctrl-W
- Insert Record Insert Keypad-2
- Insert/Replace Ctrl-A Ctrl-A
- Last Line PF1 PF1 Down PF1 PF1 Down
- Left Left Left
- List Find, Ctrl-F Keypad-., Ctrl-F
- Main Menu PF1 PF1 F10 PF1 PF1 Keypad-2
- Menu F14, Ctrl-N, Ctrl-G Keypad-0, Ctrl-N, Ctrl-G
- Next Block NextScrn Keypad--
- Next Field Return, Tab Return, Tab
- Next Primary Key PF1 F10 Not Mapped
- Next Record PF1 NextScrn PF1 Keypad--
- Next Set of Records PF1 F9 Not Mapped
- Paste PF1 Insert PF1 Keypad-2
- Previous Field PF1 Return, PF1 Return,
- PF1 Tab PF1 Tab
- Previous Block PrevScrn Keypad-4
- Previous Menu PF1 PF1 F9, PF1 PF1 Keypad-1
- PF1 PF1 PrevScrn
- Previous Record PF1 PrevScrn PF1 Keypad-9
- Print Ctrl-P Ctrl-P
- Redefine Usr/Pwd Ctrl-U Ctrl-U
- Refresh Screen Ctrl-R Ctrl-R
- Right Right Right
- Scroll Down PF1 Down PF1 Down
- Scroll Left PF1 Left PF1 Left
- Scroll Right PF1 Right PF1 Right
- Scroll Up PF1 Up PF1 Up
- Search PF1 Select PF1 Enter
- Select Select, Ctrl-V Enter, Ctrl-V
- Show BGM PF1 F8 PF1 Keypad-8
- Show Keys Ctrl-K Ctrl-K
- Up Up Up
- Where Display F13 PF1 Keypad-7
-