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).

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 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:

  1. 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.
  2. 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 the action (2) the following additional functionality is supported:

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

  1. Copy the value of the selected field or fields.
  2. 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.
  3. 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 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 keysChanges the active control field and/or changes control field values
End and HomeSets the maximum and minimum values for the current part of the date (a year, month or day)
Plus and MinusIncrements/decrements the current part of the date (a year, month or day)
Alt+DownDisplays the "Month Calendar" control. Same as clicking the "drop-down" arrow
PageUp, PageDownIf the "Month Calendar" control is active, moves to the previous/next month