Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Changing Data Table Location of a View
Message
From
18/10/1998 01:54:26
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00147871
Message ID:
00147906
Views:
27
>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?

AFAIK, you cannot do this using the same view. You probably want to create a second view pointing at the second set of data...

but perhaps I could use a little more background on why you are trying to do this...
Erik Moore
Clientelligence
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform