Regard load detail PO line accroding to choose PO#+linenum

[Former Member]

Hi,Expert,

The scenario is as follow:

I create the form to copy from PO detail list , so I must get docentry + linenum that is primary key.

but loading PO line are so many that the system of PC halted.

Now I add the primary key of docentry + linenum as array form.

and then by running sql query to add martix .

How can I do to get a better solution?

Apperciate your help .

Best Regard

Eric Wang

[YatseaLi · Accepted solution]

Hello Eric,

1.Is it possible to use Grid instead of Matrix?

2.Working with xml will be better instead of add row by row in the matrix.

Prepare all purchase order lines in the matrix of the form as xml string before load the form from xml.

You may refer to the following thread:

[Slow performance of reading row by row in Grid|]

It will be better if you can post the code here for analysis.

Kind Regards, Yatsea