Tango (Direct DBMS Update Question)

[Rob Vincent]

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