>You're right. The COM component and the EXE cannot see the same cursors. Options are ADO, XML, or a string. I prefer XML as it is easy to move between XML and a cursor.

Good. Now speculation: If a system was built with VFP cursors in our "simulated" / not physically separate COM ntier approaches, they will be faster also?

Has anyone done any benchmarking of a query of differing complexities from SQL via COM and via VFP Cursors?


>
>>Hi all
>>
>>I remember some discussion of a COM "boundary layer". I'm looking for some confirmation.
>>
>>If a VFP app accesses SQL Server and the VFP app uses a middle tier that is not compiled as a DLL, that app can access the cursors directly.
>>
>>However with COM, the data would have to be passed from the COM object to the VFP app, probably with XML or something else. Don't tell me this is a negligible performance hit, just confirm that it exists, please.
>>
>>Thanks