Problem in update , insert with Joined Query DataSet

G?ktan Elgin

Delphi Developer

Mon, 07 Apr 2003 03:00:00 GMT

Problem in update , insert with Joined Query DataSet

We are using, delphi 50 with update pack 1 and ADO with mdac 2.6 and
MS SQL Server 7 platform.

In BDE there is no problem to update or insert in Joined Query logic, it is
using Updatequery component but we could 'nt do these things in ADO.
Would you give us a simple code which can do update , insert with Joined
Query DataSet?

el...@havelsan.com.tr

Other Threads

1. How can we update or insert dataset with using Joined Query

2. Speed problems with updating new value to Query detail dataset (cached updates)

3. How to do an Update query or a Delete Query or an Insert Query using D3

4. Problem with SQL-query, update and insert date values

5. ADO, JOINS and UPDATE or INSERT

6. Inserting new records with LEFT JOIN query?

7. Update / Insert / Delete in a dbgrid with a TADOQuery as DataSet

8. TQuery DataSet did not get updated when insert a new record into a DBGrid

9. Problwmts with Insert/Update of dataSet

10. Update query joining two tables