Skip to Content
0
Sep 26, 2008 at 10:03 AM

Problem with system Matrix with added user fields

31 Views

Hi!

I've added some user defined fields to the Special Prices for business partners (OSPP) and added them to the existing matrix. I have added the columns to the maxtrix and data bound them. Looks ok.

Problem 1:

All new columns show 0 (numeric fields). But the forms DBDataSource has my added columns but with value = 0. I cannot do datasource.DoQuery() since it is a system datasource. Do I have to query the data using the recordset? Is that the only solution?

Problem 2:

How to save the changes in the added columns in the matrix to the db? The business object SpecialPrices have no UserFields property! Saving using the recordset works, but is this the only way?

What is the preferred way to deal with system matrixes with added user fields?

Regards

Lars Jönson