R:Tango 2000 R:Base 6.5 Win2K pro server Never did this before. I have a column called I_Quantity in an Inventory table. It contains quantity on hand for a product. Is it possible to use an Update action to update this column by subtracting quantity_purchased from I_Quantity with a <@calc> statement?
IE: Column to update: I_Quantity Value: <@calc "Inventory.I_Quantity - quantity_purchased"> Or do I need to read the column first with a Search action. Set a variable equal to the "current quantity". Then use an Update action to the new quantity. If the first method is ok, is my reference to Inventory.I_Quantity ok or do I use a <@column Inventory.I_Quantity)? Thanks Steve Fogelson Internet Commerce Solutions ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
