Actually, I don't think it'll work with a cursor, because a cursor cannot be closed and in order to encrypt the file it must be closed. You'd have to copy the file to a physical file that can be closed then encrypt unfortunately.

In most of those scenarios, it's better to use XML unless the data is very large. The overhead of XML is not critical in many cases if you don't pass a lot of records back and forth.

+++ Rick ---


>>I have VFP as a desktop client and also as a mid-tier DCOM object. The desktop client should do a createobjectex() and in the INIT method of the remote object, a DBC and remote view to Oracle gets created. How do I get that cursor/.dbf from the remote object to the desktop client DBC, flowing over the DCOM transport (the createobjectex() connection)? Since the cursor is binary (and I intend to encrypt/compress it also), I am having a hard time wrapping my head around how to move binary data back-n-forth quickly (I can pass strings OK) through DCOM.
>>
>
>
>EncodeDBF/DecodeDBF should work fine. You just have use DBF() to get the actual file of your cursor. YOu can't really use the updatable features of a view if you do it this way, so why use a view at all? I think that SPT is probably more appropriate here...