Creates a new table in the database.
void FCODKDriver::TableCreate(const char *tableName, unsigned char pkLen, unsigned char retentionUnit, const char *retentionMeasure)
Parameters:
Invalid Value Error Conditions:
A Table Name must:
If the name is less than 64 bytes, which will often be the case, the byte following the end of the name must be set to NULL.
If the name is 64 bytes, then the NULL character does not and cannot exist at the end.
Invalid Value Error Conditions:
A zero-length Primary Key is not allowed.
A Primary Key has a fixed length.
The length cannot be changed after the table is created.
The length must be large enough to uniquely identify each record in a table.
The database automatically creates an index on the Primary Key when a table is created.
The index makes looking up records in the table fast and efficient.
When a Primary Key is shorter than the Primary Key Length, you must pad the unused bytes at the end with NULL.
Invalid Value Error Conditions:
The default is 13. Thus, when the value is NULL, the driver uses 13.
For best performance, this number should not exceed 25.
Invalid Value Error Conditions:
"year "
"month "
"day "
"hour "
"minute"
The default is "month". Thus, when the value is NULL, the driver uses "month".
Retention Unit and Retention Measure work together to define the Retention Period, such as 13 months.
Invalid Value Error Conditions:
Result Values: N/A
Expected Errors:
When an Error Occurs: