Reading data & copying to the matrix taking much time

[Former Member]

Hello Experts,

I am trying to copy data from Stock Transfer to the Stock Revalution form based on the docentry for that i have created a button in

Stock Transfer form as "Copy To Revaluation" on click of that that button data get copied to the matrix of Stock Revalution

like Item Code,Quantity .I have done that using Record set reading line from database and putting in the matrix row by row

which is taking much time to fill the matrix one row by row using following :-

While Not Recordset.EOF

Omatrix.Columns.Item("1").Cells().Item(i).specific.Value=Recordset.Fields.Item(0).Value

Its taking much time but i want to make the data filling much quicker how to do that as i am not able to fill the data quickly in the matrix.

Thanks & Regards,

Amit

[Former Member]

Hello Guys,

If i want to copy data from sales order to my own created User Form will it be possible to retrieve data based on datasource

if yes then please provide some sample codes using Datasource with Offset feature.

Thanks & Regards,

Amit

[former_member577408]

Hi!

You can speed up the process by freezing the form for the duration of your matrix fill. Just be sure you always unfreeze the form, no matter what or else the form will stop working. I recommend something like this (in csharp):

activeForm.Freeze(true);
try
{
    // fill your matrix here
}
catch (Exception ex)
{
    // some error handling
}
finally
{
    activeForm.Freeze(false);
}

Regards,

Tero

[Former Member]

Hello Amit,

If you do not need user interaction in revaluation, you can issue revaluation over DI API, which is so much faster.

Regards,

J.

[Former Member]

Hi Amit,

As far as you are using a matrix, you really can't do anything about that. It will fill the values cell by cell and that surely will take time. In case the target document is your own form and just for viewing purpose, then in that case, you can use a grid, which is much faster than matrix.

But in your case, I don't think you can do anything about that.

Regards,

Satish.