Visionary User's Guide

Visionary User's Guide
Appendix B: Data Types, Casts, and Value Formats

Home Contents Index Master Index New Book

Data Types

Object property expressions result in one of the following base Informix data types:

Boolean
Numeric
Point
PointList
String

Visionary data types are derived from the Informix base types Numeric and String, but they have additional restrictions.

Visionary types derived from Numeric include:

Color
DateTime
Enum
Integer
Percentage

Visionary types derived from String include:

FilePath (used also for URLs)
FontName

The following table lists the data types that are valid for object properties. For each property, you must enter one of the valid values or enter a property expression that results in one of these valid values.


Data Types	Valid Values
Boolean	`t \| true \| f \| false`
Numeric	`[`Sign`] <`Binary `\|` Octal `\|` Hex `\|` Integer `\|` Real `\|` Date `\|` ColorName`>`
Point	`(` Numeric `,` Numeric `)`
PointList	Point `[`Point`[...]] \| ([`Numeric `,` Numeric `[,`Numeric `,`Numeric `[]]] )`
String	StringQuote `[`char `[`char `[...]]]` StringQuote
Color	ColorName `\| <`Value between 0 and 2553-1, inclusive`>`
DateTime	StringQuote `<`y-m-d`[` hh:mm`[:`ss`[.[`Digits`]]]] \|`format as set by Window's locale setting`>` StringQuote
Enum	Integer `\|` NamedValue
Integer	Digits
Percentage	Numeric
FilePath	`<`StringQuote `<`UncPath `\|` LocalPath `\|` URL`>`StringQuote`> \|` BlobColumn
FontName	`<`String corresponding to valid Windows Font face name`>`

The following table lists the supporting syntax for these constants.

Constant Syntax
Binary
b BinaryDigit [BinaryDigit [...]]

Octal
o OctalDigit [OctalDigit [...]]

Hex
h HexDigit [HexDigit [...]]

Real
[Digits] [.[Digits]] [<d | e>[Sign]Digits]

Sign
+ | -

Digits
Digit [Digit [...]]

Digit
0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9

BinaryDigit
0 | 1

OctalDigit
0 | 1 | 2 | 3 | 4 | 5 | 6 | 7

HexDigit
Digit | a | b | c | d | e | f

StringQuote
" | `

ColorName
black | blue | aqua | lime | fuschia | red | yellow | white | navy | teal | green | purple | maroon | olive | gray | silver

NamedValue
String corresponding to a valid enumerated value as determined by the object property

Char
<ASCII code 1-255> | SpecialChar

SpecialChar
\n (for carriage return) | \" (for double quote)

BlobColumn
Query column alias returning a large object

UncPath
[WhiteSpace] FileSeparator FileSeparator ServerName FileSeparator ShareName FileSeparator [DirectoryName FileSeparator [DirectoryName FileSeparator []]] FileId

LocalPath
[DriveLetter :] [FileSeparator] [DirectoryName FileSeparator [DirectoryName FileSeparator []]] FileId

FileSeparator
\ | /

ServerName
FileChar [FileChar [FileChar []]]

ShareName
FileChar [FileChar [FileChar []]]

DirectoryName
FileChar [FileChar [FileChar []]]

FileId
FileChar [FileChar [FileChar []]]

FileChar
ASCII code 20-255 excluding the characters :, *, ?, ", <, >, and |

DriveLetter
a | b | c | | z

URL
<http:// | ftp:// | gopher:// | www.> [UrlChar [UrlChar [...]]]

UrlChar
ASCII code 21-255 excluding the characters :, *, ?, ", <, >, and |

Visionary User's Guide, version 1.0
Copyright © 1998, Informix Software, Inc. All rights reserved.