Your English is great, what are you talking about? :) Wish I could speak French as well as you speak English.

Anyway, I have created applications using VFP and both SQL Server and Oracle. I gave up on remote views a long time ago--but that is a personal preference. I found them to be very slow and also ran into the problem you are talking about as far as the maintenance.

But, as far as I can tell there is no way to return a cursor to VFP from Oracle using a stored procedure...that irks me to no end. You can return cursors using SQL PASSTHROUGH though. Usually I set up my data on Oracle and then use SQL PASSTHROUGH to either call stored procedures or to execute code that will return the result set I am looking for.

So, there are many ways to handle your problem. And creating the remote view on the fly will avoid problems but how will your INIT method know the layout of your Oracle table? Just curious.

Hope this helps some,
George

---

>Hi,
>
> I will develop an application using Foxpro 5.0 for the GUI and Oracle 8i Lite for the database. I know that I have to use a VFP database to contain the connection and the remote view that access the Oracle 8i Lite database. Is there are someone who have done this before? Do you have something to say about the way I will do this? Is ther any good framework who can work with remote view?
>
>The thing that I don't like with the way I will do the application is that I will have to modify two databases when I have to modify a table in Oracle 8i Lite. I had an idea but I don't know if it is a good one : If I create the remote view when the form is loading (Load event) I will never have to modify te remote view cause there will be create each time and will exacly like the table in Oracle 8i Lite.
>
>Sorry for my poor english because I speak french...
>
>Thank you ... Merci!!! :-)