Hi Chris,

I would suggest that you post you question as a new thread.

>Thanks for the info.
>Now I plan to let the user edit two memo fileds in a table, one for the SQL remote view definition, and another for the connection.
>Then I can create the connection as a text file (COPY MEMO ...), and the view I can create using EXECSCRIPT().
>I know very well how to create local views, but I do not know about remote views.
>What I do not know is how the connection to the oracle database is being made, I could not find too much info in the VFP help. So I would appreciate to see an example how to create the connection in code and how the view uses this connection.
>
>Thanks for the input in advance.
>
>
>>The View Designer is not available in runtime. You'll have to roll your own.
>>
>>>Hello,
>>>
>>>Can I let the user use the viewdesigner in runtime? Are there any restrictions?
>>>I plan to let the user define a parameterized view, but I am not sure whether this is possible without having VFP on his machine installed.
>>>
>>>Thanks for your input in advance.