Board index » delphi » Is ADO capable of updating JOIN Tables?

Joie

Delphi Developer
Tue, 17 Sep 2002 03:00:00 GMT

Is ADO capable of updating JOIN Tables?

If ADO is capable of updating JOIN tables, could you show us an example
of codes.
 
Jonathan Robert

Delphi Developer
Tue, 17 Sep 2002 03:00:00 GMT

Re:Is ADO capable of updating JOIN Tables?


Yes,
Simply create a select statement and update the resulting dataset. Which
table gets updated depends on which Fields are in the select statement, and
which in the where and from statement.
I still haven't figured away around Identity fields
Jonathan.
Quote
"Joie" <jta...@pacbell.net> wrote in message

news:38E4EB83.16AF3DA8@pacbell.net...
Quote
> If ADO is capable of updating JOIN tables, could you show us an example
> of codes.

Eri

Delphi Developer
Fri, 20 Sep 2002 03:00:00 GMT

Re:Is ADO capable of updating JOIN Tables?


Look at the thread 'Record Not Found No Key Specified'

Quote
On Fri, 31 Mar 2000 10:16:35 -0800, Joie <jta...@pacbell.net> wrote:
>If ADO is capable of updating JOIN tables, could you show us an example
>of codes.

Eric

"If you don't know what you want
you probably won't be happy with what you get."

Other Threads

1. joined table update with ado in access

2. Updating/Deleting Join Tables in ADO

3. I am having trouble joining 3 table in the way I want

4. ADO Right Join Updates

5. updating record in a join query using ADO and Midas Component

6. ADO, JOINS and UPDATE or INSERT

7. ADO Right Join Updates

8. Update JOINed tables in Paradox using SQL

9. tquery : Unable to update fields in join tables

10. Handling joined tables with ADO?