Update recordset

Hi,

Is the Update method of a recordset has the same efect like 'Commit' in SQL?

Thanks, Lior

After I did a little research, the commit in SQL is somewhat similar to update in recordsets. But, you should remember that every COMMIT command must correspond with an earlier executed SET TRANSACTION or BEGIN TRANSACTION command.

I believe the only difference between them is that you cannot nest recordsets the way you can nest transactions. I could be wrong, but that is what I uncovered during the research.

I hope this helps. Good Luck!