All fields must have a specified data type. Any writes to the field will be type checked
based on the data type. A non-conforming value will cause an error to be returned.
It is possible, however, that a field of type INTEGER or ATOM will return an empty sequence.
This actually means that the field is NULL--no value has yet to be assigned to it.
- EUSQL_EU_INTEGER (INTEGER) Euphoria 31-bit signed integer
- EUSQL_EU_ATOM (ATOM) Euphoria atom
- EUSQL_EU_TEXT (TEXT) One dimension sequence with ASCII data of arbitrary length
- EUSQL_EU_SEQUENCE (SEQUENCE) Euphoria sequence of arbitrary length and complexity
- EUSQL_EU_BINARY (BINARY) One dimension sequence of arbitrary length with
integer elements between 0 and 255
- EUSQL_EU_OBJECT (OBJECT) Euphoria object (can be integer, atom or sequence), equivalent
to no type check.
- EUSQL_AUTONUMBER (AUTONUMBER) Euphoria atom. Fields of this data type should be
considered read-only, as only EuSQL can write to them. Any attempt to change a field
of type AUTONUMBER will result in an error. To get the value of the next number in
the sequence, use the function get_next_autonumber().
- EUSQL_EU_BOOLEAN (BOOLEAN) Euphoria integer. Valid values are 0 (false) and 1 (true).
In SQL statements you may use 'TRUE' and 'FALSE' when updating, inserting or within a WHERE clause
when referring to the value of a BOOLEAN field.
- EUSQL_EU_DATE_TIME (DATE_TIME) Date and time. See the Dates section for more information.
Follows a similar format as the Euphoria date() function,
except the year is the actual year (not year since 1900):
- year
- month -- January = 1
- day -- day of month, starting at 1
- hour -- 0 to 23
- minute -- 0 to 59
- second -- 0 to 59
Parent Topics:
Data
DB Management
Subtopics:
Dates