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:[email protected]] On Behalf Of MB Software Solutions, LLC Sent: Tuesday, April 21, 2020 3:47 PM To: [email protected] 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:[email protected]] On Behalf Of MB > Software Solutions, LLC > Sent: Tuesday, April 21, 2020 11:11 AM > To: [email protected] > 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:[email protected]] On Behalf Of MB >> Software Solutions, LLC >> Sent: Tuesday, April 21, 2020 10:53 AM >> To: [email protected] >> 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: [email protected] 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/[email protected] ** 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.
