Field type is a characteristic indicating the method of representing and storing data in computer memory, the method of display on the screen and in printing, peculiarities of adding and editing operations.
ObjectLand supports the following field types: String, Integer, Real, Boolean, Date, Time, Timestamp and Object.
The field of string type is intended for storing data in the form of strings of any characters of any length. For example, the field “Street” in the table “List of Building Certificates” should be a string one.
In examples the string values are given in quotation marks: “East Str.” or “Hall Road” – street names, “John Brown” or “B. Jones” – names of parcel owners.
The field of integer type is intended for storing numeric data represented by integer numbers. For example, the fields “Building Number” and “Number of Storeys” in the table “List of Building Certificates” should belong to integer type.
The main difference of real type from integer one is a possibility to represent fractional numbers. For example, the field “Area” should belong to real type.
The field of Boolean type can have only one of two values “True” or “False”. For example, the field “Is Municipal?” in the table “List of Building Certificates” is of Boolean type. To guarantee the absence of values different from “true” and “False” in the fields, input of boolean values is performed by selection from the list.
Fields of date and time type serve for storing calendar dates and the time of the day accordingly. The field of timestamp type combines both above mentioned values. The format of time representation in ObjectLand corresponds to the time format set in Windows. The format of representing dates in ObjectLand corresponds to the short date format set in Windows. However, the year is always displayed in full and should be entered in full. For example, if the following short date format is specified in Windows settings: M/d/yy, then the date 4/3/1999 means April 3, 1999 and the date 4/3/99 – April 3, 0099.
The field of object type serves for storing OLE objects which are documents associated with different Windows applications which can be used as OLE servers. Microsoft Word documents, Excel sheets, etc. can be used as examples of OLE objects.
 |  |
