Hello,
I need to create a view, which the user can edit. Therefore I plan to let the user edit two memo fields 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.
Christian Isberner
Software Consultant