This topic is locked

Values not showing on List Page

3/27/2007 11:04:57 AM
ASPRunnerPro General questions
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,

  1. 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,
  2. 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

Sergey Kornilov admin 3/27/2007

Just in case make sure you didn't choose any "View As" type that is not compatible with with your data.
If this doesn't help publish your application to Demo Account and send a link to support@xlinesoft.com.

Corinne author 3/28/2007

Just in case make sure you didn't choose any "View As" type that is not compatible with with your data.

If this doesn't help publish your application to Demo Account and send a link to support@xlinesoft.com.


Yes, it was a problem with the view, Thanks!!