Imports data from a Fox cursor into a matching SQL table, provided the structures match and data types are compatible.
.T. or .F. Check cErrorMsg for error info.
Name of the SQL Server table to insert to. If omitted the ALIAS() is used.
The structures must be identical and field types must be compatible. If fields are omitted and NULL values aren't supported by the server errors will be generated. If the SQL table is missing fields the Fox table has you can use a SQL SELECT statement to filter the fieldlist before import and run against the VFP cursor.
You can also use cSkipFieldsForUpdates to filter out any fields you don't want to send to the server.
Code actually SCANs the Fox table and builds a dynamic INSERT statement for each record to update the SQL database. Data is always INSERTed.
loSQL = CREATE("wwSQL")
See also:Class wwsql
Comment or report problem with topic