Schalk, SELECT file WITH EVAL "(@RECORD<16> * .9 > @RECORD<17>)" = 1
Assuming that both fields are stored scaled to the same number of decimal places. Brian Leach > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Schalk van Zyl > Sent: 11 March 2004 19:21 > To: U2 Users Discussion List > Subject: EVAL > > U2-ers, > > UNIVERSE. > 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). > Thanks. > Schalk > > --------------------------------------------------------- > GWK BEPERK/LIMITED (REG: 1997/022252/06) POSBUS 47 PO BOX 8730 DOUGLAS > > Direkteure/Directors: NB Jacobs, FJ Lawrence, J v/d S Botes, > JH Coetzee, JGD Smit, JF Jacobs, AO M�ller, JW Smit, JP > Snyman, JG Stander, JH van Dyk(MD/BD), JG Jacobs, A M�ller, > Sekr/Secr: E van Niekerk. > > Hierdie e-pos is onderworpe aan 'n vrywaring beskikbaar by: > http://www.gwk.co.za/DisclaimerVrywaring.asp > This e-mail is subjected to the disclaimer that can be viewed at: > http://www.gwk.co.za/DisclaimerVrywaring.asp > > ________________________________________________________________________ This email was checked on leaving Microgen for viruses, similar malicious code and inappropriate content by MessageLabs SkyScan. DISCLAIMER This email and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and do not disclose the contents to any other person, use it for any purpose, or store or copy the information. In the event of any technical difficulty with this email, please contact the sender or [EMAIL PROTECTED] Microgen Information Management Solutions http://www.microgen.co.uk -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
