Deleting Join Tables in ADO

Dingzky

Delphi Developer

Fri, 03 Jan 2003 03:00:00 GMT

Updating/Deleting Join Tables in ADO

BDE dataset just needs TUpdateSQL to update/delete join tables. How
about ADO, how could you do it using TADOQuery or any other ADO
Components?.

David B.

Delphi Developer

Sat, 04 Jan 2003 03:00:00 GMT

Re:Updating/Deleting Join Tables in ADO

Hi
which database??
in mssql 7 join tables are not read only result set
there is no problem to update joins but...... be carefull ---
if you delete a line from this join data from both tables will be deleted
you can look back in this newsgroup to find out more about it

Regards

David agros...@arava.co.il

Quote

"Dingzky" <Ding...@joydesk.com> wrote in message

news:3973E45C.BB26CCE0@joydesk.com...

Quote

> BDE dataset just needs TUpdateSQL to update/delete join tables. How
> about ADO, how could you do it using TADOQuery or any other ADO
> Components?.

Brian Bushay Tea

Delphi Developer

Sun, 05 Jan 2003 03:00:00 GMT

Re:Updating/Deleting Join Tables in ADO

Quote

>BDE dataset just needs TUpdateSQL to update/delete join tables. How
>about ADO, how could you do it using TADOQuery or any other ADO
>Components?.

Most SQL server back ends and Access too return an updateable query from a Join
so you probably will not need the capabilities of a TupdateSQL with ADO

--
Brian Bushay (TeamB)
Bbus...@NMPLS.com

Dingzk

Delphi Developer

Sun, 05 Jan 2003 03:00:00 GMT

Re:Updating/Deleting Join Tables in ADO

Quote

"David B.E" wrote:
> Hi
> which database??
> in mssql 7 join tables are not read only result set
> there is no problem to update joins but...... be carefull ---

Our database is ORACLE 8i. Basically, in our join tables, only one table will
be updated/deleted. In TUpdateSQL, it's so easy to do this scenario, but ADO,
Iam new with it, so I don't really know much of it.

Other Threads

1. joined table update with ado in access

2. Is ADO capable of updating JOIN Tables?

3. ADO Right Join Updates

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

5. ADO, JOINS and UPDATE or INSERT

6. ADO Right Join Updates

7. JOIN SQL, autoSQL and Delete record from this JOIN SQL

8. HELP with Deleting Records in Joined Tables

9. DELETE INVOLVING JOINING OF 3 TABLES

10. ADOQuery: SQL with JOIN / UPDATE-DELETE AFFECTS JOINED TABLES - IT'S NO GOOD!