|
Home > Archive > FoxPro database connector > April 2005 > How does a SQL command find a table which is not in the current db
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
How does a SQL command find a table which is not in the current db
|
|
|
| It seems to me that if I issue a SQL statement such as select * from tableX
and tableX is not in the current dbc, the SQL statement will search for
tableX based on the path of the current dbc. So, if the current dbc is
located in c:\vfp\test, the SQL statement will search for tableX in
c:\vfp\test. If tableX is in c:\vfp\test, the SQL statement will return a
resultset. If it is not, it will ask for a directory.
Thanks.
| |
| Stefan Wuebbe 2005-04-07, 8:05 pm |
|
"Peter" <Peter@discussions.microsoft.com> schrieb im Newsbeitrag
news:52DA1B97-7838-4A2B-A60D- 0F01A67B28C9@microso
ft.com...
> It seems to me that if I issue a SQL statement such as select * from tableX
> and tableX is not in the current dbc, the SQL statement will search for
> tableX based on the path of the current dbc. So, if the current dbc is
> located in c:\vfp\test, the SQL statement will search for tableX in
> c:\vfp\test. If tableX is in c:\vfp\test, the SQL statement will return a
> resultset. If it is not, it will ask for a directory.
That's true. The traditional free-tables way is to Set Path To x,y,z
With DBCs you can work w/o Set Path if you want, except in a
mixed scenario with DBCs and free tables at the same time, e.g.
Set Path To (cFreeTablesFolder) Additive
Set Path To (cDbcFolder) Additive
Open Database myDbc.dbc Shared
Use freeTable.dbf In 0 Shared
Does that help?
-Stefan
--
|\_/| ------ ProLib - programmers liberty -----------------
(.. ) Our MVPs and MCPs make the Fox run....
- / See us at www.prolib.de or www.AFPages.de
-----------------------------------------------------------
|
|
|
|
|