Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
West Wind Web Connectivity
Message
General information
Forum:
Visual FoxPro
Category:
Third party products
Miscellaneous
Thread ID:
00364380
Message ID:
00369434
Views:
38
>Your code, no. The design, maybe. You have returned 200 COM objects to a client process, each with a property for each field...

You are right, I agree, it doesn't work for what it was intended.
On my defense :), I was misguided with the speed in VFP without fully testing the solution as a COM server. I did some little testing initially, exclusively to check if VB was able to 'see' the returning object, at that time a simple single record one...another lesson and counting...

>
>ADO 2.x has the ability to persist a recordset to disk in the form of an "ADO compliant" XML document. Another, empty, recordset can then use that document to recreate the recordset. I wouldn't bring this up except that Rick's wwXML object has a methods that will convert a VFP cursor to a ADO compliant XML document, which an ADO can use later to build a complete recorset from. Getting your cursor into ADO this way turns out to be significantly faster than VFPCOM's CursorToRS method, and definitely faster than Ken Levy's conversion routine. I would check it out, I think you will find testing this method to be a worthwhile direction to take.

Your advise is the best one I have received up to now, I'm somewhat familiar with everything you told me but at theorethical level only, time to begin testing.
On the bright side, there are 2 methods in my class that need to be deleted/abandoned/put on hold: DO2DBF and DBF2DO; replacing them with Rick's xml methods will be not difficult, I think. I has been looking his shareware code and reading his documents for almost 4 weeks and boy, I had learned a lot.

Again, thank you very much Erik, I'll tell you about this soon.

Agustin.

...Y soy feliz, bien feliz, asi lo grito;
Mira, que el mundo sepa, que se sepa:
Soy feliz....                       

...And I'm happy, quite happy, so do I yell it;
Look, so the world knows it, so be known:
I'm happy...
 

Ismael Rivera "Oye cosita linda"
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform