I am using a view in a form: v_test
The view is a local view in a dbc called: test
The table is called test.dbf and is in a folder called c:\test\01
So the SQL for the view is:
SELECT * FROM test!test
I want to be able to use the same view against the same table located in folder c:\test\02. In other words, multiple sets of data.
The cursorsource of the DE is v_test.
How do I change the table location in the DBC to be:
c:\test\02 instead of c:\test\01
Any ideas?
Richard DeZeeuw
DeZeeuw Software Inc.