dbf table exist in database  vfp9

Posted on 2012-09-20
Last Modified: 2012-09-25
Hi Experts

I have a table name customer.dbf  and a database name cmark.dbc

I would like know if table customer.dbf exist in database cmark.dbc

Please help
Question by:b001
    LVL 27

    Accepted Solution

    LVL 27

    Expert Comment

    LVL 29

    Expert Comment

    by:Olaf Doschke
    Two remarks:

    1. I can't believe INDBC() isn't even mentioned in tek-tips thread. Also Berezniker just mentions it and then goes on with code not needing to open the DBC. Ok, but why would you need to be able to determine the DBF backlink to a DBC, without opening the DBC? Because it's open exxclusive elsewhere? Then you won't be able to open the DBF in many cases, too. It's really a very theoretical solution.

    2. If you want to know this for the purpose of backing up only the files needed for a database, I'd not decide that technically by the membership of a dbf in a dbc or not. Developers keep things belonging to each other logically in a folder, even if they are not bound to each other "physically". You can have several free DBFs in a DBC folder that don't technically belong to the DBC, but still have data in them important to the DBC, for example SDT creates a free table or two with meta data about the DBC, for the purposes of repairing tables, recreating indexes etc.

    Bye, Olaf.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Microsoft Visual FoxPro (short VFP) is a programming language with it’s own IDE and database, ranking somewhat between Access and VB.NET + SQL Server (Express). Product Description: (http://msd…
    In this post we will learn how to connect and configure Android Device (Smartphone etc.) with Android Studio. After that we will run a simple Hello World Program.
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
    This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

    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

    15 Experts available now in Live!

    Get 1:1 Help Now