局部公式概述除了定义与属性相关全局在localformulas-gxxcourse.pdfVIP

LocalFormulas

Overview

•In

addition

to

defining

formulas

associated

to

attributes

(global

formulas,

at

the

KB

level),

it

is

also

possible

to

define

formulas

in

the

code

itself.

•We

call

this

case

of

formula

use:

inline

formulas

or

local

formulas.

•It

is

possible

to

define

inline

formulas

=

local

formulasin

the

source

of

procedures,

subroutines,

events,

etc.

•Behavior

depends

on

whether

they

are

defined:

•Within

the

For

Each

•Outside

the

For

Each

212

LocalFormulas

WithintheForEach

•Source

table

of

the

formula

=

Base

table

of

the

For

Each.

•It

is

possible

to

include

the

following

in

the

definition

of

the

formula:

•attributes

of

the

formulas

base

table

+

extended

table

•attributes

of

the

table

browsed

by

the

formula

+

ittended

table

•variablesFOREACHBASETABLE=COUNTRY

FORMULABASETABLE=COUNTRY

•Example:FORMULABROWSEDTABLE=CUSTOMER

ATTRIBUTEINCOMMON:CountryId

ForEachCountryId

NumberCustomers=Count(CustomerName)

EndFor

ATTRIBUTESTHATBELONGTOTHEDEF.OFTHEFORMULAARENOT

INVOLVEDINTHEDETERMINATIONOFTHEFOREACHBASETABLE

Thefollowingisanotherexampleofpossiblecode,wheretheformulaisdefinedinthewhereoftheForEach

itself,inordertofilterbythiscalc