EVALUATE

1 rating

Evaluates expressions while the main command processes a set of records.

EVALUATE Â«expressionÂ»

expression

Any valid expression, but usually an assignment using LET and an aggregate function. If expression is complex, it must be enclosed in parentheses.

change all Employees where LastName = Smith
let Salary = 1.1 * Salary
evaluate (let ExtraCost = $ total(Salary * 0.1))

Determines how much extra money is needed after all employees named Smith are given a 10% pay raise.

let RegTot[1]=0 RegTot[2]=0 RegTot[3]=0
compute Sales
evaluate (let RegTot[RegNum] = RegTot[RegNum] + SalesAmt)

Calculates total sales by region assuming three regions were served by the same sales force.

1 rating