SQLCreateTable() function

You use the SQLCreateTable() function in an InTouch QuickScript to create a table in the database using the parameters from a specified Table Template. Table Templates are defined in the SQL.DEF file, which includes the structure of a database table.

Category

SQL

Syntax

[ResultCode=]SQLCreateTable(ConnectionID, TableName,TemplateName);

Arguments

ConnectionID

Name of a memory integer tag that holds the number (ID) assigned by the SQLConnect() function to each database connection.

TableName

Name of the database table you want to create.

TemplateName

Name of the template definition you want to use.

Examples

The following example of the SQLCreateTable() function creates a table named BATCH1 with the column names and data types defined in the OutputVal template:

ResultCode=SQLCreateTable(ConnectionID,"BATCH1",

"OutputVal");

See Also

SQLConnect()