update / insert records with join

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
jkuiper
Posts: 138
Joined: Fri 04 Aug 2006 14:17

update / insert records with join

Post by jkuiper » Wed 21 Jan 2009 08:40

Is it possible to update or insert records when there's a join in the query statemement?
Top
Dimon
Devart Team
Posts: 2910
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Wed 21 Jan 2009 13:09

Yes, you can do it. You can use the UpdatingTable property to specify the table to be updated.
You can find more detailed information about this in the "Updating data with MyDAC dataset components" topic of MyDAC Help.
Top
jkuiper
Posts: 138
Joined: Fri 04 Aug 2006 14:17

Post by jkuiper » Thu 22 Jan 2009 12:09

thanks, I shall read it.
Top
Post Reply

Return to “MySQL Data Access Components”