Hi Schalk,

> Can somebody help me with the syntax of EVAL.  I want to execute a SELECT
> on a file to get all records where (field 16)*0.9 < field(17).

Various ways to do this.  Try...
   SELECT file WITH EVAL "F16 * 0.9 < F17" = 1
where F16 and F17 are field names from the dictionary.

The most common mistake is to miss off the = 1 at the end.  Remember, this
EVAL expression is going to return true or false.

Martin Phillips
Ladybridge Systems
17b Coldstream Lane, Hardingstone, Northampton NN4 6DB

u2-users mailing list

Reply via email to