Skip to Content
0
Former Member
Mar 27, 2009 at 11:21 AM

Problem displaying price field using a Data Table bound to a matrix

25 Views

Hi

I've had to change some code that was being used in an add-on that was displaying data in a matrix on the Item Master Data form, as it was being bound using a DBDatasource and in order to order the data it had to be gone through record by record and then manually reordered, which was drastically slowing down the loading of the form. In order to solve this problem I bound the matrix to a Data Table using an order by statement which works great except it isn't displaying the price field correctly that is contained in the UDT. The prices are being shown as symbols such as: ᬗ or 퓐ᾆ instead of 454.550000, 338.840000, which are the values in the database.

If I change the execution query of the datatable to select a price field from another table e.g. PaidToDate from the ORDR table then this is being pulled in correctly.

Thanks