da-soft - Data Access Technologies

Additional

dbCAP

AnyDAC

ThinDAC

NCOCI8

Topic: Update multi table join

Forum List » AnyDAC » v 1.x General English

MisterZ
User

Fresh Boarder

Posts: 1

Karma: 0

Update multi table join

Posted: 2007/09/21 22:21

Is there a (easy) way to update more than one table in a multi table join with AnyDAC ?

Diman

Admin

Posts: 1470

Karma: 18

Re:Update multi table join

Posted: 2007/09/21 23:36

Hello

You should use TADUpdateSQL. And as commands for ModifySQL, InsertSQL, DeleteSQL use multiple UPDATE/INSERT/DELETE commands grouped into batches/blocks. The exact syntax for grouping multiple commands into batches/blocks depends on your DBMS.

Regards,
Dmitry

Forum List » AnyDAC » v 1.x General English