How to apply [Apply when modifying] with DDL command? 어떻게 하면 DDL 명령어로 [수정 시 적용] 을 적용함

[roseweb]

I want to apply Apply on Modify with NEXUS DDL command to each table as check. (Apply on Modify with NEXUS DDL 명령을 각 테이블에 체크로 적용하고 싶습니다.)


It can be applied as follows with the DELPHI command,
(DELPHI 명령어로 다음과 같이 적용할 수 있으며,)
===============================================
SQL Statement :
"InsertTime" TIMESTAMP DEFAULT CURRENT_TIMESTAMP DESCRIPTION 'Insert Time',
"UpdateTime" TIMESTAMP DEFAULT CURRENT_TIMESTAMP DESCRIPTION 'Update Time',
"UpdateUser" NVARCHAR(50) DEFAULT CURRENT_USER DESCRIPTION 'Lasted Update User',

Delphi :
with AddField('InsertTime', 'Insert Time', nxtDateTime, 0, 0, False) do
AddDefaultValue(TnxCurrentDateTimeDefaultValueDesc riptor);

with AddField('UpdateTime', 'Update Time', nxtDateTime, 0, 0, False) do
with AddDefaultValue(TnxCurrentDateTimeDefaultValueDesc riptor) as TnxCurrentDateTimeDefaultValueDescriptor do begin
ApplyOnModify := True;
OverwriteNonNull := True;
end;
with AddField('UpdateUser', 'Lasted Update User', nxtWideString, 50, 0, False) do
with AddDefaultValue(TnxCurrentUserDefaultValueDescript or) as TnxCurrentUserDefaultValueDescriptor do begin
ApplyOnModify := True;
OverwriteNonNull := True;
end;

SQL statement - only Table Insert
Delphi - insert or modify and ALL
===============================================

I want to apply Apply on modify to the entire table in batches with DDL command
(DDL 명령을 사용하여 일괄적으로 전체 테이블에 수정 시 적용을 적용하고 싶습니다.)
Is there no way?
(방법이 없을까요?)

[Eivind]

Originally Posted by roseweb

I want to apply Apply on Modify with NEXUS DDL command to each table as check. (Apply on Modify with NEXUS DDL 명령을 각 테이블에 체크로 적용하고 싶습니다.)


It can be applied as follows with the DELPHI command,
(DELPHI 명령어로 다음과 같이 적용할 수 있으며,)
===============================================
SQL Statement :
"InsertTime" TIMESTAMP DEFAULT CURRENT_TIMESTAMP DESCRIPTION 'Insert Time',
"UpdateTime" TIMESTAMP DEFAULT CURRENT_TIMESTAMP DESCRIPTION 'Update Time',
"UpdateUser" NVARCHAR(50) DEFAULT CURRENT_USER DESCRIPTION 'Lasted Update User',

Delphi :
with AddField('InsertTime', 'Insert Time', nxtDateTime, 0, 0, False) do
AddDefaultValue(TnxCurrentDateTimeDefaultValueDesc riptor);

with AddField('UpdateTime', 'Update Time', nxtDateTime, 0, 0, False) do
with AddDefaultValue(TnxCurrentDateTimeDefaultValueDesc riptor) as TnxCurrentDateTimeDefaultValueDescriptor do begin
ApplyOnModify := True;
OverwriteNonNull := True;
end;
with AddField('UpdateUser', 'Lasted Update User', nxtWideString, 50, 0, False) do
with AddDefaultValue(TnxCurrentUserDefaultValueDescript or) as TnxCurrentUserDefaultValueDescriptor do begin
ApplyOnModify := True;
OverwriteNonNull := True;
end;

SQL statement - only Table Insert
Delphi - insert or modify and ALL
===============================================

I want to apply Apply on modify to the entire table in batches with DDL command
(DDL 명령을 사용하여 일괄적으로 전체 테이블에 수정 시 적용을 적용하고 싶습니다.)
Is there no way?
(방법이 없을까요?)

In SQL, you would apply changes on existing records using the UPDATE ... statement.

To apply changes for new or modified records, you write a TRIGGER. See our SQL docs for syntax.