SQLCreateTable

 

The SQLCreateTable function is a SQL function that creates a new database field.

 

int @SQLCreateTable(int id, string tablename, string bind_list);

 

Parameters

int id : Access number connected by SQLConnect

string tablename : Name the new table to create

string bind_list : bind list containing the columns to be created as the table is created.

 

Return Value

1 for success, 0 for failure

 

Example

i = @SQLCreateTable($AddrID, "Table1", "Name");

 

Description : Create a new data field with the connection ID of the linked database, the Table1 table, and the name of the list. When you create a new data field, the result is 1 or 0.

 

Related Helps

SQLConnect()

SQLDelete()

SQLDisconnect()

SQLExecute()

SQLFirst()

SQLGetPos()

SQLInsert()

SQLLast()

SQLNext()

SQLPrepare()

SQLPrev()

SQLSelect()

SQLSetPos()

SQLUpdate()