Use a WHERE clause in commands to qualify or restrict the rows affected by a 
command.

 


-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Dr. Fritz 
Luettgens
Sent: Tuesday, July 08, 2014 2:06 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Display Feedback on Data with the IFF function

Hi,

year(col1)      turnover(col2)          info(col3)
2011            3
2012            6                       +
2013            5                       -
2014            7                       +

I want to add to the info column  "+" or  "-"
with the UPDATE command using the
 IFF function (IFF('.v1<.v2','+','-'))
but cannot get it working because I think I need the year as reference.
Is there a different function I can use ?
Thank´s
fritz


Reply via email to