Knowledge Base

How to Verify If a Table Is Free or Belongs to a Database

Article ID: 136771

Article Last Modified on 2/15/2000

APPLIES TO

Microsoft Visual FoxPro 3.0 Standard Edition

This article was previously published under Q136771

SUMMARY

This article explains how to determine if a table (.dbf file) is a free table or belongs to a database.

MORE INFORMATION

Programmatic Test

Run the following code to determine if a table is free or belongs to a database:

     xyz = CURSORGETPROP("database")
     IF EMPTY(xyz)
        WAIT WINDOW "This is a free table!"
     ELSE
        WAIT WINDOW "This database " + xyz +" is open!"
     ENDIF

You can use a low-level utility or Visual FoxPro low-level functions to verify the content of the .dbf header.

REFERENCES

For more information about Visual FoxPro low-level functions, please see the following:

Visual FoxPro Help; search on: "Low-Level Functions"

For more information on the table header structure, type "HELP FILE STRUCTURES" in the Command window to display online Help consisting of a list of file types. Select Table File Structure (.dbc, .dbf, ..... ), and click the Display button. You will see the Table Header Record Structure.

Additional query words: VFoxWin on-line online

Keywords: KB136771