RE: Tango (Direct DBMS Update Question)

[Ben Johansen]

Set debug on and run the TAF so that you can see the final SQL statement in the debug information.   I am suspecting that the “$” Or you might need to set ENCODING in the @ARG Ben Johansen - http://www.pcforge.com Authorized Witango Reseller http://www.pcforge.com/WitangoGoodies.htm  Latest downloads & List Archives @ http://www.witango.ws -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Rob Vincent Sent: Tuesday, August 27, 2002 5: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