How to use UpdateRowSource ?

How to use UpdateRowSource ?

Postby nuntio2000 » Fri 19 Nov 2004 18:38

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

Re: How to use UpdateRowSource ?

Postby Oleg » Thu 25 Nov 2004 10:44

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.
Oleg
Devart Team
 
Posts: 264
Joined: Thu 28 Oct 2004 13:56


Return to dotConnect for MySQL