>>>>thanks again Mark - these had been a big help...After I am connected to an
>>>>Oracle database, can I treat this connections like another database in visual foxpro and will my coding and the way I handle REMOTE VIEWS be he same? Inotherwords, can I treat Oracle as I would treat a Visual Foxpro DBF?...rob
>>>
>>>
>>>Remote views do not behave nor can they be treated like VFP tables. They are definitely typical remote views so you handle them just like any other remote view. You can create forms for data entry, delete rows, etc. You can manually program data retrievals, editing, deletion using VFP SQL functions [e.g., SQLConnect(), SQLExec(), SQLDisconnect, etc.]
>>>
>>>You can not do things like Modify Structure, but you can use SQLExec to ALTER the table structure. Because you can not modify the structure you can not RELIABLY create and maintain structural indexes. I have created indexes on views but gave up on it because I had problems with DBC corruption closing then trying to reopen the database. It works OK but only if you delete the index before you close the view and the DB. This is not practical for multi-user applications and still risky for any application.
>>>
>>>You can not create a relation when one or both of the tables is a remote view. You would have to create a new local or remote view that "join" the two tables based on the relation you need. You could also create a query that will do this "on-the-fly" as well. A view is basically a query anyway.
>>>
>>>HTH :-(
>>
>>thanks again Mark.. what does :-( mean?
>
>Tilt your head 90 degrees left. It is a "frowney-face with a nose" because you can not treat remote views like regular VFP tables. :) (smiley-face w\out nose)

OK - I see it... thanks