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-bounces@leafe.com] On Behalf Of MB Software Solutions, LLC Sent: Tuesday, April 21, 2020 3:47 PM To: profoxtech@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-bounces@leafe.com] On Behalf Of MB Software Solutions, LLC Sent: Tuesday, April 21, 2020 11:11 AM To: profoxtech@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-bounces@leafe.com] On Behalf Of MB Software Solutions, LLC Sent: Tuesday, April 21, 2020 10:53 AM To: profoxtech@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?