How to use UpdateRowSource ?

[nuntio2000]

Please could you provide a sample code to insert or update a new row
in a table using UpdateRowSource?

[Oleg]

For example, you can set the following query to InsertCommand INSERT INTO DEPT VALUES(:p1,:p2,:p3);SELECT LAST_INSERT_ID() AS DEPTNO and LAST_INSERT_ID value will return in dataset if you use UpdateRowSource.FirstReturnedRecord. UpdateRowSource.OutputParameters makes no sense as output parameters don't work in MySQL now.