OK! I can create table objects (recordsets,dynasets) in the middle tier using either Oracle's OLE remote automation server or by using DAO(v3.5) and then pass them back to VFP50. However, with Oracle's objects, is seems that I can only create dynasets, which, when passed to the client, is still bound to the ORACLE back-end. This is causing any changes in client to automatically by-pass the middle tier and go straight to the back-end. My experiments with DAO, seem to be doing the same thing.

Do I really need to create procedures that will parse the data in the object out into a cursor (which would have to be built on the fly). Let the user edit the cursor, and then update the record/dynaset using the "edit" method of the objects. This still would by-pass the middle tier on the write-backs. This by-pass seems to defeat the purpose of 3-tier I would think.

Do I really need to do the messy job of sending comma-delimited strings back and forth between the middle tier and client like I hear that some people are doing? I HOPE NOT. I can't believe this is a problem in VB as well. If it is not, maybe I'll be switching platforms soon.

You'll have to excuse me. I have never done any client server before in my life and my superiors came to me yesterday afternoon at 3:00 and wanted a complete low-down on converting existing VFP file-server applications to C/S by tomorrow morning at 9:30. That is why I am stressing a little!