biuan SAP® BUSINESS ONE SDK
API User Tables MD / Add
Add Method

Description

Adds a new table to the User-Defined Tables collection. The new table includes two columns by default: Code and Name, where the Code column is the primary key of the specific user table.

Syntax

Visual Basic
Public Function Add() As Long

Remarks

When adding a user table, SAP Business One automatically adds the symbol @ as a prefix to the table name. For example, if you add a table named ABC, the resulting table name is @ABC. When referring to a user-defined table, you must use the name including the prefix @.

When adding a user table and assigning it a TableName, the DI API creates the table with an upper case name. By default, Microsoft SQL Server is not case sensitive. If it is configured to be case sensitive, make sure to specify the table name in upper-case when using the DoQuery method of the Recordset object.

See Also

Related information


Bo UTB Table Type BoUTBTableType Enumeration
Specifies the table types for user defined tables.
   Parent: User Tables MD UserTablesMD Object· Table: OUTB


SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates