Consider making the root of the XLM object singular, such as Customer with List<Orders> as an element of it?
On Tue, Apr 21, 2020 at 3:15 PM Tracy Pearson <tr...@powerchurch.com> wrote: > For what I have been working on, it has been an Xml string that I can > process to and from a cursor with the XmlAdapter. > In C# I can process it to and from a List<T>. > The XmlAdapter will nest related tables such as Orders and OrderItems and > bring that back to VFP cursors from the Xml string that is returned. > In C# it would be a List<Orders> and has a List<OrderItems> as one of the > properties. > > You have more functions available to you in the COM object then the VFP > OleDB Provider. > > -----Original Message----- > From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of MB > Software Solutions, LLC > Sent: Tuesday, April 21, 2020 3:47 PM > To: profoxt...@leafe.com > Subject: Re: Office automation using VFP 10 64-bit version > > What's the return type? An object with all of the properties? I'm sure > you're not returning single values for everything. > > > On 4/21/2020 11:23 AM, Tracy Pearson wrote: > > It could, but I just call methods in the COM object to get data. > > > > -----Original Message----- > > From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of MB > > Software Solutions, LLC > > Sent: Tuesday, April 21, 2020 11:11 AM > > To: profoxt...@leafe.com > > Subject: Re: Office automation using VFP 10 64-bit version > > > > So the front end C# app....it's referring to the VFP COM object > > properties in its UI? > > > > > > On 4/21/2020 11:04 AM, Tracy Pearson wrote: > >> You can write a VFP COM object that holds the business logic, and data > >> access, if you are still using VFP Tables and update the UI with a > 64-bit > >> WPF application. Or a Web project that accesses the VFP data of a VFP > >> desktop application. > >> The VFP COM object could call code in the VFP Desktop application. > >> > >> > >> -----Original Message----- > >> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of MB > >> Software Solutions, LLC > >> Sent: Tuesday, April 21, 2020 10:53 AM > >> To: profoxt...@leafe.com > >> Subject: Re: Office automation using VFP 10 64-bit version > >> > >> On 4/20/2020 9:15 AM, Tracy Pearson wrote: > >>> You are able to use an OUT of process COM across the 64-bit & 32-bit > >>> barrier. I showed this in my 2019 SWFox session. > >>> > >>> I was working with a 64-bit C# and accessing a VFP 9 SP 2 COM compiled > as > >> an > >>> EXE. > >>> Fun stuff. > >> What's the benefit to that? > >> > >> > > -- > This email has been checked for viruses by Avast antivirus software. > https://www.avast.com/antivirus > > [excessive quoting removed by server] _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/CAJidMY+G6Z8LRSfZZ_T2VQjwRgMB_J2dSRCdOWbHVetJc=o...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
