Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Passing ARRAY from COM to VFP
Message
De
19/06/1999 12:22:01
 
 
À
18/06/1999 19:27:16
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00231657
Message ID:
00231769
Vues:
12
>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform