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 -