Editing field contents |
To edit Numeric and Text fields in tables/forms
Do one of the following:
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 the GS-Base 16.4 and older versions, the total size of inserted objects and the size of 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).
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 requires 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:
To edit Long Text, Images/Files and Images/Files 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 a 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
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 list 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:
Arrows 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 |