To use the command "Use".

Posted on 2006-06-07
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.

Question by:sami_hung
    LVL 40

    Accepted Solution

    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


    Richard Quadling.

    Author Comment

    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.

    LVL 40

    Expert Comment


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

    should be ...

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


    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    Purpose To explain how to place a textual stamp on a PDF document.  This is commonly referred to as an annotation, or possibly a watermark, but a watermark is generally different in that it is somewhat translucent.  Watermark’s may be text or graph…
    Whether you've completed a degree in computer sciences or you're a self-taught programmer, writing your first lines of code in the real world is always a challenge. Here are some of the most common pitfalls for new programmers.
    An introduction to basic programming syntax in Java by creating a simple program. Viewers can follow the tutorial as they create their first class in Java. Definitions and explanations about each element are given to help prepare viewers for future …
    Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …

    745 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

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now