Problem with system Matrix with added user fields

[lars_jnsson]

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

[YatseaLi · Accepted solution]

Hello Lars,

Yes, the system matrix is not allowed to change the datasource. As David said, it is old problem that SpecialPrices have no UserFields property.

Maybe you can try Format Search to fill the data for this UDF.

Kind Regards

-Yatsea

[Nussi]

Hi,

that the SpecialPrices object has no userfields property is an old problem 😕

use a recordset (which is official forbidden) or save the information in another usertable.

lg David