What R:azzak said...or you could just declare a form variable equal to the column you want to capture with the proper type, and whenever you enter the row, the variable will have the value of the associated column.
Javier, Javier Valencia, PE O: 913-829-0888 H: 913-397-9605 C: 913-915-3137 -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Jim Belisle Sent: Monday, February 18, 2013 4:53 PM To: RBASE-L Mailing List Subject: [RBASE-L] - changing prices One form has the list prices. Normally we do not want to change these but there are instances when it is needed. If there is a change I want to be able to compare the new with the old then have them give a reason. This information will be saved in a table for reference. If I use the GETPROPERTY listprice TEXTVALUE 'vnewprice' I end up with a text var. It needs to be a currency value in order to be saved to that field. What function would I use to convert back to a currency? Or am I going about this wrong? James Belisle Making Information Systems People Friendly Since 1990
