i can access to my Forms primary collection with: ThisForm.primarycollection...
But, how can i access to another collection from C# code.
For example.
I am on Customers Form design, i need to know how to generate XML file with a tag for a every Sales Order that have my customer, so i need to load the SLPos Collection on my code to assign the OrderNum to my XML tag.
Sorry for my english.
Regards!
Dim response As LoadCollectionResponseData = IDOClient.LoadCollection(idoName, propertyList, filter, orderBy, recordCap)
That's VB which is the Form Script default language.
There are a few different ways, so it really depends on what you're after. Tim's answer is correct but it's in VB.NET not C#. I've been using C# over VB.NET in Forms and it's made my life SOOO much easier (personal preference). But I digress.... The C# equivalent of Tim's answer is: LoadCollectionResponseData response = IDOClient.LoadCollection(idoname,propertylist,filter,orderby,recordcap); The longer way (which I've been using [again, personal preference]) is to use a request object along with it: LoadCollectionRequestData request = new LoadCollectionRequestData(); LoadCollectionResponse response; request.IDOName = idoname; request.PropertyList.SetProperties(propertylist); request.Filter = filter; request.RecordCap = recordcap; request.OrderBy = orderby; response = IDOClient.LoadCollection(request); I've been doing it this way because it's clearer to me each parameter set. Again; personal preference. If the collection you are interested in is a Secondary Collection on your Form, you would use the ThisForm.GetSecondaryIDOCollection method with an int index (which I believe) starts at 2. Hope this helps :)
Using the IDOClient.LoadCollection method, is it possible to call a stored procedure? If so, can you provide an example?
Infor has broken functionality like this into different classes:
In the IDOClient, you simply call the appropriate method:
This PDF explains how to do the development in an IDO Extension Class. It's for Mongoose 9.03, so just be aware.
6180.IDO DevelopmentGuide - Mongoose 9.03.pdf
Thanks!
Hi,
Here is the same document for Mongoose v10
2047.Infor Mongoose IDO Development Guide mg_10.x_IDODevelopment.pdf
Thanks. This example is exactly what I needed.