"Use" command.

Hi All,

For now I have another questions that might drive you all attention to it.
Well I now have two identical systems situated at different locations
(computer A and B where they both are connected through local LAN and their
project folder are shared). I'm in A and expecting to open a dbf file from B.
For example:
computer name: B
project folder: projfdr
dbf name: b1.dbf

My code is like as follows;
select 30
use '\\B\projfdr\data\b1'

It jumps an error message of "Invalid Path or...".
Please tell me what command I should use to open this dbf file. Thanks.

Sam.

Mark
Wed Jun 07 08:46:03 CDT 2006

Sam

well i think the reason you may be getting the error is that you havn't
specified .dbf on the filename.

i would also strongly suggest that you do not select 30 etc, but do 'use xx
in 0' instead as this is a better way of opening tables in foxpro. you then
need to refer to the table by doing a use xx rather than having to remember
which work area you opened it in!


"Sam Hung" <SamHung@discussions.microsoft.com> wrote in message
news:2B76BE5C-2042-4BA0-A414-A2635204AADA@microsoft.com...
> Hi All,
>
> For now I have another questions that might drive you all attention to it.
> Well I now have two identical systems situated at different locations
> (computer A and B where they both are connected through local LAN and
> their
> project folder are shared). I'm in A and expecting to open a dbf file from
> B.
> For example:
> computer name: B
> project folder: projfdr
> dbf name: b1.dbf
>
> My code is like as follows;
> select 30
> use '\\B\projfdr\data\b1'
>
> It jumps an error message of "Invalid Path or...".
> Please tell me what command I should use to open this dbf file. Thanks.
>
> Sam.

Dan
Wed Jun 07 09:58:41 CDT 2006

There is nothing wrong with your code as far as I can see. The ".dbf"
extension is implied and not required. I never add the extension to my USE
statements.

It appears you have a network problem that is causing the path to not be
available.

"Mark Burgum" <Markb@nospam.Anagram-sys.co.uk> wrote in message
news:eLcw7ijiGHA.4768@TK2MSFTNGP04.phx.gbl...
> Sam
>
> well i think the reason you may be getting the error is that you havn't
> specified .dbf on the filename.
>
> i would also strongly suggest that you do not select 30 etc, but do 'use
xx
> in 0' instead as this is a better way of opening tables in foxpro. you
then
> need to refer to the table by doing a use xx rather than having to
remember
> which work area you opened it in!
>
>
> "Sam Hung" <SamHung@discussions.microsoft.com> wrote in message
> news:2B76BE5C-2042-4BA0-A414-A2635204AADA@microsoft.com...
> > Hi All,
> >
> > For now I have another questions that might drive you all attention to
it.
> > Well I now have two identical systems situated at different locations
> > (computer A and B where they both are connected through local LAN and
> > their
> > project folder are shared). I'm in A and expecting to open a dbf file
from
> > B.
> > For example:
> > computer name: B
> > project folder: projfdr
> > dbf name: b1.dbf
> >
> > My code is like as follows;
> > select 30
> > use '\\B\projfdr\data\b1'
> >
> > It jumps an error message of "Invalid Path or...".
> > Please tell me what command I should use to open this dbf file. Thanks.
> >
> > Sam.
>
>

Dan
Wed Jun 07 11:08:37 CDT 2006

First, please STOP using workarea numbers. It's a recipe for bug-ridden
code.

The best way to do this is for each computer to map a drive letter to the
share on the other computer. If you cannot map a drive, then you know there
is a problem with the share on the other computer. It could be a setup
problem, a user rights problem, a system policy, etc. -- the best way to
find out is to map the drive letter.

Once you've got the drive letter mapped, your code is again simplified.

Dan

Sam Hung wrote:
> Hi All,
>
> For now I have another questions that might drive you all attention
> to it. Well I now have two identical systems situated at different
> locations (computer A and B where they both are connected through
> local LAN and their project folder are shared). I'm in A and
> expecting to open a dbf file from B. For example:
> computer name: B
> project folder: projfdr
> dbf name: b1.dbf
>
> My code is like as follows;
> select 30
> use '\\B\projfdr\data\b1'
>
> It jumps an error message of "Invalid Path or...".
> Please tell me what command I should use to open this dbf file.
> Thanks.
>
> Sam.

Gene
Thu Jun 08 14:19:38 CDT 2006

On Wed, 7 Jun 2006 02:30:02 -0700, Sam Hung
<SamHung@discussions.microsoft.com> wrote:

>For now I have another questions that might drive you all attention to it.
>Well I now have two identical systems situated at different locations
>(computer A and B where they both are connected through local LAN and their
>project folder are shared). I'm in A and expecting to open a dbf file from B.
>For example:
> computer name: B
> project folder: projfdr
> dbf name: b1.dbf
>
> My code is like as follows;
> select 30

Better to use
select 0
which will select an unused area.

> use '\\B\projfdr\data\b1'
>
>It jumps an error message of "Invalid Path or...".
>Please tell me what command I should use to open this dbf file. Thanks.

You need to have a volume/directory share. This can be set up
with Windows Explorer.

What is the name of the shared volume/directory? For example, if
the project folder is on B's C:, there should be a share for it. If
it is called "BsC" and projfdr is in the root, then you could use
use \\b\bsc\projfdr\data\b1

You can also map the share to a drive letter. If you map it to
Z:, then you could use
use z:\projfdr\data\b1

Filenames above may need to be quoted (if they contain any
spaces).

Sincerely,

Gene Wirchenko