The SQLInsert function is a SQL function that inserts a single column.
void @SQLInsert(int id, string tablename, string bindlist);
Parameters
int id : Access number connected by SQLConnect
string tablename : Name of the table to use
string bindlist : bind list to use
Return Value
None
Example1
@SQLInsert($AddrID, "Table1", "bindaddr");
Description : Insert the new record into the bindaddr list of the Table1 table in the linked database.
Example2
id = @SQLConnect("ODBCDNSName","","");
@SQLInsert(id, "Table1","BindList");
@SQLDisconnect(id);
Description :
Add the values of the tags linked to the BindList in the SQL connection settings to the table Table1 of the ODBC linked database source file as fields in the linked database. In other words, it adds a new record to Table1.
Related Helps