Chapter 15 Writing SQL Statements in PowerDesigner

CLIENTEXPRESSION and SERVEREXPRESSION

Description

Uses the client and/or server expression of a business rule in the trigger template, template item, trigger, and procedure script.

Syntax

.CLIENTEXPRESSION(code of the business rule)

.SERVEREXPRESSION(code of the business rule)

Example

The business rule ACTIVITY_DATE_CONTROL has the following server expression:

activity.begindate < activity.enddate

In a trigger based on template AfterDeleteTrigger, you type the following macro in the Definition page of the trigger:

.SERVEREXPRESSION(ACTIVITY_DATE_CONTROL)

This generates the following trigger script:

activity.begindate < activity.enddate
end

Copyright (C) 2005. Sybase Inc. All rights reserved.