Glad to help. Basically SQL PASSTHROUGH is a way to send commands/queries directly to the SQL server you are using (Oracle here). You can also call stored procedures this way.
It looks like you are on the right track with the remote views though. And I'd be happy to collect that beer someday < grin >
Good luck,
George
>I thank you for your answer I will take a look at this. I don't know how to use the SQL PASSTHROUGH but I will look on
www.google.com I saw a lot of things about it. To answer your question that you ask me about how INIT method of my form know the layout of my Oracle table is because I will use a very simple query like :
>
>CREATE SQL VIEW xView REMOTE CONNECTION ConnectionName AS SELECT * FROM xTable
>
>and after this I will use this command to use the update feature of the remote view
>
>DBSETPROP("xView","View","SendUpdates",.T.)
>
>I think that if I use a SELECT * it will see all the changes that was made on the table each time that the form is starting.
>
>Thank you again for your help.
>
>And if you come at Montreal in Quebec (Canada) I will pay you a beer!!!
>
>Bye bye
Everything we see or seems
Is but a dream within a dream - Edgar Allen Poe