Bill, Unfortunately I cannot make it to the Corroboree this year. Hopefully With Ent will consider a Midwest location like Minneapolis/St Paul next year.
Your (I_Quantity - <@VAR quantity_purchased>) suggestion did work. Thanks for the help. Steve -----Original Message----- From: Bill Downall [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 09, 2003 3:54 PM To: [EMAIL PROTECTED] Subject: Re: Witango-Talk: In-place Update Steve, Are you coming to the Corroboree? I'll show an example like this in my presentation. You can do it within an <@CALC> inside the new value field, or you can do it without <@CALC>, using an expression understood by your database system. In this case, in the "Update them with these values" dialog, under Value, put something like: (I_Quantity - <@VAR quantity_purchased>) And under "Column" put I_Quantity Be sure you don't "quote value". Bill On Tue, 9 Sep 2003 15:00:29 -0500, Fogelson, Steve wrote: >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? ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
