Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
New information since my last post to you
Message
From
29/05/2002 18:53:18
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
New information since my last post to you
Miscellaneous
Thread ID:
00662789
Message ID:
00662789
Views:
41
Hi Ken

I have more information since I posted my previous message to you. I believe I understand the situation now, and I don't think I require any additional help.

However, in case you are interested, or in case you feel you can add something additional that would be helpful, Here is what I have since discovered:



1) The only reason I didn't get the dialog box described below, when opening the view, was because I had a set path statement in effect for the path to where the free table was. Without the path statement, 'use v_ordrfile', always prompts me for the base table.

2) In reviewing other threads here, it appears that sourcename, when applied to a view, gives the ALIAS of the view, not the path

3) When looking at the dbc directly, for the record for the view, I can't find anywhere that vfp stores the path to the base table. I am inclined to believe that it doesn't, at all, and that therefore, the only way I can get this to work is to have a set path statement in place, which is not ideal, but I guess it will have to do.

If you can shed any further light on this it would be appreciated.
Reply
Map
View

Click here to load this message in the networking platform