I have a temp table that holds header information about a sales order. One of
the values is a discount rate (data type real). I use a update to fill the
values need
UPDATE tEstimateHeader SET DiscountAmount = 1.00
UPDATE tEstimateHeader SET CodDiscountAmount = 1.00
SELECT DiscountID INTO vDiscountID INDIC ivDiscountID FROM Customer +
WHERE CustID = .vCustID
SELECT DiscountAmount INTO vDiscountAmount INDIC ivDiscountAmount FROM
CustomerDiscTiers +
WHERE DiscountID = .vDiscountID
UPDATE tEstimateHeader SET DiscountID = .vDiscountID
IF vDiscountAmount < 1.0 THEN
UPDATE tEstimateHeader SET DiscountAmount = .vDiscountAmount
ELSE
UPDATE tEstimateHeader SET CodDiscountAmount = .vDiscountAmount
ENDIF
Seem to work just fine here. Next thing i do is a check into a different kind
of discount
SELECT COUNT(*) INTO vRows FROM CustomerJobs +
WHERE CustID = .vCustID AND JobID = .vJobID AND DiscountID <> NULL
IF vRows > 0 THEN
UPDATE tEstimateHeader SET DiscountAmount =1.00
UPDATE tEstimateHeader SET CodDiscountAmount = 1.00
SELECT DiscountID INTO vDiscountID INDIC ivDiscountID FROM CustomerJobs +
WHERE CustID = .vCustID AND JobID = .vJobID
SELECT DiscountAmount INTO vDiscountAmount INDIC ivDiscountAmount FROM
CustomerDiscTiers +
WHERE DiscountID = .vDiscountID
UPDATE tEstimateHeader SET DiscountID = .vDiscountID
UPDATE tEstimateHeader SET DiscountAmount = .vDiscountAmount
ENDIF
Also seems to work ok. As soon as you do a saverow a you lose your data updated
above. What am i doing wrong
Victor Timmons
Tiz's Door Sales, Inc
425-258-2391
