Re: Tango (Direct DBMS Update Question)

`[Update Action]`	`[100]`	`Update`
`[Query]`	`[100]`	`UPDATE INVOICE SET INVBAL=INVBAL - 276.75 WHERE (INVNO=2002)`
`[Results Action]`	`[100]`	`Results`
`[Direct DBMS Action]`	`[100]`	`Direct_DBMS`
`[Query]`	`[100]`	`UPDATE INVOICE SET INVBAL = (INVBAL - 276.00) WHERE INVNO = 2002`
`[ActionResults]`	`[100]`
`[Results Action]`	`[116]`	`Posted_Response`

Listed above is the DEBUG screen for that procedure.

I have no idea where the First [Query] statement is coming from?????

I notice that the amount being subtracted is exactly the amount of the INVBAL column

so it will obviously generate a 0.00 (which it is doing now)

The Second Query statement would yield the correct result if it were processed by itself.

Do I have some kind of phantom code at play here?

(Hmmmmmmm)

- Rob Vincent

Reply via email to