Executesql:
The ExecuteSQL is used for executing the query on the database. The CRecordset uses the RFX mechanism to replace data between field data members of the record set object and the equivalent table columns of the data source. The Record sets allow scrolling from record to record, updating records etc.