Please could you provide a sample code to insert or update a new row
in a table using UpdateRowSource?
How to use UpdateRowSource ?
Re: How to use UpdateRowSource ?
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.