com!online 2002 April

home *** CD-ROM | disk | FTP | other *** search

/ com!online 2002 April / comcd0402.iso / vollver / adabas / f_0001 / env / easy2.enh < prev next >

Wrap

Text File | 1999-11-01 | 79.8 KB | 958 lines

ENG|03_ALTER | 0 EASY2.enh 10.05.01 1998-04-24 ENG|03_ALTER | 1| | A L T E R I N G T H E S T R U C T U R E O F A T A B L E ENG|03_ALTER | 3| | You can use this function key to alter the definition of the table the ENG|03_ALTER | 4| | description of which is displayed here; i.e.: ENG|03_ALTER | 6| | - you can drop existing columns either by removing the name or by ENG|03_ALTER | 7| | enclosing it in parentheses, ENG|03_ALTER | 9| | - you can add new columns. ENG|03_ALTER | 11| | To find out how you can do this, place the cursor on one of the input ENG|03_ALTER | 12| | fields and strike the HELP key. ENG|03_ALTER | 14| | Once you have entered the modifications in the form, confirm them with ENG|03_ALTER | 15|R | ALTER. ENG|03_ALTERADD | 1| | A D D I N G N E W T A B L E C O L U M N S ENG|03_ALTERADD | 3| | You can add new columns to the table the description of which is ENG|03_ALTERADD | 4| | currently displayed. ENG|03_ALTERADD | 6| | To do so, simply fill in the free rows in the sample form as if you ENG|03_ALTERADD | 7| | were creating a new table. Begin with the first row after the last ENG|03_ALTERADD | 8|R | existing column. ENG|03_ALTERDROP| 1| | DROPPING / RENAMING ENG|03_ALTERDROP| 2| | TABLE COLUMNS ENG|03_ALTERDROP| 4| | 1) As long as you are the owner of ENG|03_ALTERDROP| 5| | the table the description of ENG|03_ALTERDROP| 6| | which is currently displayed, you ENG|03_ALTERDROP| 7| | may drop individual table columns ENG|03_ALTERDROP| 8| | from it. ENG|03_ALTERDROP| 10| | To do so, overwrite the n a m e ENG|03_ALTERDROP| 11| | of the respective column with ENG|03_ALTERDROP| 12| | blanks or enclose it in ENG|03_ALTERDROP| 13| | parentheses. ENG|03_ALTERDROP| 15| | Columns that belong to the key ENG|03_ALTERDROP| 16| | cannot be dropped. ENG|03_ALTERDROP| 18| | 2) You can rename columns. To do so, ENG|03_ALTERDROP| 19| | simply write a new name over the ENG|03_ALTERDROP| 20| | existing one. ENG|03_ALTERDROP| 22| | This operation may take a very ENG|03_ALTERDROP| 23| | long time, when tables are ENG|03_ALTERDROP| 24|R | concerned which have many views. ENG|03_AMBI_JOIN| 1| | You made the attempt to use the same identifier several times to ENG|03_AMBI_JOIN| 2|R | establish a join. Simply choose another identifier for another join. ENG|03_ATR_N_FND| 1| | The name or number specified for an attribute in the field ENG|03_ATR_N_FND| 2| | Attribute: ............... does not exist. ENG|03_ATR_N_FND| 4|R | Correct the name or number and try it again. ENG|03_BACK | 1| | B A C K K E Y ENG|03_BACK | 4| | Use the BACK key to cancel the operation. You will then return to the ENG|03_BACK | 5|R | export/import menu. ENG|03_BACK_MASK| 1| | B A C K T O T H E F O R M E D I T O R ENG|03_BACK_MASK| 5| | This key returns you to the editor where you can modify your form or view ENG|03_BACK_MASK| 6|R | definition. ENG|03_CH_EMASK | 1| | Here you may define a view, modify your EASY request form, or change from ENG|03_CH_EMASK | 2| | the standard form of an existing table to a user-defined form. ENG|03_CH_EMASK | 4| | You either see the description of the request form as you defined it or ENG|03_CH_EMASK | 5| | the description of the standard form as EASY would create it because of ENG|03_CH_EMASK | 6| | the table definition. To limit the input fields the currently valid ENG|03_CH_EMASK | 7| | delimiter &1 is used. ENG|03_CH_EMASK | 8| | In contrast to the new definition of the form, the internal field names ENG|03_CH_EMASK | 9| | EASY generated for the table definition are displayed as well: ENG|03_CH_EMASK | 11| | *----------------------------------------------------* ENG|03_CH_EMASK | 12| | ! Name: _NAME ! ENG|03_CH_EMASK | 13| | ! Firstname: _FIRSTNAME ! ENG|03_CH_EMASK | 14| | ! Domicile: _DOMICILE _ZIP ! ENG|03_CH_EMASK | 16| | This form can be redesigned according to your new requirements. The ENG|03_CH_EMASK | 17| | following rules apply: ENG|03_CH_EMASK | 20| | - A table column will be dropped from the database, when its field name ENG|03_CH_EMASK | 21| | (not the field identifier) is removed from the form definition. ENG|03_CH_EMASK | 23| | - The definition of a new field also creates a new column in the ENG|03_CH_EMASK | 24| | database. (Especially when a field name is modified, the old database ENG|03_CH_EMASK | 25| | column will be removed and a new one be created.) ENG|03_CH_EMASK | 27| | - All the other modifications only result in a different layout of the ENG|03_CH_EMASK | 28| | request form, but they do not change the definition of the pertinent ENG|03_CH_EMASK | 29| | database table. ENG|03_CH_EMASK | 31| | Example: ENG|03_CH_EMASK | 33| | *----------------------------------------------------* ENG|03_CH_EMASK | 34| | ! Name: _NAME ! ENG|03_CH_EMASK | 35| | ! City: _DOMICILE Zip: _ZIP ! ENG|03_CH_EMASK | 36| | ! Street: _ House No: ! ENG|03_CH_EMASK | 39| | Here the input field "FIRSTNAME" will be dropped from the database, ENG|03_CH_EMASK | 40| | whereas two new fields with the field identifiers "Street" and "House ENG|03_CH_EMASK | 41|R | No:" will be created in the database table. ENG|03_CH_VIEW | 1| | C H A N G I N G O V E R T O A V I E W ENG|03_CH_VIEW | 3| | You may use the current table as base table for a view. Then you can ENG|03_CH_VIEW | 4| | define another request form, where, for example, input fields are omitted ENG|03_CH_VIEW | 5| | without deleting the corresponding data values from the base table. ENG|03_CH_VIEW | 7| | EASY will prompt you for the name of the view by displaying another input ENG|03_CH_VIEW | 8| | field. ENG|03_CH_VIEW | 10|R | Attention: You cannot add new fields to a view. ENG|03_COL_DROPD| 1| | You removed at least one input field from your form. Consequently, a ENG|03_COL_DROPD| 2| | column will be dropped from the pertinent database table and the ENG|03_COL_DROPD| 3| | existing data will be lost. ENG|03_COL_DROPD| 5| | If this effect is desired, strike FORM-OK twice; but if you want to ENG|03_COL_DROPD| 6| | define a new form with less columns and without loosing your data, then ENG|03_COL_DROPD| 7|R | use the VIEW key in order to create a view on this table. ENG|03_COL_IDENT| 1| | The form which you attempted to import does not match the existing ENG|03_COL_IDENT| 2| | table. The reason may be that the lengths and/or the names of the ENG|03_COL_IDENT| 3| | columns have been changed or that the columns have been deleted. If, ENG|03_COL_IDENT| 4| | nevertheless, you want to import this form, first create a table which ENG|03_COL_IDENT| 5|R | suits this form. ENG|03_COMPAREOP| 1| | Here you can specify a pattern that will tell EASY how the result shall ENG|03_COMPAREOP| 2| | look like: ENG|03_COMPAREOP| 4| | &5 equal x ENG|03_COMPAREOP| 5| | &6 not equal x ENG|03_COMPAREOP| 6| | &1 less than x ENG|03_COMPAREOP| 7| | &3 greater than x ENG|03_COMPAREOP| 8| | &4 not less than x ENG|03_COMPAREOP| 9| | &2 not greater than x ENG|03_COMPAREOP| 10| | &8 x or y or z (more arguments are allowed) ENG|03_COMPAREOP| 11| | &9 between x and y ENG|03_COMPAREOP| 12| | &10 sounds like x ENG|03_COMPAREOP| 13| | &7 not x (e.g. in combination with "between") ENG|03_COMPAREOP| 15| | In the field where the cursor was placed, "x" must be replaced by a ENG|03_COMPAREOP| 16| | value, e.g. &11 . ENG|03_COMPAREOP| 18|R | Striking the enter key will transfer this sample value to your form. ENG|03_CONFIRM | 1| | P E R F O R M I N G U P D A T E S ENG|03_CONFIRM | 4| | You can leave the report format with the CONFIRM key. ENG|03_CONFIRM | 6| | EASY will perform the updates and inserts you made in the report format ENG|03_CONFIRM | 7|R | in the database table. ENG|03_CREATE | 1| | C R E A T I N G A N E W T A B L E ENG|03_CREATE | 3| | You can create a new table by filling in the input fields in the ENG|03_CREATE | 4| | following way: Enter the name of the desired column in the utmost left ENG|03_CREATE | 5| | column. It must - like the table name - begin with a letter. To get ENG|03_CREATE | 6| | information about the other entries, place the cursor on the ENG|03_CREATE | 7| | corresponding column and strike the HELP key. ENG|03_CREATE | 9| | Once you have filled in the complete form, confirm your order with the ENG|03_CREATE | 10|R | NEW-DEF key. ENG|03_DCHANGED | 1| | Another user updated the result that you wanted to delete. ENG|03_DCHANGED | 2|R | You see now the current values. ENG|03_DEL | 1| | D E L E T I N G F O R M S / N A M E D R E Q U E S T S ENG|03_DEL | 3| | You can delete forms/named requests which you do not need any longer by ENG|03_DEL | 4| | means of this function key. But you have to mark their names beforehand ENG|03_DEL | 5| | by means of the MARK key. ENG|03_DEL | 7| | Striking the DELETE key twice will delete all the marked forms/named ENG|03_DEL | 8|R | requests. ENG|03_DELSTOCOM| 1| | D E L E T I N G A N A M E D R E Q U E S T ENG|03_DELSTOCOM| 3| | Named requests which you do not need any longer can be deleted out of ENG|03_DELSTOCOM| 4| | this menu. To do so, enter the name or number of the named request in the ENG|03_DELSTOCOM| 5| | input field ENG|03_DELSTOCOM| 7| | Named request: ........................... ENG|03_DELSTOCOM| 9| | in the bottom left corner or place the cursor on the desired request in ENG|03_DELSTOCOM| 10| | the menu. Then press the DELETE key. ENG|03_DELSTOCOM| 12| | Note: When you drop the entire table via EASY (table administration ENG|03_DELSTOCOM| 13| | mode), then EASY removes a l l pertinent requests, so you ENG|03_DELSTOCOM| 14|R | do not need to delete them one by one. ENG|03_DETAIL | 1| | M A S T E R - D E T A I L ENG|03_DETAIL | 3| | You may have the selected table displayed in a master-detail ENG|03_DETAIL | 4| | representation by means of the DETAIL key (in the request form only) or ENG|03_DETAIL | 5| | by entering DET in the function field. ENG|03_DETAIL | 7| | The master-detail representation can be called from three places: ENG|03_DETAIL | 9| | - From the request form by means of the DETAIL key. If this key is not ENG|03_DETAIL | 10| | displayed in the form, then there is no foreign key to another table. ENG|03_DETAIL | 11| | - From the result form by entering DET in the function field. In this ENG|03_DETAIL | 12| | case you will only see the detail rows of the displayed result. ENG|03_DETAIL | 13| | - From the report format by entering DET either in the prefix area of the ENG|03_DETAIL | 14| | desired row or in the function field (the first row on display will be ENG|03_DETAIL | 15| | used as current detail row). ENG|03_DETAIL | 17|R | For more extensive information please refer to the manual. ENG|03_DOUBL_DEL| 1| | You pressed the DELETE or UPDATE key, but the entry had just been ENG|03_DOUBL_DEL| 2| | deleted by you or another user. ENG|03_DOUBL_DEL| 4|R | If you want to insert the displayed values, strike the INSERT key. ENG|03_DOWN | 1| | S C R O L L I N G D O W N W A R D S ENG|03_DOWN | 3| | If the processing form for a table does not fit on a screen, EASY will ENG|03_DOWN | 4| | display the first page of the form. ENG|03_DOWN | 6|R | This function enables you to move downwards page by page. ENG|03_DTYPE | 1| | The value of this column must correspond to the example value: ENG|03_DTYPE | 3| | &1 ENG|03_DTYPE | 5|R | Striking the enter key will transfer this sample value to your form. ENG|03_DUP_KEY | 1| | You entered a column number twice in the input fields for the key field ENG|03_DUP_KEY | 2|R | specifications. ENG|03_EASYMASK | 1| | Here you can define a table with user-defined request form or create a ENG|03_EASYMASK | 2| | view. ENG|03_EASYMASK | 4| | Details about the creation of views can be found in the chapter 'Creating ENG|03_EASYMASK | 5| | a View' of the EASY manual. ENG|03_EASYMASK | 7| | To define a table with a user-defined request form proceed as follows: ENG|03_EASYMASK | 9| | Each character that you enter here (exceptions see below) will occur in ENG|03_EASYMASK | 10| | the request form. You can, for example, border your form with lines or ENG|03_EASYMASK | 11| | define field identifiers. ENG|03_EASYMASK | 13| | Example: ENG|03_EASYMASK | 15| | *----------------------------------------------------* ENG|03_EASYMASK | 16| | ! Name: ! ENG|03_EASYMASK | 17| | ! Firstname: ! ENG|03_EASYMASK | 19| | If such a field identifier (e.g. "Name:") ends with a colon, EASY ENG|03_EASYMASK | 20| | establishes an input field after it. Later you can enter search words or ENG|03_EASYMASK | 21| | new values into this field. EASY inserts a blank between the colon of the ENG|03_EASYMASK | 22| | field identifier and the input field. ENG|03_EASYMASK | 24| | You can also define the beginning of an input field by means of the ENG|03_EASYMASK | 25| | underscore ("_"). Thus it is possible to define an input field without a ENG|03_EASYMASK | 26| | field identifier specification and to align the input fields within the ENG|03_EASYMASK | 27| | form. ENG|03_EASYMASK | 29| | An input field ends either at the screen margin, or a position before the ENG|03_EASYMASK | 30| | next specified character, or at the place defined by the delimiter "&1". ENG|03_EASYMASK | 31| | The delimiter will not be output in the request form. It can be modified ENG|03_EASYMASK | 32| | via the SET menu. ENG|03_EASYMASK | 34| | Example: ENG|03_EASYMASK | 36| | *----------------------------------------------------* ENG|03_EASYMASK | 37| | ! Name: _ &1 ! ENG|03_EASYMASK | 38| | ! Firstname: _ &1 ! ENG|03_EASYMASK | 39| | ! Domicile : _ _ ! ENG|03_EASYMASK | 41| | In the example above the first input field after "Domicile" could, e.g., ENG|03_EASYMASK | 42| | take up the name of the domicile, whereas the second input field could be ENG|03_EASYMASK | 43| | meant for the zip code. ENG|03_EASYMASK | 45| | EASY gives a name to every input field in order to define a database ENG|03_EASYMASK | 46| | table by it. But if you like, you can define your own names for one or ENG|03_EASYMASK | 47| | more input fields. Such a name has to be placed ENG|03_EASYMASK | 48| | d i r e c t l y a f t e r the underscore that identifies the ENG|03_EASYMASK | 49| | beginning of the input field. ENG|03_EASYMASK | 51| | Example: ENG|03_EASYMASK | 53| | ! ... ... ! ENG|03_EASYMASK | 54| | ! Domicile: _domicile _zip ! ENG|03_EASYMASK | 56| | This name does not occur in the request form, but it will be displayed in ENG|03_EASYMASK | 57| | output generated via QUERY, for example. ENG|03_EASYMASK | 60| | It is convenient to provide input fields in a form with so-called field ENG|03_EASYMASK | 61| | numbers, these are numbers in a range between 1 and 254. ENG|03_EASYMASK | 63| | You can use these field numbers ENG|03_EASYMASK | 65| | - to define key fields, ENG|03_EASYMASK | 66| | - to enable a sort of the fields in later database requests, ENG|03_EASYMASK | 67| | - to specify cross references between two or more input fields in later ENG|03_EASYMASK | 68| | requests. ENG|03_EASYMASK | 70| | Example: ENG|03_EASYMASK | 72| | *----------------------------------------------------* ENG|03_EASYMASK | 73| | ! 1 Name: _ ! ENG|03_EASYMASK | 74| | ! 2 Firstname: _ ! ENG|03_EASYMASK | 77| | In both cases the field number refers to the next following input field ENG|03_EASYMASK | 78| | of the request form (in our example "1" refers to "Name", "2" to ENG|03_EASYMASK | 79| | "Firstname"). ENG|03_EASYMASK | 81| | To define your form you will dispose of the full ADABAS editor ENG|03_EASYMASK | 82|R | functionality. ENG|03_EMASK_TYP| 1| | E X A M P L E V A L U E F O R A C O L U M N ENG|03_EMASK_TYP| 3| | Here you specify an example for the values of this form field. EASY ENG|03_EMASK_TYP| 4| | generates the data type from it and from the field length. (Numeric ENG|03_EMASK_TYP| 5| | fields require one additional digit for the sign!) If you do not need ENG|03_EMASK_TYP| 6| | the whole field length for the data type, you should delimit the ENG|03_EMASK_TYP| 7| | example by "&7" . ENG|03_EMASK_TYP| 9| | &1 decimal number without fractional part ENG|03_EMASK_TYP| 10| | &2 decimal number with 2 fractional digits ENG|03_EMASK_TYP| 11| | &3 floating point number ENG|03_EMASK_TYP| 12| | &4 character string ENG|03_EMASK_TYP| 13| | &5 date type ENG|03_EMASK_TYP| 14| | &6 time type ENG|03_EMASK_TYP| 16| | Quotes may be omitted for character strings built of letters. ENG|03_EMASK_TYP| 18| | As an alternative to the above example, you may also specify ENG|03_EMASK_TYP| 19| | the following keywords for the date or time type. ENG|03_EMASK_TYP| 21| | DATE date type ENG|03_EMASK_TYP| 22|R | TIME time type ENG|03_EMP_STOCL| 1|R | There is no named request defined for this table. ENG|03_EXAMPLE | 1| | E X A M P L E V A L U E F O R A C O L U M N ENG|03_EXAMPLE | 3| | Here you specify an example for the values of this table column. EASY ENG|03_EXAMPLE | 4| | generates the column type from it. ENG|03_EXAMPLE | 6| | &1 decimal number without fractional part ENG|03_EXAMPLE | 7| | &2 decimal number with 2 fractional digits ENG|03_EXAMPLE | 8| | &3 floating point number ENG|03_EXAMPLE | 9| | &4 character string ENG|03_EXAMPLE | 10| | &5 date type ENG|03_EXAMPLE | 11| | &6 time type ENG|03_EXAMPLE | 13| | Quotes may be omitted for character strings built of letters. ENG|03_EXAMPLE | 15| | As an alternative to the above example, you may also specify ENG|03_EXAMPLE | 16| | the following keywords for the date or time type. ENG|03_EXAMPLE | 18| | DATE date type ENG|03_EXAMPLE | 19|R | TIME time type ENG|03_EXIT | 1| | E X I T I N G T H E S E S S I O N ENG|03_EXIT | 5|R | You may leave EASY by means of this function. ENG|03_EXP | 1| | E X P O R T I N G F O R M S / N A M E D R E Q U E S T S ENG|03_EXP | 3| | To be able to export forms or named requests you must mark their NAMES ENG|03_EXP | 4| | beforehand by means of the MARK key. ENG|03_EXP | 6| | Then strike the EXPORT key. EASY will prompt for the name of the file ENG|03_EXP | 7| | where the forms or named requests to be exported are to be stored: ENG|03_EXP | 9| | Filename: .................... ENG|03_EXP | 11| | After specifying the filename and restriking the EXPORT key, the export ENG|03_EXP | 12| | operation will begin. During the export operation EASY will display the ENG|03_EXP | 13| | name of the form or named request currently exported. As soon as the ENG|03_EXP | 14|R | export operation is terminated, EASY returns to the export/import menu. ENG|03_FCT_AMBIG| 1| | You may abbreviate the function name, when you specify it in the field ENG|03_FCT_AMBIG| 2| | "Function: ........." ENG|03_FCT_AMBIG| 4| | But you must specify at least as many characters as are necessary to ENG|03_FCT_AMBIG| 5|R | avoid confusion with another function. ENG|03_FCT_UNKNO| 1| | In the field "Function: ........." you can specify ENG|03_FCT_UNKNO| 3| | - functions which are displayed in the function menu. ENG|03_FCT_UNKNO| 4| | - a function and then press the HELP key in order to get some ENG|03_FCT_UNKNO| 5| | information about it. ENG|03_FCT_UNKNO| 6| | - "DETAIL" in order to call a foreign key, when you are in request or ENG|03_FCT_UNKNO| 7| | in result mode. ENG|03_FCT_UNKNO| 8| | - an "!". This informs EASY that you want to execute an operating ENG|03_FCT_UNKNO| 9| | system command. After command execution, the system returns to EASY. ENG|03_FCT_UNKNO| 10|R | - "EXIT" in order to leave EASY at once. ENG|03_FILENAME | 1| | O U T P U T T O A F I L E ENG|03_FILENAME | 3| | You can write the output of your results, just as you see it on the ENG|03_FILENAME | 4| | screen, into a file. ENG|03_FILENAME | 6| | To do so, specify the name of the file where the result is to be stored ENG|03_FILENAME | 7|R | in the input field. ENG|03_FO_WR_CUR| 1| | To select the TOTAL or SUBTOTAL option, place the cursor on the line ENG|03_FO_WR_CUR| 2| | with the desired table column name and strike the corresponding ENG|03_FO_WR_CUR| 3| | function key. ENG|03_FO_WR_CUR| 5|R | In your case the cursor was in a wrong line. ENG|03_FULL_BUFF| 1| | EASY works with internal memory areas. It stores the names and values ENG|03_FULL_BUFF| 2| | of the table columns there. Since this storage is limited, it may not ENG|03_FULL_BUFF| 3| | be sufficient when large tables are processed. ENG|03_FULL_BUFF| 5| | This can occur either .... ENG|03_FULL_BUFF| 6| | ...immediately after selecting the table; then not all ENG|03_FULL_BUFF| 7| | the columns can be taken into account, or ... ENG|03_FULL_BUFF| 8| | ...after input made on the screen; in this case ENG|03_FULL_BUFF| 9|R | the last entry was ignored. ENG|03_HELPERR | 1|R | There is no information available about this subject. ENG|03_IMP | 1| | S T A R T I N G A N I M P O R T R U N ENG|03_IMP | 3| | With the IMPORT key you select the function import of forms/named ENG|03_IMP | 4| | requests. You will be prompted for the name of the file containing the ENG|03_IMP | 5| | definitions: ENG|03_IMP | 7| | Filename: .................... ENG|03_IMP | 9| | After specifying the filename and restriking the IMPORT key, the import ENG|03_IMP | 10|R | operation will begin. ENG|03_IMP_SKIP | 1| | S K I P P I N G A F O R M / N A M E D R E Q U E S T ENG|03_IMP_SKIP | 3| | You can skip the incorrect form or named request by means of the SKIP ENG|03_IMP_SKIP | 4| | key. ENG|03_IMP_SKIP | 6|R | EASY will continue the import operation with the next form/named request. ENG|03_I_STC_EXI| 1| | The named request you attempted to import already exists. You can use ENG|03_I_STC_EXI| 2| | the IMPORT key to import it. You will thereby overwrite the existing ENG|03_I_STC_EXI| 3| | request. With CONTINUE you can skip this request and continue working ENG|03_I_STC_EXI| 4|R | with the next named request, if any. ENG|03_KEYS | 1| | D E C L A R I N G K E Y F I E L D S ENG|03_KEYS | 3| | When you create a table, you may also declare a key for it. ENG|03_KEYS | 5| | In EASY the key may be composed of 15 table columns at the most. Enter ENG|03_KEYS | 6| | the field numbers of these columns into the input fields after ENG|03_KEYS | 7| | KEY: ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ENG|03_KEYS | 9| | The values of the key fields (combined, if necessary) may occur only ENG|03_KEYS | 10| | once in the table: They identify a specific table entry. ENG|03_KEYS | 12| | Example: ENG|03_KEYS | 14|R | KEY: 1.. 3.. ... ... ... ... ... ... ... ... ... ... ... ... ... ENG|03_LEFT | 1| | S C R O L L I N G T O T H E L E F T ENG|03_LEFT | 3| | If the processing form for a table does not fit on a screen, EASY will ENG|03_LEFT | 4| | only display a section of the form page. ENG|03_LEFT | 6| | This function enables you to move to the left of the form section by ENG|03_LEFT | 7|R | section. ENG|03_LENGTH | 1| | W I D T H O F T H E T A B L E C O L U M N ENG|03_LENGTH | 3| | Here you specify the number of digits that values of the database ENG|03_LENGTH | 4| | column will have at the most: ENG|03_LENGTH | 6| | character strings : length between 1 and 254 ENG|03_LENGTH | 7| | decimal numbers : digits before and after the decimal, max. 18 ENG|03_LENGTH | 8| | floating point numbers : mantissa length, max. 18 ENG|03_LENGTH | 10| | For date and time values the length specification may be omitted. It ENG|03_LENGTH | 11| | will be determined automatically by means of the date and time formats ENG|03_LENGTH | 12|R | defined in the SET menu. ENG|03_LIST_ATTR| 1| | S E L E C T I N G A N A T T R I B U T E ENG|03_LIST_ATTR| 3| | EASY displays a menu containing all the attributes of the current ENG|03_LIST_ATTR| 4| | setting. ENG|03_LIST_ATTR| 6| | If you want to select one of the displayed attributes, enter the name or ENG|03_LIST_ATTR| 7| | the number of the attribute into the input field ENG|03_LIST_ATTR| 9| | Attribute: ........................... ENG|03_LIST_ATTR| 11| | at the bottom left or simply put the cursor on the attribute name in the ENG|03_LIST_ATTR| 12| | menu. ENG|03_LIST_ATTR| 14|R | The attribute will then be selected by means of ATTRIBUTE. ENG|03_LIST_LINK| 1| | S E L E C T I N G A F O R E I G N - K E Y ENG|03_LIST_LINK| 3| | Here EASY displays a menu that shows all existing foreign keys which are ENG|03_LIST_LINK| 4| | defined on the current table. ENG|03_LIST_LINK| 6| | If you want to call one of the displayed foreign keys, specify the name ENG|03_LIST_LINK| 7| | or number of this foreign key in the input field ENG|03_LIST_LINK| 9| | Foreign-Key: ........................... ENG|03_LIST_LINK| 11| | in the bottom left corner or place the cursor on the foreign key name in ENG|03_LIST_LINK| 12| | the menu. ENG|03_LIST_LINK| 14| | DETAIL will then provide you with the detail rows selected from the other ENG|03_LIST_LINK| 15| | table which is defined via the foreign key. ENG|03_LIST_LINK| 17| | If you are allowed to call so many foreign keys that the menu will not be ENG|03_LIST_LINK| 18| | clearly arranged, you may see a subset of these foreign keys. For this ENG|03_LIST_LINK| 19| | purpose specify a pattern which the desired foreign key names are to ENG|03_LIST_LINK| 20| | begin with in the input field Foreign-Key: .................. ENG|03_LIST_LINK| 22| | Foreign-Key: co*........... will, for example, display the foreign keys ENG|03_LIST_LINK| 23| | CUSTOMER_RESERVATION and CUSTOMER_HOTEL. ENG|03_LIST_LINK| 25|R | Important: The asterisk may only occur at the end of this pattern !! ENG|03_LIST_STOC| 1| | S E L E C T I N G T H E N A M E D R E Q U E S T ENG|03_LIST_STOC| 3| | Here EASY displays a menu that shows all existing named requests you are ENG|03_LIST_STOC| 4| | allowed to call. ENG|03_LIST_STOC| 6| | If you want to call one of the displayed named requests, specify the name ENG|03_LIST_STOC| 7| | or number of this request in the input field ENG|03_LIST_STOC| 9| | Named request: ........................... ENG|03_LIST_STOC| 11| | in the bottom left corner or place the cursor on the request name in the ENG|03_LIST_STOC| 12| | menu. ENG|03_LIST_STOC| 14| | Striking SELECT will show you the request result in file card format, ENG|03_LIST_STOC| 15| | REPORT will show it in REPORT format, whereas the enter key or NAMED-RQ ENG|03_LIST_STOC| 16| | key will display the request which can be changed, if necessary. ENG|03_LIST_STOC| 18| | If you are allowed to call so many named requests that the menu will not ENG|03_LIST_STOC| 19| | be clearly arranged, you may see a subset of these requests. For this ENG|03_LIST_STOC| 20| | purpose specify a pattern which the desired request names are to begin ENG|03_LIST_STOC| 21| | with in the input field Named request: .................. ENG|03_LIST_STOC| 23| | Named request: north*........... will, for example, display the ENG|03_LIST_STOC| 24| | requests NORTHUMBERLAND and NORTHWEST GERMANY defined on the table HOTEL. ENG|03_LIST_STOC| 26|R | Important: The asterisk may only occur at the end of this pattern !! ENG|03_LNK_N_FND| 1| | The name or number specified for a foreign key in the field Foreign- ENG|03_LNK_N_FND| 2| | Key: ............... does not exist. ENG|03_LNK_N_FND| 4|R | Correct the name or the number and try it again. ENG|03_LONG_FIEL| 1| | You intended to define a column either as a character string or a ENG|03_LONG_FIEL| 2| | decimal number or a floating point number. But the value you specified ENG|03_LONG_FIEL| 3| | for its length or precision is too large. ENG|03_LONG_FIEL| 5| | The valid maximum values are: ENG|03_LONG_FIEL| 7| | character strings : 254 characters ENG|03_LONG_FIEL| 8| | decimal numbers : digits before and after the decimal, max. 18 ENG|03_LONG_FIEL| 9|R | floating point numbers : mantissa length, max. 18 ENG|03_MANY_BTBL| 1| | In EASY you may define views on two base tables at the most. ENG|03_MANY_BTBL| 3| | If you intend to create a view on more than 2 tables, first define a ENG|03_MANY_BTBL| 4|R | view on two tables, then use this view to define a second view etc. ENG|03_MANY_LEAD| 1| | You can define the total or subtotal function and a text specification ENG|03_MANY_LEAD| 2| | before or after numeric output for 8 database columns ENG|03_MANY_LEAD| 3|R | a t t h e m o s t . ENG|03_MANY_REP | 1| | The number of formatting requests which you may define here is limited. ENG|03_MANY_REP | 3| | The formattings which cannot be taken into account have not been ENG|03_MANY_REP | 4|R | included in your formatting form. ENG|03_MARK | 1| | M A R K I N G N A M E S ENG|03_MARK | 3| | To be able to export forms or named requests, you have to mark them ENG|03_MARK | 4| | previously. You can do this in two ways: ENG|03_MARK | 6| | - mark each form/named request ENG|03_MARK | 7| | - mark all forms/named requests ENG|03_MARK | 9| | By means of the cursor position you can determine which of these options ENG|03_MARK | 10| | will be used. ENG|03_MARK | 12| | To mark each single form or named request, place the cursor on the name ENG|03_MARK | 13| | of that form or named request you want to export. Then strike the MARK ENG|03_MARK | 14| | key. The marked name will be provided with a hash sign and be highlighted ENG|03_MARK | 15| | on display. ENG|03_MARK | 17| | To mark all names, place the cursor on a field outside the list of names, ENG|03_MARK | 18| | e.g. on the field ENG|03_MARK | 20| | Pattern: ................... ENG|03_MARK | 22| | With the MARK key you then mark all names that are displayed within the ENG|03_MARK | 23|R | menu. ENG|03_MASK_ALTE| 1| | A L T E R I N G T H E F O R M ENG|03_MASK_ALTE| 2| | O R V I E W D E F I N I T I O N ENG|03_MASK_ALTE| 5|R | This key confirms and terminates the alteration of your form or view. ENG|03_MASK_CREA| 1| | C R E A T I N G A V I E W O R T A B L E W I T H ENG|03_MASK_CREA| 2| | A U S E R - D E F I N E D R E Q U E S T F O R M ENG|03_MASK_CREA| 5|R | This key confirms and terminates the creation of your form or view. ENG|03_MASK_EXP | 1| | E X P O R T I N G A N D I M P O R T I N G ENG|03_MASK_EXP | 2| | F O R M S ENG|03_MASK_EXP | 4| | This function enables you to change to a menu where you can either store ENG|03_MASK_EXP | 5| | your self-defined request forms in a file or read stored forms from a ENG|03_MASK_EXP | 6|R | file. ENG|03_MASK_OK | 1| | C O N F I R M I N G T H E F O R M ENG|03_MASK_OK | 2| | O R V I E W D E F I N I T I O N ENG|03_MASK_OK | 4| | You terminate the first part of your form or view definition by means of ENG|03_MASK_OK | 5| | the FORM-OK key. EASY will interpret the definition of your request form ENG|03_MASK_OK | 6| | and display it immediately. ENG|03_MASK_OK | 8| | You can check here whether the intended delete or add operations have ENG|03_MASK_OK | 9| | actually been performed for the specified fields. ENG|03_MASK_OK | 11| | For any field that may have been added, specify a sample value in order ENG|03_MASK_OK | 12|R | to define its data type. ENG|03_MDSHOW | 1| | In this master-detail representation the master data row is displayed ENG|03_MDSHOW | 2| | in the upper part of the screen and the detail data rows (if any) are ENG|03_MDSHOW | 3| | displayed in the lower part of the screen. The DETAIL and MASTER keys ENG|03_MDSHOW | 4|R | can be used to move between the detail and master table. ENG|03_MF_TOO_SH| 1| | The input fields of the request form must be large enough to contain ENG|03_MF_TOO_SH| 2| | the longest value stored in the database column. ENG|03_MF_TOO_SH| 4| | For numeric columns, there must also be space for the leading sign, all ENG|03_MF_TOO_SH| 5|R | fractional digits and, where applicable, the thousands separator. ENG|03_MSK_EMPTY| 1| | You must define at least one input field in the request form. ENG|03_MSK_EMPTY| 3| | How this may be done, you will learn when you press the END-HELP key ENG|03_MSK_EMPTY| 4|R | and then restrike the HELP key. ENG|03_MSK_EXIST| 1| | The form being displayed already exists. If you press the IMPORT key ENG|03_MSK_EXIST| 2| | again, you import the displayed form overwriting the existent one. To ENG|03_MSK_EXIST| 3| | skip this form and continue working with the next form, if any, press ENG|03_MSK_EXIST| 4|R | CONTINUE. ENG|03_MSK_TOO_W| 1| | You attempted to define fields in this form which exceed the right ENG|03_MSK_TOO_W| 2| | margin of the screen. ENG|03_MSK_TOO_W| 4|R | The cursor points to the incorrect position. ENG|03_NEWCONN | 1| | The connection to the database system is released automatically, when ENG|03_NEWCONN | 2| | you do not access the database for a longer period of time. For the ENG|03_NEWCONN | 3| | next access, EASY will automatically reestablish the connection. If you ENG|03_NEWCONN | 4| | were just reviewing the result of a request, the retrieved results are ENG|03_NEWCONN | 5| | no longer available. Repeat your request by striking LAST-SEL followed ENG|03_NEWCONN | 6|R | by SELECT. ENG|03_NEWSELECT| 1| | If you made a modification (DELETE, UPDATE) to an entry after a ENG|03_NEWSELECT| 2| | request, you cannot have it displayed any more by means of PREV or ENG|03_NEWSELECT| 3| | NEXT, because there is no guarantee that this entry (now changed) still ENG|03_NEWSELECT| 4| | satisfies the previously defined request. Please repeat your last ENG|03_NEWSELECT| 5|R | request by striking LAST-SEL followed by SELECT. ENG|03_NEWTAB | 1| | C H A N G I N G O V E R T O A N O T H E R T A B L E ENG|03_NEWTAB | 3| | This function enables you to process another table without returning to ENG|03_NEWTAB | 4| | the table menu. Specify the name of the desired table and press the enter ENG|03_NEWTAB | 5| | key. ENG|03_NEWTAB | 7| | If the new table has columns with the same name and the same type (text ENG|03_NEWTAB | 8| | or numeric), the values used last for these columns will be transferred ENG|03_NEWTAB | 9| | to the displayed blank form. ENG|03_NEWTAB | 11| | Example: ENG|03_NEWTAB | 13| | When changing over from the table CUSTOMER to the table RESERVATION, the ENG|03_NEWTAB | 14|R | customer number (CNO) will be passed. ENG|03_NEXT | 1| | D I S P L A Y I N G T H E N E X T R E S U L T ENG|03_NEXT | 3| | EASY may have found more than one suitable entry for your last request. ENG|03_NEXT | 5| | EASY displays the first retrieved entry. You may have the remaining ENG|03_NEXT | 6|R | "hits" displayed by means of the NEXT key. ENG|03_NO_COL_NU| 1| | If you want to define fields as keys or if you want to make requests of ENG|03_NO_COL_NU| 2| | the form "6 price_min... : %7........" , fields must be provided with ENG|03_NO_COL_NU| 3| | a number. To do so, place a number before the fields when defining your ENG|03_NO_COL_NU| 4| | own request forms. The number must be in the same line as the field. It ENG|03_NO_COL_NU| 5|R | must be separated from the adjacent fields by blanks. ENG|03_NO_EXAMPL| 1| | The example value in the third column defines the type of the new ENG|03_NO_EXAMPL| 2| | database column. ENG|03_NO_EXAMPL| 4|R | This example value must not be omitted! ENG|03_NO_FUNCTN| 1| | You may only call the SUBTOTAL function when you grouped the results of ENG|03_NO_FUNCTN| 2| | one database column at least. ENG|03_NO_FUNCTN| 4|R | For this purpose put an "x" into the column "group"! ENG|03_NO_HELP | 1|R | There is no further information available about this subject. ENG|03_NO_INSERT| 1| | You intended to insert something into the database, but you did not ENG|03_NO_INSERT| 2| | fill in the form. ENG|03_NO_INSERT| 4|R | Fill the form with values and repeat this function. ENG|03_NO_LANGUA| 1| | Messages in your language are not implemented. ENG|03_NO_LANGUA| 3| | Il n'y a pas de textes en votre langue. ENG|03_NO_LANGUA| 5|R | No hay mensajes en su idioma. ENG|03_NO_REPORT| 1| | You intended to call the REPORT function, but you had changed an entry ENG|03_NO_REPORT| 2| | after the last SELECT. Since the REPORT function outputs the result of ENG|03_NO_REPORT| 3| | the last request, your modifications would not be taken into account. ENG|03_NO_REPORT| 4| | The REPORT function is therefore inhibited. ENG|03_NO_REPORT| 5|R | Strike LAST-SEL and then recall REPORT. ENG|03_NO_STOCOM| 1| | You have three possibilities of selecting a named request: ENG|03_NO_STOCOM| 2| | - You enter the name into the input field ENG|03_NO_STOCOM| 3| | Named request: ........................... ENG|03_NO_STOCOM| 4| | - You enter the current number of the request into this field. ENG|03_NO_STOCOM| 5| | - You put the cursor on the corresponding request name within the menu. ENG|03_NO_STOCOM| 7| | Striking SELECT will show you the result of the request in file card ENG|03_NO_STOCOM| 8| | format, REPORT will show it in REPORT format, whereas the enter key or ENG|03_NO_STOCOM| 9| | NAMED-RQ key will display the request itself which can be changed, if ENG|03_NO_STOCOM| 10| | necessary. ENG|03_NO_STOCOM| 12|R | In your case, you did not make use of any of these possibilities. ENG|03_NO_TABLE | 1| | You have three possibilities of selecting a table/view for further ENG|03_NO_TABLE | 2| | processing: ENG|03_NO_TABLE | 3| | - You enter the name into the input field ENG|03_NO_TABLE | 4| | Table: ........................... ENG|03_NO_TABLE | 5| | - You enter the current number of the table/view name ENG|03_NO_TABLE | 6| | into this field. ENG|03_NO_TABLE | 7| | - You put the cursor on the corresponding ENG|03_NO_TABLE | 8| | table/view name within the menu. ENG|03_NO_TABLE | 10|R | In your case, you did not make use of any of these possibilities. ENG|03_NO_TABLES| 1| | You wanted to have only a subset of your available tables displayed and ENG|03_NO_TABLES| 2| | specified a pattern for this purpose. ENG|03_NO_TABLES| 4| | Since none of the tables which you are allowed to process fits this ENG|03_NO_TABLES| 5|R | pattern, the menu contains all the tables. ENG|03_NO_UPDATE| 1| | You pressed the UPDATE key in order to modify an entry. ENG|03_NO_UPDATE| 3| | Since you did not modify any of the displayed database values, your ENG|03_NO_UPDATE| 4|R | request was rejected. ENG|03_N_ALL_TAB| 1| | EASY was called with a limited table menu. Therefore you are only ENG|03_N_ALL_TAB| 2| | allowed to work with those tables which were displayed after the start ENG|03_N_ALL_TAB| 3| | of EASY. If you want to limit the table menu still further or if you ENG|03_N_ALL_TAB| 4| | want to create a new table, the pattern or the table name must ENG|03_N_ALL_TAB| 5|R | correspond to the search argument specified for the call. ENG|03_N_ATR_ENT| 1| | You have three possibilities of selecting an attribute for a field: ENG|03_N_ATR_ENT| 2| | - You write the name in the input field Attribute: ............... ENG|03_N_ATR_ENT| 3| | - You specify the current number of the attribute in this field. ENG|03_N_ATR_ENT| 4| | - You place the cursor on the corresponding attribute in the menu. ENG|03_N_ATR_ENT| 6| | The attribute is assigned to the selected field by means of the ENG|03_N_ATR_ENT| 7| | ATTRIBUTE or enter key. ENG|03_N_ATR_ENT| 9|R | You did not use any of these possibilities. ENG|03_N_DET_FND| 1| | There are no detail lines which could be shown for the displayed master ENG|03_N_DET_FND| 2| | row. ENG|03_N_DET_FND| 4|R | Specify another master row. ENG|03_N_LNK_ENT| 1| | You have three possibilities of selecting a foreign key: ENG|03_N_LNK_ENT| 2| | - You write the name in the input field Foreign-Key: ............... ENG|03_N_LNK_ENT| 3| | - You specify the current number of the foreign key in this field. ENG|03_N_LNK_ENT| 4| | - You place the cursor on the corresponding name in the menu. ENG|03_N_LNK_ENT| 6| | The foreign key is executed by means of DETAIL or the enter key. ENG|03_N_LNK_ENT| 8|R | You did not use any of these possibilities. ENG|03_N_MSK_DEF| 1|R | There are no own forms defined which you could export or delete. ENG|03_N_MSK_SEL| 1| | If you want to export or delete forms, mark them beforehand by means of ENG|03_N_MSK_SEL| 2| | the MARK key. To mark single forms, place the cursor on the name of a ENG|03_N_MSK_SEL| 3| | form and then press the MARK key. To mark all forms, press the MARK key ENG|03_N_MSK_SEL| 4| | when the cursor is not placed on a name of an individual form. To ENG|03_N_MSK_SEL| 5|R | cancel form marks, use the UNMARK key. ENG|03_N_STC_DEF| 1|R | There are no own requests defined which you could export or delete. ENG|03_N_STC_SEL| 1| | If you want to export or delete named requests, mark them beforehand by ENG|03_N_STC_SEL| 2| | means of the MARK key. To mark single named requests, place the cursor ENG|03_N_STC_SEL| 3| | on the name of a request and then press the MARK key. To mark all named ENG|03_N_STC_SEL| 4| | requests, press the MARK key when the cursor is not placed on a name of ENG|03_N_STC_SEL| 5|R | an individual form. To cancel request marks, use the UNMARK key. ENG|03_OPEN_JOIN| 1| | You attempted to establish a join between two tables, but you entered ENG|03_OPEN_JOIN| 2| | an identifier for one table only. Enter the same identifier in both ENG|03_OPEN_JOIN| 3|R | tables in the desired columns. ENG|03_ORDER | 1| | O R D E R I N G R E S U L T S ENG|03_ORDER | 3| | Here you may select the sequence in which the individual result rows of ENG|03_ORDER | 4| | your request shall be ordered on display. ENG|03_ORDER | 7| | Example : ENG|03_ORDER | 9| | Order: +2... -1.. 3... ENG|03_ORDER | 11| | produces the following sort of the result table: ENG|03_ORDER | 13| | - field 2 ordered in ascending sequence (+) ENG|03_ORDER | 14| | - field 1 ordered in descending sequence (-) ENG|03_ORDER | 15|R | - field 3 ordered in ascending sequence ENG|03_OWNMASK | 1| | C H A N G I N G O V E R T O A ENG|03_OWNMASK | 2| | U S E R - D E F I N E D F O R M O R V I E W ENG|03_OWNMASK | 4| | This key enables you to go to the ADABAS editor, where you may either ENG|03_OWNMASK | 5| | define your own layout for the request form or create a view. ENG|03_OWNMASK | 7|R | For details, strike the OWN-FORM key and call HELP again. ENG|03_PREV | 1| | D I S P L A Y I N G T H E P R E V I O U S R E S U L T ENG|03_PREV | 3| | When you pass through the table entries which EASY retrieved after your ENG|03_PREV | 4| | last request, you can use this function whenever you like to scroll back ENG|03_PREV | 5| | "hit" by "hit". ENG|03_PREV | 7|R | Do not be surprised if long backtracking causes long delays. ENG|03_PRINT | 1| | P R I N T I N G T A B L E E N T R I E S ENG|03_PRINT | 3| | When you strike this key, EASY creates a printing form for the table ENG|03_PRINT | 4| | entry currently displayed. ENG|03_PRINT | 6| | The printing forms thus created will be collected in an output area and ENG|03_PRINT | 7| | will not be issued to the printer u n t i l you either press the PRINT ENG|03_PRINT | 8|R | key t w i c e or you leave EASY. ENG|03_RBTLINE | 1| | B O T T O M L I N E ENG|03_RBTLINE | 5|R | This line will be output at the end of each output page. ENG|03_RCOLNAME | 1| | That heading will be displayed here which is used as table column name ENG|03_RCOLNAME | 2| | in the REPORT display. ENG|03_RCOLNAME | 4| | You may ENG|03_RCOLNAME | 5| | - change this heading by entering a new name. ENG|03_RCOLNAME | 6| | - prevent the column from being displayed either by deleting the ENG|03_RCOLNAME | 7| | heading or by entering an opening parenthesis into the input field. ENG|03_RCOLNAME | 8| | - reactivate any column thus deleted by removing the opening ENG|03_RCOLNAME | 9|R | parenthesis. ENG|03_RCOLPRES | 1| | F O R M A T F O R T H E R E P R E S E N T A T I O N ENG|03_RCOLPRES | 2| | O F N U M E R I C V A L U E S ENG|03_RCOLPRES | 4| | An example indicates here how the value shall look like on display. If ENG|03_RCOLPRES | 5| | you modify this example, you modify the subsequent output. This option ENG|03_RCOLPRES | 6| | is only available for numeric values. ENG|03_RCOLPRES | 8| | Here you may ENG|03_RCOLPRES | 9| | - enter any text before or after the example value. On display this ENG|03_RCOLPRES | 10| | text will appear before or after the value. ENG|03_RCOLPRES | 11| | - change the decimal point notation (1 character only!!!). ENG|03_RCOLPRES | 12| | - separate the thousands groups by 1 character at the most. ENG|03_RCOLPRES | 13| | - change the number of fractional (not integral) digits. ENG|03_RCOLPRES | 16| | Example: ENG|03_RCOLPRES | 18| | $ 999,999.99: "$ " will be placed in front of each value, the ENG|03_RCOLPRES | 19| | thousands will be separated by a comma. 2 fractional ENG|03_RCOLPRES | 20|R | digits will be displayed, separated by a point. ENG|03_RCOLSEP | 1| | C O L U M N S E P A R A T O R ENG|03_RCOLSEP | 3| | Here you may specify a character or character string which shall be ENG|03_RCOLSEP | 4| | used to separate the table columns from each other. If the character ENG|03_RCOLSEP | 5| | string is to contain blanks, enclose your entry in single quotes, as it ENG|03_RCOLSEP | 6|R | is done in default representation. ENG|03_RCOLWIDTH| 1| | C O L U M N W I D T H ENG|03_RCOLWIDTH| 3| | Here you may redefine the column width. ENG|03_RCOLWIDTH| 5| | Attention! ENG|03_RCOLWIDTH| 6| | If a character string is to precede or follow numeric values, then the ENG|03_RCOLWIDTH| 7|R | length of this text will increase the column width accordingly. ENG|03_RENAME_TA| 1| | R E N A M I N G A T A B L E ENG|03_RENAME_TA| 4| | You may use this field to assign a new name to the currently displayed ENG|03_RENAME_TA| 5| | table. ENG|03_RENAME_TA| 7| | Enter the new name into this input field and confirm your change request ENG|03_RENAME_TA| 8| | by means of the ALTER (or SEL-TAB) key. ENG|03_RENAME_TA| 10| | - The new table name must not designate an already existing table! ENG|03_RENAME_TA| 12| | - The name of the owner (among others, your own user area) must not be ENG|03_RENAME_TA| 13|R | changed! ENG|03_RESULTMOD| 1| | D I S P L A Y I N G R E S U L T S ENG|03_RESULTMOD| 4| | Here you see a result of your request. You will know from the message ENG|03_RESULTMOD| 5| | at the bottom right, whether there are more results available. ENG|03_RESULTMOD| 7| | e.g.: 1 of 10 results ENG|03_RESULTMOD| 9| | Use the PREV or NEXT key to scroll through these results. Use the ENG|03_RESULTMOD| 10|R | UPDATE, INSERT, DELETE key to modify your data. ENG|03_RFORMAT | 1| | F O R M A T T I N G A R E P O R T ENG|03_RFORMAT | 3| | You can now redesign the tabular output of your results in some aspects. ENG|03_RFORMAT | 5| | Fill in the appropriate headings or mark them with a character of your ENG|03_RFORMAT | 6| | choice and press the key REPORT! ENG|03_RFORMAT | 8| | To get more information about specific input options, place the cursor on ENG|03_RFORMAT | 9| | the corresponding field and strike the HELP key. ENG|03_RFORMAT | 11| | If you want to know what you can specify in the column where the cursor ENG|03_RFORMAT | 12| | was placed, position the cursor on the input field below it and press the ENG|03_RFORMAT | 13|R | HELP key. ENG|03_RGROUP | 1| | G R O U P I N G ENG|03_RGROUP | 3| | You may group your output according to ordered fields. ENG|03_RGROUP | 4| | These are, among others: ENG|03_RGROUP | 5| | - key fields, if more than one key field was defined, ENG|03_RGROUP | 6| | - fields for which an explicit sequence was specified. ENG|03_RGROUP | 8| | Mark the desired grouping fields by placing an "x" within the ENG|03_RGROUP | 9|R | corresponding parentheses. ENG|03_RHEADER | 1| | H E A D E R L I N E ENG|03_RHEADER | 5|R | This line will be output as heading at the top of each output page. ENG|03_RIGHT | 1| | S C R O L L I N G T O T H E R I G H T ENG|03_RIGHT | 3| | If the processing form for a table does not fit on a screen, EASY will ENG|03_RIGHT | 4| | only display a section of the form page. ENG|03_RIGHT | 6| | This function enables you to move to the right of the form section by ENG|03_RIGHT | 7|R | section. ENG|03_RSHOW | 1| | In this tabular format you may use the following function keys: ENG|03_RSHOW | 3| | scroll keys scrolling in the table (up, down, left, ENG|03_RSHOW | 4| | right) ENG|03_RSHOW | 5| | FORMAT: changing the table layout ENG|03_RSHOW | 6| | RESULT: branching to the file card format ENG|03_RSHOW | 7| | LAST-SEL: returning to the screen where you formulated your ENG|03_RSHOW | 8| | request ENG|03_RSHOW | 9| | FILE: storing the result in a file ENG|03_RSHOW | 10| | HELP: HELP function ENG|03_RSHOW | 11| | PRINT: The result is put into the output area. The ENG|03_RSHOW | 12| | printing forms thus created will be collected in ENG|03_RSHOW | 13| | the output area and will not be issued to the ENG|03_RSHOW | 14| | printer until you press the PRINT key twice or ENG|03_RSHOW | 15|R | you leave EASY. ENG|03_RTOTALCMD| 1| | T O T A L / S U B T O T A L ENG|03_RTOTALCMD| 3| | You may use the TOTAL function in order to have results displayed for ENG|03_RTOTALCMD| 4| | minimum, maximum, count, sum, and average at the end of the complete list ENG|03_RTOTALCMD| 5| | (sum and average for numeric columns only). ENG|03_RTOTALCMD| 7| | When you use the SUBTOTAL function, these values will appear at the end ENG|03_RTOTALCMD| 8| | of each group. This output, however, is only possible if fields may be ENG|03_RTOTALCMD| 9| | grouped and you marked at least one grouping. ENG|03_RTOTALCMD| 11| | To obtain these results, place the cursor on the input line of the ENG|03_RTOTALCMD| 12| | formatting screen that corresponds to the desired output column and press ENG|03_RTOTALCMD| 13| | the TOTAL or SUBTOTAL key. You can now specify the output result in a ENG|03_RTOTALCMD| 14|R | distinct window: ENG|03_RTOTALS | 1| | If you want a total/subtotal output for a database column, mark the ENG|03_RTOTALS | 2| | corresponding function field with an "x" or enter some text into the ENG|03_RTOTALS | 3| | comment field. (It will be sufficient to fill in one of the two ENG|03_RTOTALS | 4| | fields.) ENG|03_RTOTALS | 6| | If you do not specify anything in the comment field, the corresponding ENG|03_RTOTALS | 7| | result will be preceded by a default comment such as "MIN:". ENG|03_RTOTALS | 9| | A note "Total" or "Subtotal" in the main screen of the formatting mode ENG|03_RTOTALS | 10| | indicates that a total or subtotal result was selected for the ENG|03_RTOTALS | 11| | corresponding column. ENG|03_RTOTALS | 13| | To cancel a total/subtotal selection, delete either the "x" in ENG|03_RTOTALS | 14|R | parentheses or the corresponding comment. ENG|03_RUN_STOCO| 1| | N A M E D R E Q U E S T S ENG|03_RUN_STOCO| 3| | Frequently used requests may be stored as named requests in the database ENG|03_RUN_STOCO| 4| | with all formatting options that are needed for the REPORT mode. You may ENG|03_RUN_STOCO| 5| | use these named requests later in other EASY sessions. ENG|03_RUN_STOCO| 7| | To name a request, formulate it in the request form and have its result ENG|03_RUN_STOCO| 8| | displayed by means of the RESULT or REPORT key. ENG|03_RUN_STOCO| 10| | If you like, format these results in REPORT mode by means of FORMAT. When ENG|03_RUN_STOCO| 11| | the output format meets your conception, go back to your last request ENG|03_RUN_STOCO| 12| | form via LAST-SEL. After this proceeding, i.e. after having displayed a ENG|03_RUN_STOCO| 13| | result at least once, you can name the request. You will get more ENG|03_RUN_STOCO| 14| | information via HELP. ENG|03_RUN_STOCO| 16| | To call a named request and any REPORT formattings that you stored in ENG|03_RUN_STOCO| 17| | former sessions, put the name of the request into the field ENG|03_RUN_STOCO| 19| | Named request: ........................... ENG|03_RUN_STOCO| 21| | and press one of the following function keys: ENG|03_RUN_STOCO| 23| | enter key or ENG|03_RUN_STOCO| 24| | NAMED-RQ: The request will be read in, but not be executed. You ENG|03_RUN_STOCO| 25| | may change it, if necessary, and then perform it. ENG|03_RUN_STOCO| 26| | RESULT The result of this named request will be displayed at ENG|03_RUN_STOCO| 27| | once. ENG|03_RUN_STOCO| 28| | REPORT The result of this named request will be displayed in ENG|03_RUN_STOCO| 29| | REPORT format. ENG|03_RUN_STOCO| 31| | If you do not enter a name and call NAMED-RQ, you will see a list of all ENG|03_RUN_STOCO| 32|R | named requests you stored for this table. ENG|03_SELECT | 1| | R E T R I E V I N G E N T R I E S ENG|03_SELECT | 2| | W H I C H F I T A R E Q U E S T ENG|03_SELECT | 4| | When you use this function, you make a request to a table. EASY searches ENG|03_SELECT | 5| | the table entries which fit the pattern you have outlined in the table ENG|03_SELECT | 6| | form. ENG|03_SELECT | 8| | If you did not enter anything in the form, then a l l table entries fit ENG|03_SELECT | 9| | your request. ENG|03_SELECT | 11| | If you do not know how to formulate a request, place the cursor on an ENG|03_SELECT | 12| | input field of the form and press the HELP key. ENG|03_SELECT | 14|R | You will get more information, when you restrike the HELP key. ENG|03_SERR-2001| 1| | Currently the total length of all key fields must not exceed ENG|03_SERR-2001| 3| | 254 minus number of key fields ENG|03_SERR-2001| 5| | provided all fields are non-numeric fields. ENG|03_SERR-2001| 7| | If also numeric fields are defined as key fields, then you must include ENG|03_SERR-2001| 8|R | about half their length in the calculation of the total length. ENG|03_SERR-3002| 1| | You intended to define a numeric column. But the value you specified ENG|03_SERR-3002| 2| | for its length is too large. ENG|03_SERR-3002| 4|R | Numeric columns may have a precision (length) of 18 digits at the most. ENG|03_SERR-3048| 1| | You specified the date in an invalid format. The specified format must ENG|03_SERR-3048| 2|R | comply with the format as defined via SET. ENG|03_SERR-3049| 1| | You specified the time in an invalid format. The specified format must ENG|03_SERR-3049| 2|R | comply with the format as defined via SET. ENG|03_SERR-4004| 1| | You attempted to process a table which does not exist. If you want to ENG|03_SERR-4004| 2| | define this table as a new one, go to the ENG|03_SERR-4004| 3| | t a b l e a d m i n i s t r a t i o n m o d e . ENG|03_SERR-4004| 5|R | To do so, strike the ADMIN key in the table menu. ENG|03_SERR-4005| 1| | The syntax of the specified column name is correct, but there is no ENG|03_SERR-4005| 2|R | column with this name in your table. ENG|03_SERR-5001| 1| | You attempted to perform an operation on a table or column for which ENG|03_SERR-5001| 2|R | you have no or only conditional access authorization. ENG|03_SERR-5005| 1| | You intended to insert an entry, but you either omitted a key field ENG|03_SERR-5005| 2| | (name and number are displayed brightly) or mandatory field (bright ENG|03_SERR-5005| 3| | conscecutive number) or you entered the character that represents the ENG|03_SERR-5005| 4|R | null value. Please check your entries! ENG|03_SERR-6001| 1| | You attempted to define a column with a name already used for another ENG|03_SERR-6001| 2| | column of this table. ENG|03_SERR-6001| 4|R | Please change one of the names. ENG|03_SERR-7002| 1| | In the input fields along the lower edge of the display screen you can ENG|03_SERR-7002| 2| | declare up to fifteen columns as keys by means of the column numbers. ENG|03_SERR-7002| 3|R | You entered an incorrect column number in one of the input fields. ENG|03_SERR-7007| 1| | You attempted to modify a value of a column that is defined as key ENG|03_SERR-7007| 2| | column (the name is displayed brightly). This is not allowed. If you ENG|03_SERR-7007| 3| | actually want to make this change, use the RESET key to remove the ENG|03_SERR-7007| 4| | original entry. Afterwards you can modify the old values which remain ENG|03_SERR-7007| 5|R | on the display and reinsert them via INSERT. ENG|03_SERR-8015| 1| | You intended to alter a VIEW in the table administration mode: either ENG|03_SERR-8015| 2| | you wanted to define another request form, or you wanted to drop old ENG|03_SERR-8015| 3|R | columns or define some new ones in the standard form. ENG|03_SERR100 | 1| | In the current table there is no entry matching your request. ENG|03_SERR100 | 3| | You may want to correct the request! ENG|03_SERR100 | 5| | You may also use the RESET key to clear the form and then have ENG|03_SERR100 | 6|R | a l l results displayed by means of the SELECT key. ENG|03_SERR200 | 1| | There is already an entry in the table with identical key values. ENG|03_SERR200 | 2| | Duplicate entries are not allowed. Please check which of the key values ENG|03_SERR200 | 3|R | already exist in the database. ENG|03_SERR300 | 1| | A constraint is defined for the table. ENG|03_SERR300 | 2|R | To find out what is the constraint, restrike the HELP key! ENG|03_SERR500 | 1| | It is possible that another user updated or dropped your table or part ENG|03_SERR500 | 2| | of it, while you were working with it via EASY. ENG|03_SERR500 | 4|R | If you think that this cannot have happened, retry your last command. ENG|03_SERR600 | 1| | You attempted to access a table that was processed by another user. ENG|03_SERR600 | 2| | EASY waits a certain time for the release of the table. Since this ENG|03_SERR600 | 3|R | waiting time was exceeded, you have to reissue your command. ENG|03_SHOW_REP | 1| | D I S P L A Y I N G T H E R E P O R T ENG|03_SHOW_REP | 3| | This key displays the columns of your table in tabular format according ENG|03_SHOW_REP | 4| | to your formatting specifications. ENG|03_SHOW_REP | 6| | To return to the formatting display of the REPORT mode, press the FORMAT ENG|03_SHOW_REP | 7| | key. ENG|03_SHOW_REP | 9| | If you enter the desired format specifications into the form and then ENG|03_SHOW_REP | 10| | change to the report mode by means of REPORT, you are no longer allowed ENG|03_SHOW_REP | 11| | to maintain your data there. The report mode then only enables you to ENG|03_SHOW_REP | 12|R | display, print, and file your data. ENG|03_SHOW_TABL| 1| | When you strike this function key, you will get more information about ENG|03_SHOW_TABL| 2|R | the table than is displayed in this form. ENG|03_SINGLE | 1| | R E T U R N I N G T O T H E F I L E C A R D F O R M A T ENG|03_SINGLE | 3| | This function key will return you from the tabular format of your results ENG|03_SINGLE | 4|R | to the file card format, where you may specify new requests. ENG|03_STANDARD | 1| | S T A N D A R D M O D E ENG|03_STANDARD | 3| | If you are not interested in your self-defined request form, you can ENG|03_STANDARD | 4| | change to the standard mode and make there your alterations to the table. ENG|03_STANDARD | 5| | Your self-defined request form will be lost as soon as you confirm your ENG|03_STANDARD | 6| | table modifications with ALTER. ENG|03_STANDARD | 8| | If you do not define another request form of your own for this table, ENG|03_STANDARD | 9| | EASY will create a standard form having the following structure: ENG|03_STANDARD | 11| | - Each input field begins on a new line and can be continued on the next ENG|03_STANDARD | 12| | line. ENG|03_STANDARD | 13| | - Each input field is preceded by a field identifier which is formed by ENG|03_STANDARD | 14| | the field name (name of the table column). ENG|03_STANDARD | 15| | - Each field identifier is preceded by a field number which can be used ENG|03_STANDARD | 16|R | for cross references between the fields. ENG|03_STC_EXIST| 1| | You attempted to store your current request under a name that is ENG|03_STC_EXIST| 2| | already used for another request. ENG|03_STC_EXIST| 4| | If you strike the STORE key a second time, you will overwrite the old ENG|03_STC_EXIST| 5|R | request with the new one. ENG|03_STC_EXP | 1| | E X P O R T I N G A N D I M P O R T I N G ENG|03_STC_EXP | 2| | N A M E D R E Q U E S T S ENG|03_STC_EXP | 5| | This function enables you to change to a menu where you may either store ENG|03_STC_EXP | 6|R | your named requests in a file or read them in from a file. ENG|03_STC_NFOUN| 1|R | There is no named request with this name or number. ENG|03_STC_RDERR| 1| | The attempt to process the named request failed. ENG|03_STC_RDERR| 3| | Possibly the table was updated in the meanwhile, or the request was ENG|03_STC_RDERR| 4|R | modified outside of EASY. ENG|03_STC_WRCOL| 1| | EASY did not find an input field of this named request in the request ENG|03_STC_WRCOL| 2| | form. The reason may be that the input field was removed from the ENG|03_STC_WRCOL| 3| | table, the name was changed or the order of the input fields in the ENG|03_STC_WRCOL| 4|R | request form was changed. ENG|03_STOCOM | 1| | N A M I N G A R E Q U E S T ENG|03_STOCOM | 3| | If your database request was successful, and if you perhaps formatted ENG|03_STOCOM | 4| | your REPORT according to your needs, you can store both this request ENG|03_STOCOM | 5| | and the formatting instructions for the report. ENG|03_STOCOM | 7| | Enter a name into the input field ENG|03_STOCOM | 9| | Named request: ........................... ENG|03_STOCOM | 11| | in the bottom left corner and press the STORE key. Your request will be ENG|03_STOCOM | 12|R | stored in the database and can be recalled by this name. ENG|03_SW_UPDATE| 1| | C L O S I N G T H E I N S E R T W I N D O W ENG|03_SW_UPDATE| 3| | You may close the insert window by means of the WHOLE key. The new ENG|03_SW_UPDATE| 4| | entries will not be lost by doing so and a message will be output telling ENG|03_SW_UPDATE| 5| | you how many new entries are available which are not displayed. ENG|03_SW_UPDATE| 7| | Example: ENG|03_SW_UPDATE| 9|R | 36 results ( + 3 new rows ) ENG|03_TABLE | 1| | S E L E C T I N G A T A B L E / V I E W ENG|03_TABLE | 3| | When starting, EASY displays a selection menu that shows all existing ENG|03_TABLE | 4| | tables and views that you are allowed to access. ENG|03_TABLE | 6| | If you want to process (request, alter) a table, specify the name or ENG|03_TABLE | 7| | number of this table in the input field Table: ................ You may ENG|03_TABLE | 8| | also select the desired table by placing the cursor on the table name in ENG|03_TABLE | 9| | the menu. ENG|03_TABLE | 11| | If you want to create a new table not yet included in the menu, specify ENG|03_TABLE | 12| | the name that is to be given to the new table in the input field (18 ENG|03_TABLE | 13| | letters/numbers at the most; the first character must be a letter) and ENG|03_TABLE | 14| | press the ADMIN key. ENG|03_TABLE | 16| | To have also the tables and views displayed that other users made ENG|03_TABLE | 17| | available to you, specify the pattern "*.*" in the input field ENG|03_TABLE | 18| | Table: ............... ENG|03_TABLE | 20| | If the selection menu is not clearly arranged because of the great number ENG|03_TABLE | 21| | of tables and views, then you may have a subset of these tables ENG|03_TABLE | 22| | displayed. For this purpose specify a pattern which the desired table ENG|03_TABLE | 23| | names are to begin with in the field Table: ................ ENG|03_TABLE | 25| | Example: ENG|03_TABLE | 27| | Table: hotel*.......... e.g. displays the tables HOTELDESCRIPTION, ENG|03_TABLE | 28| | HOTELBOOKING, HOTELBILLING. ENG|03_TABLE | 30| | Table: miller.*......... displays all tables and views of the user ENG|03_TABLE | 31| | MILLER you are allowed to work with. ENG|03_TABLE | 33|R | Important: The asterisk may only occur at the end of this pattern !! ENG|03_TABLEDEF | 1| | Here the tables will be displayed which you are allowed to access. ENG|03_TABLEDEF | 3| | How the table is defined where the cursor is placed on you can see when ENG|03_TABLEDEF | 4| | you restrike the HELP key. ENG|03_TABLEDEF | 6| | Then you will see the definition of the table and the functions (ADMIN, ENG|03_TABLEDEF | 7|R | SEL-TAB) which you are allowed to perform on it. ENG|03_TABLES | 1| | R E T U R N I N G T O T H E T A B L E M E N U ENG|03_TABLES | 3| | This function key returns you to the selection menu of all tables which ENG|03_TABLES | 4| | you are allowed to access. ENG|03_TABLES | 6| | There you can either end your EASY session, or select another table, or ENG|03_TABLES | 7|R | change to the table administration mode. ENG|03_TBL_SHOW | 1|R | Here you see a detailed description of the table. ENG|03_TOO_LONG | 1| | An input field for constructing a request or for inserting a value can ENG|03_TOO_LONG | 2| | only have a maximum length of 255 characters. ENG|03_TOO_LONG | 4|R | You attempted to exceed this limit. ENG|03_UCHANGED | 1| | Another user changed the result that is on your display. The field ENG|03_UCHANGED | 2| | denoted by the cursor has the following value now: ENG|03_UCHANGED | 3| | &1 ENG|03_UCHANGED | 4| | Striking the enter key will transfer the complete current result to ENG|03_UCHANGED | 5|R | your display. Your update request will be lost thereby. ENG|03_UNMARK | 1| | U N M A R K I N G N A M E S ENG|03_UNMARK | 3| | Marks previously set via the MARK key may be removed by means of the ENG|03_UNMARK | 4| | UNMARK key. This can be done in two possible ways: ENG|03_UNMARK | 6| | - unmark each form/named request ENG|03_UNMARK | 7| | - unmark all forms/named requests ENG|03_UNMARK | 9| | By means of the cursor position you can determine which of these options ENG|03_UNMARK | 10| | will be used. ENG|03_UNMARK | 12| | To unmark each single form or named request, place the cursor on the name ENG|03_UNMARK | 13| | of that form or named request you want to unmark. Then strike the UNMARK ENG|03_UNMARK | 14| | key. ENG|03_UNMARK | 16| | To mark all names, place the cursor on a field outside the list of names, ENG|03_UNMARK | 17| | e.g. on the field ENG|03_UNMARK | 19| | Pattern: ................... ENG|03_UNMARK | 21|R | With the UNMARK key you then remove all the marks. ENG|03_UP | 1| | S C R O L L I N G U P W A R D S ENG|03_UP | 3| | This function enables you to move upwards page by page, if you already ENG|03_UP | 4|R | scrolled downwards. ENG|03_UPDAFTINS| 1| | As your last request does not refer to the entry just inserted, it is ENG|03_UPDAFTINS| 2| | not possible to delete or update it at this time. Please repeat your ENG|03_UPDAFTINS| 3|R | request and then update or delete the inserted entry. ENG|03_WRONG_COL| 1| | You used a non-existent column number in your request. Correct the ENG|03_WRONG_COL| 2|R | request and try it again. ENG|03_WRONG_DRP| 1| | Key columns may be r e n a m e d , but not be d r o p p e d ! ENG|03_WRONG_DRP| 3|R | Your request to remove the key column was ignored. ENG|03_WRONG_EXA| 1| | You possibly made one of the following mistakes: ENG|03_WRONG_EXA| 3| | - You attempted to modify the number of integral digits. ENG|03_WRONG_EXA| 4| | - You attempted to place a text longer than 40 characters before or ENG|03_WRONG_EXA| 5| | after this example value. ENG|03_WRONG_EXA| 6| | - You attempted to add so many fractional digits that the total number ENG|03_WRONG_EXA| 7| | of all represented digits exceeded 18. ENG|03_WRONG_EXA| 8|R | - You used more than one character to separate the groups of thousands. ENG|03_WRONG_FIL| 1| | You specified a filename in the input field at the bottom. This file ENG|03_WRONG_FIL| 2| | could not be opened for writing/reading. ENG|03_WRONG_FIL| 4| | There may be various causes for it. Perhaps the filename is not ENG|03_WRONG_FIL| 5|R | correct. ENG|03_WRONG_LEN| 1| | When creating a new column, EASY determines the data type from the ENG|03_WRONG_LEN| 2| | example value and the length specification. The example value may be ENG|03_WRONG_LEN| 3| | shorter, but never longer than specified in the length field. ENG|03_WRONG_LEN| 5| | If you want to alter the length of a column in an existing table, the ENG|03_WRONG_LEN| 6|R | column length may only be increased, not decreased. ENG|03_WRONG_MAS| 1| | You specified an incomplete date mask. As EASY also uses the date mask ENG|03_WRONG_MAS| 2| | for input, the date mask must be complete. Call SET again and correct ENG|03_WRONG_MAS| 3|R | the date mask. ENG|03_WRONG_NAM| 1| | A name must begin with a letter and may be followed by up to 18 ENG|03_WRONG_NAM| 2| | characters (letters, numbers, and the special characters "_", "$", ENG|03_WRONG_NAM| 3|R | "@"). ENG|03_WRONG_NUM| 1| | In order fields, key fields, and in a request that refers to a column ENG|03_WRONG_NUM| 2| | by means of %, an integral value (e.g. 7 or %13) is expected. ENG|03_WRONG_NUM| 4| | Furthermore, a number can be entered, according to the respective input ENG|03_WRONG_NUM| 5| | field...., either in standard format ENG|03_WRONG_NUM| 6| | 123456.789 or 123.456E+12 ENG|03_WRONG_NUM| 7| | (point as decimal separator), ENG|03_WRONG_NUM| 9| | or in the EASY output format of numbers... ENG|03_WRONG_NUM| 10|R | 123 456,789 or 123,456E+12 . ENG|03_WR_ATRCUR| 1| | You made the attempt to assign an attribute to a field; but the cursor ENG|03_WR_ATRCUR| 2| | was not correctly positioned, so that EASY does not know which is the ENG|03_WR_ATRCUR| 3| | field you meant. Place the cursor on or before the corresponding field ENG|03_WR_ATRCUR| 4|R | and press the ATTRIBUTE key again. ENG|03_WR_FORMAT| 1| | The file specified for being imported does not comply with the format ENG|03_WR_FORMAT| 2|R | which is required for forms or named requests. ENG|03_W_PRE_COM| 1| | You entered an invalid prefix command. The following commands are ENG|03_W_PRE_COM| 2| | allowed for the editing of your table: ENG|03_W_PRE_COM| 4| | - "C" copies a row into the input area. ENG|03_W_PRE_COM| 5| | - "CC" copies all rows placed between two "CC" commands into the input ENG|03_W_PRE_COM| 6| | area. ENG|03_W_PRE_COM| 7| | - "D" marks a row for deletion. ENG|03_W_PRE_COM| 8| | - "DD" marks all rows placed between two "DD" commands for deletion. ENG|03_W_PRE_COM| 9| | - "R" cancels the delete mark for one row. ENG|03_W_PRE_COM| 10| | - "RR" cancels the delete mark for all rows placed between two "RR" ENG|03_W_PRE_COM| 11| | commands. ENG|03_W_PRE_COM| 13| | If a foreign key is defined on these tables, you can also specify the ENG|03_W_PRE_COM| 14| | prefix command "DET". This command enables you to get a master-detail ENG|03_W_PRE_COM| 15| | representation of the corresponding row. The "DET"-command is not ENG|03_W_PRE_COM| 16|R | allowed if the input-mode is active.