Update more than one table

[krshin]

Hello,

Does UniDAC or any xxxDAC product of DevArt for Delphi can update more than one table in sama time. For example I have join query with 3 tables and I need to update all tables by some criteria (key value)?

Thanks in advance...

[azyk]

Hello,

Please specify the database you are working with, as this functionality can be implemented in different databases in different ways.

[krshin]

Hello,

I'm primary using SQL Server than Oracle and Firebird, because little users need small database and I use Firebird and standard users use SQL Server, and larger users with more request use Oracle as backend database.

Thanks for help...

[AlexP]

MS SQL Server
To update more than one table at a time, you should write a SQL query to TUniQuery.SQLUpdate for update of each table. The SQL query must be delimited by ";", for example:

Code: Select all

UPDATE EMP SET  ENAME = :ENAME  ,JOB = :JOB WHERE EMPNO = :EMPNO;
UPDATE DEPT SET   DNAME = :DNAME WHERE DEPTNO = :DEPTNO;

For Oracle, you can run similar commands in an anonymous block:

Code: Select all

BEGIN
UPDATE EMP SET  ENAME = :ENAME  ,JOB = :JOB WHERE EMPNO = :EMPNO;
UPDATE DEPT SET   DNAME = :DNAME WHERE DEPTNO = :DEPTNO;
END;