Corinne author
Hi, I created a SQL query & when I run it all of my results come back just fine. I save the query as a view & use it as the datasource for this project & then I have a problem. The List page lists the correct amount of records that should be pulled from this view. All fields are filled in except any of the ones dealing with my net pricing. At first I figured I had something wrong with the view but I tried advanced search on the values that SHOULD be showing up in the Net pricing fields and the search brings back the expected number of rows. It's like the values are in the cells correctly but not showing on the list page. What could be the probelm causing the cell values not to be visable? Just in case here's the view: SELECT dbo.imProduct.ProductID, dbo.imProduct.ExtendedCore, dbo.ApplyMarkup(dbo.imCaseGoods.NetPrice, 1) AS 'Net', 'N/A' AS 'Grade A',
'N/A' AS 'Grade B', 'N/A' AS 'Grade C', 'N/A' AS 'Grade D', 'N/A' AS 'Grade E', 'N/A' AS 'Grade F', 'N/A' AS 'Grade G', 'N/A' AS 'Grade H', 'N/A' AS 'Grade 2',
'N/A' AS 'Grade 3', 'N/A' AS 'Grade 4', 'N/A' AS 'Grade 5', 'N/A' AS 'Grade 6', dbo.imProduct.ProductName, dbo.imProduct.WSpecies,
dbo.imProduct.OutsideDimensionString, dbo.imProduct.PriceListNarrative
FROM dbo.imProduct INNER JOIN
dbo.imCaseGoods ON dbo.imProduct.ProductID = dbo.imCaseGoods.ProductID
WHERE (dbo.imProduct.Status = 'A') AND (dbo.imProduct.ExtendedCore NOT LIKE '%JW-%')
UNION
SELECT imProduct_1.ProductID, imProduct_1.ExtendedCore, dbo.ApplySTKFUPricingMarkup(dbo.imUphCase.UphGradeA, 1) AS Net,
dbo.ApplySTKFUPricingMarkup(dbo.imUphCase.UphGradeA, 1) AS 'Grade A', dbo.ApplySTKFUPricingMarkup(dbo.imUphCase.UphGradeB, 1)
AS 'Grade B', dbo.ApplySTKFUPricingMarkup(dbo.imUphCase.UphGradeC, 1) AS 'Grade C', dbo.ApplySTKFUPricingMarkup(dbo.imUphCase.UphGradeD,
- AS 'Grade D', dbo.ApplySTKFUPricingMarkup(dbo.imUphCase.UphGradeE, 1) AS 'Grade E',
dbo.ApplySTKFUPricingMarkup(dbo.imUphCase.UphGradeF, 1) AS 'Grade F', dbo.ApplySTKFUPricingMarkup(dbo.imUphCase.UphGradeG, 1)
AS 'Grade G', dbo.ApplySTKFUPricingMarkup(dbo.imUphCase.UphGradeH, 1) AS 'Grade H', dbo.ApplySTKFUPricingMarkup(dbo.imUphCase.UphGrade2,
- AS 'Grade 2', dbo.ApplySTKFUPricingMarkup(dbo.imUphCase.UphGrade3, 1) AS 'Grade 3',
dbo.ApplySTKFUPricingMarkup(dbo.imUphCase.UphGrade4, 1) AS 'Grade 4', dbo.ApplySTKFUPricingMarkup(dbo.imUphCase.UphGrade5, 1)
AS 'Grade 5', dbo.ApplySTKFUPricingMarkup(dbo.imUphCase.UphGrade6, 1) AS 'Grade 6', imProduct_1.ProductName, imProduct_1.WSpecies,
imProduct_1.OutsideDimensionString, imProduct_1.PriceListNarrative
FROM dbo.imProduct AS imProduct_1 INNER JOIN
dbo.imUphCase ON imProduct_1.ProductID = dbo.imUphCase.ProductID
WHERE (imProduct_1.Status = 'A') AND (imProduct_1.ExtendedCore NOT LIKE '%JW-%') Thanks,
Corinne
|
|