SQLSelectIntoCreateRecordCopyInstance Method

Create an instance of a SQLSelectInto object appropriate for copying a record or records in the same table. The method will use GetSchemaInfo(String, SchemaInfoType) to determine the table's columns and set up the SQLSelectInto object for copying all columns except those indicated as IsIdentity.

Using the returned SQLSelectInto object you can use AddColumn(String, OleDbType, String, OleDbType), AddExpression(String, String, Boolean), or AddLiteral(Object, String, OleDbType) to replace a destination column source if changes are required. To perform the actual copy, call Execute(IDatabase, SQLHelperFlags, String).

public static SQLSelectInto CreateRecordCopyInstance(
	IDatabase db,
	string table,
	string filter
)

Public Shared Function CreateRecordCopyInstance ( 
	db As IDatabase,
	table As String,
	filter As String
) As SQLSelectInto