General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
New information since my last post to you
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only