PX_FIELD_ALPHA |
Character data with fixed length |
PX_FIELD_DATE |
Date, number of days since 1.1.0000 |
PX_FIELD_SHORT |
Short integer (2 Bytes) |
PX_FIELD_LONG |
Long integer (4 Bytes) |
PX_FIELD_CURRENCY |
same as PX_FIELD_NUMBER |
PX_FIELD_NUMBER |
Double |
PX_FIELD_LOGICAL |
Boolean |
PX_FIELD_MEMOBLOB |
Binary large object |
PX_FIELD_BLOB |
Binary large object (not supported) |
PX_FIELD_FMTMEMOBLOB |
Binary large object |
PX_FIELD_OLE |
OLE object (basically a blob, not supported) |
PX_FIELD_GRAPHIC |
Graphic (basically a blob, not supported) |
PX_FIELD_TIME |
time, number of milli seconds since midnight |
PX_FIELD_TIMESTAMP |
timestamp, number of milli seconds since 1.1.0000 |
PX_FIELD_AUTOINC |
Auto incrementing interger (like PX_FIELD_LONG) |
PX_FIELD_BCD |
Decimal number stored in bcd format (not supported) |
PX_FIELD_BYTES |
Array of Bytes with not more than 255 bytes (not supported) |
PX_KEYTOLOWER |
Turn all field names into lower case |
PX_KEYTOUPPER |
Turn all field names into upper case |