Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Passing ARRAY from COM to VFP
Message
From
19/06/1999 12:22:01
 
 
To
18/06/1999 19:27:16
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00231657
Message ID:
00231769
Views:
11
>Circumstance:
>
>I have a VFP COM object on the server (via MTS). I have experimented with NUMEROUS methods of transfering a cursor result back from a server side COM object back to a client over a slow pipe (i.e., WAN, internet, etc.), including XML, ADO, FTP, HTTP, using my own solutions and solutions promoted by Rick S. and Ken L.. For the money, Fox object to Fox object, Cursor to Array through pipe to Array to Cursor seems to be the fastests, THOUGH I have one little hangup.
>
>I create a array property on the server object, perform the query on the server side database, convert the cursor definition in an array, and the results of the cursor in an array (taking into account the 64K limit for array elements).
>
>The client side object can now CREATE CURSOR FROM ARRAY serverobject.array and APPEND FROM ARRAY serverobject.array
>
>EXCEPT
>
>The client class doesn't recognize the properties as arrays. But it can traverse them as arrays ... so ... element by element I transfered them to local arrays and performed the above CREATE and APPEND. 95% of the proccessing time is in transferring the elements from the server array to the client local array.
>
>As klugy as this sounds, it was pretty fast for 9000 (2 element) records.
>
>Problem: Does any one know how to tell the client object that the property on the server is really an array so I can do the CREATE and APPEND directly from the server object?
>
>
>Thanks.
>
>- Tom Mc Crossin -

It will add some time to your routine, but will probably be faster than traversing the array yourself: Why don't you ACOPY the array to a local array, and then APPEND FROM that one?
Erik Moore
Clientelligence
Previous
Reply
Map
View

Click here to load this message in the networking platform