To Edit Numeric and Text Fields in Tables/Forms
Do one of the following:
- Press Enter, F2 or any letter/digit key.
- Double-click a given field.
You can enter up to 8169 characters in the standard Text fields. The Long Text
and Code fields can contain up to 4GB of text. The Images/Files fields
can contain any number of objects. In GS-Base 16.4 and older versions, the total size of inserted objects
and the size of the database file itself can't exceed 4GB, and the total number of binary field entries can't exceed 65K.
In newer GS-Base versions the zip64 file format replaced the standard zip format and all the above limitations were lifted
(they now equal thousands of TB).
- To complete editing, press Enter or - if editing was started by pressing any character key - any of the cursor keys, or simply click the table/form.
- To enter a new line in the edited cell, press Ctrl+Enter or Alt+Enter.
- To cancel changes, press Esc.
For information about entering/editing Unicode characters, please see: Entering Unicode characters.
If you set some standard (not using custom patterns) numeric or date/time format for a given field, GS-Base will try to interpret the data according to that format.
Fields formatted using custom patterns require you to enter the data in the default format or in one of the standard formats.
The date/time style can be applied to Text fields only.
Note: If you want to apply the date format to a text field that already contains some non-standard (that is, other than YYYY-MM-DD) text strings, you should first use the Edit > Convert > Text Strings To Date Strings command (or re-enter each date individually). This step is required to ensure correct sorting of such a field.
Trying to edit a Long Text, Images/Files or Code field within a table/form results in the following actions:
- If the Options > Settings > Table/Form Editing Options > Edit LongText/Files fields in new windows option is unchecked, GS-Base will open/hide a new pane displaying that data for editing/viewing.
- If the Options > Settings > Table/Form Editing Options > Edit LongText/Files fields in new windows option is checked, GS-Base will launch an application associated with the specified data type (e.g. typically Wordpad for text and Paint for graphics). Choosing the "Save" command in such an external application will automatically update the data in GS-Base.
For action (2), the following additional functionality is supported:
- Pressing a digit key opens either the text or the n-th (1...9) object for editing in an external application.
- Pressing a letter key prints either the text or the n-th (a...z) object in an external application.
To Edit Long Text, Images/Files and Code Fields
These fields are saved automatically. They feature all the standard functionality such as drag-and-drop (which includes dropping files/images from other applications) and additional commands (e.g. exporting and importing text, formatting and display options) accessible through the context menus.
To edit a given memo field or a given image/object in an external application, right-click that content to display the context menu and choose the Edit In External Application command. The data will be saved in GS-Base automatically if you use the "Save" command in that external application.
If a given binary field is not empty, the respective table or form field contains some textual information describing it. If you want to delete the entire Long Text, Images/Files or Code field contents at once and remove the respective entry from the database zip file, simply delete the corresponding table/form cell.
To Move/Copy/Paste Field Contents
Tables: Place the mouse cursor over the top edge of the selection and drag it.
You can move the data within the same window, different windows or applications -
by default GS-Base copies (and provides to other applications) the table data as text and bitmaps.
If you drop file(s) within the table view, GS-Base either pastes the file path if
the cursor was over a hyperlink field, or displays a dialog box enabling you to choose
into which Images/Files field that file(s) should be inserted.
Binary Fields: The standard Windows drag-and-drop procedure applies. The dropped objects are always copied, not moved. If you want to insert a link into the Images/Files field, press and hold down the Ctrl+Shift keys at the same time.
To Fill a Given Range With Some Values
- Copy the value of the selected field or fields.
- Select the destination range. The destination range cannot contain more columns than the source range. If it does, the additional columns are ignored and won't be filled.
- Paste the copied data.
To Use a Drop-Down List to Enter Data
Use the Format > List command and specify which list
should be used for a given field(s). The same list can be shared by any number
of fields in any number of tables in one database. A database file can contain
up to 255 lists. The number of list items is unlimited.
Drop-down lists can be static (with values pre-defined by the user), and they can
automatically add each new unique value entered by the user in the associated field(s).
To Use a "Date and Time Picker" Control to Enter Data
The control can be displayed for each text field that (1) is formatted using one of the standard "Date"
styles (not using custom patterns), and (2) doesn't have any drop-down list attached to it at the same time.
Displaying that control can be enabled/disabled in the Settings > Options dialog box.
The following shortcut keys are used by the date/time picker control:
| Keys | Action |
|---|---|
| Arrow keys | Changes the active control field and/or changes control field values |
| End and Home | Sets the maximum and minimum values for the current part of the date (a year, month or day) |
| Plus and Minus | Increments/decrements the current part of the date (a year, month or day) |
| Alt+Down | Displays the "Month Calendar" control. Same as clicking the "drop-down" arrow. |
| PageUp, PageDown | If the "Month Calendar" control is active, moves to the previous/next month |