query not populating table

[LYSAMARIE]

The following is a query that I am trying to run. It runs without any errors, but the data in the table does not get updated. Any clues as to what I am doing wrong?




PARAMETERS PDate DateTime;
INSERT INTO [New Pricing] ( ManufacturerCode, Standard_Pack, [Date], Quantity_1, DistCost_1, SuggSalePrice_1, Quantity_2, DistCost_2, SuggSalePrice_2, Quantity_3, DistCost_3, SuggSalePrice_3, Quantity_4, DistCost_4, SuggSalePrice_4 )
SELECT DISTINCTROW "SIE" AS Expr1, SIE.STDPCKQTY, [PDate]
AS Expr4, SIE.STDPCKQTY, SIE.STDPCKCOST, [STDPCKCOST]*1.25 AS Expr2, SIE.STDPCKQTY, SIE.BRKNPCKCOST, [BRKNPCKCOST]*1.25 AS Expr3, SIE.STDPCKQTY, SIE.DSSTDPCKCOST, [DSSTDPCKCOST]*1.25 AS Expr5, SIE.STDPCKQTY, SIE.DSBRKNPCKCOST, [DSBRKNPCKCOST]*1.25 AS Expr6
FROM SIE;

 

[tlbroadbent]

Have you tried running the SELECT portion of the query standalone to make sure records are being selected? Do you get any messages when you run the query? Terry

http://members.home.net/tlbroadbent/prog.htm

The reason why worry kills more people than work is that more people worry than work. - Robert Frost

 

[LYSAMARIE]

Thanks for your help Terry. I just took your advice and ran the select portion. That came out exactly the way I wanted it to. I am not getting any errors when I run the query. This is really starting to drive me bonkers. I really don't know what to do next.