How do i update more than one table in a qurery ?
Posted: 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.
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.