Add and Get Matrix Data on a System Form !! With UI API

[Former Member]

Hi

Can i Add Data in a Matrix Cell on a System Form? with UI API??

I have to Add Matrix Data like this(link):

http://www.future.computer-help.at/help.htm

and how can i Get Matrix Data from a System Form?

Thanks

[Former Member]

Hi

You can have a look at Matrix and Data Source sample. Its in your C:\Program Files\SAP Manage\SAP Business One SDK\Samples\COM UI\ directory.

Bruce.

[Former Member]

I have already checked this Sample.

But thanks nevertheless.

<i>(I check always first the UI and DI Help.

Then I check the samples, and only then I post my problem into the forum.)</i>

I solved the problem now.

Here is the Code:

Set oItem = SBO_Application.Forms(FormUID).Items.Item("38")

Set Source = oItem.Specific

Set EText = Source.Columns("U_Charge").Cells(1).Specific

str = EText.Value

thanks Marcel

[former_member185703]

Hi Marcel,

Please note that you can also use datasources to get data on a system form!

In 2004 DBDataSources are accessible to get data also on system forms (in non-system forms also for adding/setting); this applied to UserDataSources already in 6.5...

Going over "Specific" will let you run into performance issues, if there are too many rows in a matrix; nevertheless, when you try to manipulate values in a system matrix you have no other choice currently.

Regards,

Frank

PS: Please note that there is a SDK Training (course TB1300) in Walldorf soon (Feb., 28th - Mar., 4th).

Maybe you might want to attend - instead of finding all by yourself () - though I appreciate that you try your best to find the answers before posting! Thanks!