Skip to Content
0

Deserialized DataTable does not create calendar date picker on Matrix.

May 25, 2017 at 01:13 PM

79

avatar image
Former Member

I'm creating XML to populate the DataTable, which is data source for matrix on custom form. Column that definided as "Date" does not create calendar picker in cells, but if I input wrong value in this cell, it thrown error "Date not valid", so it reconized date value. Same issue with "Quantity" field. Using method DataTable.ExecuteQuery() and than serialize table to XML, I get equal XML as I created, however in this case calendar picker appears.

// Picker not appears 
matrixSource.LoadSerializedXML(BoDataTableXmlSelect.dxs_All,xmlSource);
matrix.LoadFromDataSourceEx();

// Picker appears 
matrixSource.ExecuteQuery( query );
matrix.LoadFromDataSourceEx();

matrixSource.SerializeAsXML( BoDataTableXmlSelect.dxs_All ); // returns same XML in both cases.

Help please.

SAP Business One SDK
c# | date | matrix | calendar | datepicker | datatable
Answers Answers and Comments
10 |10000 characters needed characters left characters exceeded
▼ Viewable by all users
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Sort by:
Best Answer
avatar image
Former Member Answered May 25, 2017 at 01:50 PM
0

Oh, I found a solution. After deserialization you should use:

Form.Settings.Enabled = false;
Form.Settings.Enabled = true;

I hope this issue will be fixed.

Share
10 |10000 characters needed characters left characters exceeded
▼ Viewable by all users
avatar image
Danilo Kasparian Answered May 25, 2017 at 01:23 PM
1

Try to load data only using BoDataTableXmlSelect.dxs_DataOnly

You probably will need to format your xmlSource as well.

I believe when you load all, the metadata becomes text instead of date.

Show 1 Share
10 |10000 characters needed characters left characters exceeded
▼ Viewable by all users
Former Member
May 25, 2017 at 01:34 PM

Unfortunately did not help. I found that if I click on the matrix with the right mouse button and select the "Form UI Settings" menu, and then click OK in the opened form, the picher will appear (seems like form fully updates). But methods Form.Refresh(), Form.Update() or matrix.Item.Refresh() do not give the desired effect.

0
Comment