On 7/31/06, Michael Babcock <[EMAIL PROTECTED]> wrote:
The discussion last week made me wonder where people stood on using VFP
as the "middle tier" that it's been called best for in the past. If you
have a non-VFP object using VFP as the middle tier, you can only get
back single values and not a cursor (unless you're going to create an
XML document to be consumed by the non-VFP caller), right? If you could
get a cursor from VFP into the non-VFP caller, that'd be great, but I
think VFP cursors are only akin to VFP, right?
How best would you use VFP as the middle tier?
You could use a cursor internally and create methods to navigate
(GoTop(), MoveNext(), EOF() etc). The object would probably need
expose a property for each field in the results.
I played with this some time ago. I had a VB6 program using recordset
like methods and a VFP program directly accessing the cursor. Both
were taking to the same VFP activex object. I doubt I still have the
code.
--
Paul
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
** 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.
