PdcDatabase.UserTableExists: Difference between revisions
Jump to navigation
Jump to search
Created page with "== Declaration == UserTableExist(TableName: String) as boolean == Description == Checks wether a table does already exist or not. == Notes == This call is only for usertable..." |
No edit summary |
||
| (2 intermediate revisions by the same user not shown) | |||
| Line 3: | Line 3: | ||
== Description == | == Description == | ||
Checks wether a table does already exist | Checks wether or not a table does already exist in the PdC database. | ||
== Notes == | == Notes == | ||
This call is only for usertables. Also the name of the table must start with 'UT_' which is the required naming convention in PdC. | This call is only for usertables. Also the name of the table must start with 'UT_' which is the required naming convention in PdC.<br> | ||
You can find all usertables in the menu 'pdc.maintenance.tables.userfields' and filter on field 'TB_ISUSERTABLE'. | You can find all usertables in the menu 'pdc.maintenance.tables.userfields' and filter on field 'TB_ISUSERTABLE=True'. | ||
== Code example == | == Code example == | ||
<source lang="vb"> | <source lang="vb"> | ||
if pdc.Database.usertableexists("UT_TABLE") then | |||
msgbox "Yes, table exists." | |||
else | |||
msgbox "No, it does not exists." | |||
end if | |||
</source> | </source> | ||
== Availability == | == Availability == | ||
Available since 11-12-2015 (from version 5.1 onwards) | Available since 11-12-2015 (from version 5.1 onwards) | ||
Latest revision as of 11:21, 11 December 2015
Declaration
UserTableExist(TableName: String) as boolean
Description
Checks wether or not a table does already exist in the PdC database.
Notes
This call is only for usertables. Also the name of the table must start with 'UT_' which is the required naming convention in PdC.
You can find all usertables in the menu 'pdc.maintenance.tables.userfields' and filter on field 'TB_ISUSERTABLE=True'.
Code example
if pdc.Database.usertableexists("UT_TABLE") then
msgbox "Yes, table exists."
else
msgbox "No, it does not exists."
end if
Availability
Available since 11-12-2015 (from version 5.1 onwards)