Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Changing Data Table Location of a View
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Changing Data Table Location of a View
Miscellaneous
Thread ID:
00147871
Message ID:
00147871
Views:
54
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.
Next
Reply
Map
View

Click here to load this message in the networking platform