Hello,
I have column called NewUsed in table. The data type is Logical. What it shows in simple select is either NEW or USED value. When I try to do a query to get only used one I put Where NewUsed = 0 (or NewUsed = "USED"). It raise error 223. I doesn't allow me to filter by that field.
I need to write query that allows me to insert same records for different dealer id. Please help how should i do.
Code snippet:
DEFINE VARIABLE brndlrvar LIKE brndlr.brndlr.
DECLARE c1 CURSOR FOR
SELECT brndlr
FROM brndlr.
OPEN c1.
REPEAT:
FETCH c1 INTO brndlrvar.
INSERT INTO dealer_promo
(BrnDlr, NewUsed, DescriptEngl, DescriptFrench, StartDate, EndDate, MinDollarLimit, MaxDollarLimit, Rate, DlrIncAmt,
DlrIncPct, DlrIncMaxAmt)
SELECT
brndlrvar, NewUsed, DescriptEngl, DescriptFrench, StartDate, EndDate, MinDollarLimit, MaxDollarLimit, Rate, DlrIncAmt,
DlrIncPct, DlrIncMaxAmt
FROM dealer_promo
where brndlr = "SK111111" and startdate = 07/22/2004 and NewUsed = 0
CLOSE c1.
I have column called NewUsed in table. The data type is Logical. What it shows in simple select is either NEW or USED value. When I try to do a query to get only used one I put Where NewUsed = 0 (or NewUsed = "USED"). It raise error 223. I doesn't allow me to filter by that field.
I need to write query that allows me to insert same records for different dealer id. Please help how should i do.
Code snippet:
DEFINE VARIABLE brndlrvar LIKE brndlr.brndlr.
DECLARE c1 CURSOR FOR
SELECT brndlr
FROM brndlr.
OPEN c1.
REPEAT:
FETCH c1 INTO brndlrvar.
INSERT INTO dealer_promo
(BrnDlr, NewUsed, DescriptEngl, DescriptFrench, StartDate, EndDate, MinDollarLimit, MaxDollarLimit, Rate, DlrIncAmt,
DlrIncPct, DlrIncMaxAmt)
SELECT
brndlrvar, NewUsed, DescriptEngl, DescriptFrench, StartDate, EndDate, MinDollarLimit, MaxDollarLimit, Rate, DlrIncAmt,
DlrIncPct, DlrIncMaxAmt
FROM dealer_promo
where brndlr = "SK111111" and startdate = 07/22/2004 and NewUsed = 0
CLOSE c1.