PdcDatabase.CreateUserTable

Declaration

CreateUserTable(TableName: String, TableDescription: String, FieldData: String) as boolean

Description

Using this method you can create a usertable inclusive all fields without any reorganization of the database.
This is only possible if the table doesn't exist already. To determine this use the method 'UserTableExists'.


The FieldData parameter is the most important and complex parameter in this method. It consists of 7 elements, separated by ~.

• Field Name
  

text value, cannot be empty, cannot exist in UF_FIELDNAME or VELDNAAM.

• Field Description
  

text value

• Field Type:
  

TEXT: Length >0, number of decimals = 0 and the length of the default value <= length

CHOICE: text value, length >0, number of decimals = 0, and the length of the default value <= length, choices are separated by #. If a default value is provided it needs to exists in the list of choices.

NUMERIC: fieldlength = 0, number of decimals <+ 00, if a default value is provided it needs to be numeric.

CURRENCY: fieldlength = 0, number of decimals <+ 00, if a default value is provided it needs to be numeric.

Notes

After creating a table with this method, you have to restart PdC, to have the new table shown in the menu of PdC.

Availability

Available since 11-12-2015 (from version 5.1 onwards)