Database Introduction

See FoxPro Worksheet1

Creating a database and common problems related

When you create a database, remember to CREATE TABLE, NOT DATABASE!

This is very important. And note that in this summary will sometimes use word ‘database’, for now, just think that ‘Table’ and ‘Database’ are the same.

Also remember that Fieldname cannot be longer than 10 letters, no spaces or any special characters.

Common problem: Open the database, but cannot view the record.
Solution: To view the record, goto menu View | Browse…

Common problem: Don’t know how to add the record, or cannot add the record.
Solution: Type Append blank in the command window to add new record

Common problem: Don’t know how to delete the record
Solution: Mark the record of the very first small blank field, then close the windows and type Pack command in the command windows. (Must open the database as exclusive, below is how to do it)

Common problem: Open the database, but cannot change the table structure
Solution: May be you need to open your database as exclusive, Type use [filename] exclusive in the command windows. (See Database Programming with FoxPro: Open & Close database section for more info)