Purpose Clears the current row buffers and prepares for positioned insert at the end of a record set. The record is not actually written to the database until the Update method is run. Syntax DBStatement.Insert Compliance: Level 2 Example The following example uses a positioned insert to insert a record into a record set. Once the statement is in insert mode, the row buffers are assigned values and then updated to write the new record to the database: Sub Main()         Dim cnct As DBConnection         Dim stmt As DBStatement         cnct.OpenConnection("MyDSN")    'Open the data source "MyDSN"         stmt.OpenStatement(cnct, dbKeyset, dbRowver)         stmt.ExecuteSQL("SELECT * FROM My Table")         stmt.Insert                             'Insert a new record         stmt.Column("CustName") = "Harold"         stmt.Column("CustAddr") = "99 Main Street"         stmt.Column("CustLastContact") = Today         stmt.Update                             'Write new record to database         stmt.CloseStatement         cnct.CloseConnection            'Close the connection End Sub