[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

To use the command "Use".

Posted on 2006-06-07
3
Medium Priority
?
292 Views
Last Modified: 2010-04-17
Hi All,

Here comes my second question 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.
0
Comment
Question by:sami_hung
  • 2
3 Comments
 
LVL 40

Accepted Solution

by:
Richard Quadling earned 50 total points
ID: 16850478
Hi sami_hung,


Does the same happen if you put the filenames extension in?

use '\\B\projfdr\data\b1.dbd'

Also try using double quotes instead of single quotes

" and not '

NOTE: that is NOT two single quotes ('')

" - Double quote (1 character) - try this
'' - 2 single quotes (2 characters) - don't try this


Regards,

Richard Quadling.
0
 

Author Comment

by:sami_hung
ID: 16858006
Hi Richard,

I had checked with using command window and
typed:       use \\B\projfdr\projname!b1 (where projname is the name of the project). It works and I'm sure b1.dbf in B computer is now open. But, after I put it inside my code and compiled, it doesn't work. b1.dbf in A computer (My computer) is opened, but not in B computer. Why?

But I'll try what you suggested and see if it works or not.

Sam.                    
0
 
LVL 40

Expert Comment

by:Richard Quadling
ID: 16859352
Oops.

use '\\B\projfdr\data\b1.dbd'

should be ...

use '\\B\projfdr\data\b1.dbf'

0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Make the most of your online learning experience.
Q&A with Course Creator, Mark Lassoff, on the importance of HTML5 in the career of a modern-day developer.
Introduction to Processes
Starting up a Project

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question