RE: Tango (Direct DBMS Update Question)

[Buddy Walker]

Title: Message

Rob   I just tested your update command it appears to work ok for me. Turn the debug on and look at you update statement.   Buddy -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Rob Vincent Sent: Tuesday, August 27, 2002 8:52 PM To: [EMAIL PROTECTED] Subject: Tango (Direct DBMS Update Question)   I am using the the following command in a Direct DBMS (SQL) statement in a Tango App:   UPDATE INVOICE SET INVBAL = (INVBAL - <@ARG AMOUNT>) WHERE INVNO = <@VAR NAME="invno" SCOPE="user">   The statement executes without error and updates the correct row and column,   however it appears the calculation of (INVBAL (minus) <@ARG AMOUNT>) is not being interpreted.   The value of <@ARG AMOUNT> alone is being placed in the column.   i.e.      The Column INVBAL = $300.00            The <@ARG AMOUNT> = $200.00              The Updated column should be = $100.00              ...  After the update, it shows $200.00  (or whatever the user keyed in)   Can anyone tell me why this may be happening, or perhaps a different way to achieve the same result?   Thanks,   Rob Vincent Dearborn Heights, Michigan