PdcDatabase.CreateUserTable: Difference between revisions

From External Bemet Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
Line 5: Line 5:
Using this method you can create a usertable inclusive all fields without any reorganization of the database.<br>
Using this method you can create a usertable inclusive all fields without any reorganization of the database.<br>
This is only possible if the table doesn't exist already. To determine this use the method 'UserTableExists'.<br>
This is only possible if the table doesn't exist already. To determine this use the method 'UserTableExists'.<br>
<br />
<br />
The FieldData parameter is the most important and complex parameter in this method. It consists of 7 elements, separated by ~.<br />
* Field Name<br />
:text value, cannot be empty, cannot exist in UF_FIELDNAME or VELDNAAM.<br />
* Field Description<br />
: text value<br />
* Field Type: <br />
: TEXT: Length should be >0 and the length of the default value <= length <br />
: CHOICE:


== Notes ==
== Notes ==

Revision as of 11:35, 9 February 2016

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 should be >0 and the length of the default value <= length
CHOICE:


Notes

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

Code example

Availability

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