How do i update more than one table in a qurery ?

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Yossi

How do i update more than one table in a qurery ?

Post by Yossi » Thu 09 Jun 2005 12:18

Using TMsQuery.
I have a query that takes data from some tables .
One main table and lookup information from other tables.
I want to let the user update all of them .
When I testted Apply update , it updated the main table only.
When I added a table in UpdatingTable Propery it updated it too ...
but I want to update all fields .
I tryed to use the FullRefresh Property with no success.
What should i do ?
Thanks , Yossi.

Ikar
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Post by Ikar » Thu 09 Jun 2005 14:10

You should write a query to SQLUpdate manually.

Post Reply