SIMPOL Documentation

odbc2_createodbctable()

Description

Creates an empty table on the specified ODBC connection which has a structure matching that of the supplied table or fields. If the return value is not .nul then the function has failed and the string contains information describing the error.

Prototype

odbc2_createodbctable ( odbc1connection con, type(db1table) table, string name, array fields )

Parameters

ParameterDefault valueType nameDescription
conNoneodbc1connection Specifies the ODBC connection on which the new table will be created.
table.nultype(db1table) Gives an object representing a table which will be used to provide information for the new ODBC table. If table is not supplied, or is .nul, then name and fields must be supplied.
name.nulstring Gives the name of the new table to be created. If no name is supplied then the name of table is used.
fields.nularray Gives a number of fields which are used to define the columns of the new table. If fields is not supplied then the fields of table are used. If fields is supplied then fields[] must contain the number of fields being supplied, and a consecutive sequence of elements of fields, starting at fields[1], must contain references to the fields to use.