PdcDatabase.UserTableExists: Difference between revisions

From External Bemet Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
 
(One intermediate revision by the same user not shown)
Line 6: Line 6:


== 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=True'.
You can find all usertables in the menu 'pdc.maintenance.tables.userfields' and filter on field 'TB_ISUSERTABLE=True'.


Line 12: Line 12:


<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)