Viewing data in a form

Field types

Internally MacSQL classifies all data types into nine types. The form view decides what type of field to show based on these nine types.

String	Columns containing string values with a maximum length less than 100 characters are represented by a standard text field. This text field is configured to enforce the maximum length of the column.
Text Blob	Columns containg larger character fields are represented by a multi-line text view that includes scrollbars and undo support.
Numbers	Numeric columns are represented by a text field that only allows the approriate input based on the column's definition (positive/negative, decimals, etc.). Size limitations are enforced.
Dates	Dates are represented by a button and a string showing the date. Pressing the button opens a pop-up window that allows the date value to be edited.
Times	Time values are edited with a time control that divides the value into three fields: hour, minute, and seconds. Click in the field to edit and type the new value or use the mini-arrows.
DateTimes	DateTime values appear similar to Date values except a time control appears at the bottom of the pop-up window.
Blobs	Blobs are represented by a string showing the size of the blob and buttons to upload and download the blob value. The navigation sheet used to upload a file also includes a button to set the blob value to NULL. If the blob contains an image in GIF, PNG, JPG, TIFF, PDF, or EPS formats clicking on the button will display the image.
Enum	MySQL Enum values are displayed in a pop-up menu. If NULL is allowed, the first choice will be NULL. Otherwise, only the Enum choices will appear.
Set	MySQL Set columns are displayed as a matrix of checkboxes. If none are selected, NULL will be inserted.