• Request literature
• Software demo
• Hardware
• Software
• Complete Systems
• Supplies
• Technical information
• Updates & downloads
• Reseller info
• Helpful links
• Beta testing
• MicroBiz webBoard
• Support newsletter

Basic Use Of DBC.EXE

DBC.EXE is a compressed "Foxbase" database program. If you are using this utility, this documentation will have the basic commands to help you look into data files created from the MicroBiz program.

To install:

First make a directory called "FOX" on your hard drive.

You then copy the file DBC.EXE to the FOX directory and then change directories to FOX.

At your FOX directory you will type "DBC" to decompress this file.

After it is uncompressed, you will execute the program by typing "FOXPRUN DOT" . This will take you to the command line of the program.

Use one of the following commands to access the database

APPEND... adds information from one database to another

BROWSE... allows you to view the information contained in the database

COPY..... copies information from one database to another for a specified condition (ex.copy to temp for qty=10)

CREATE... allows the creation of a new database

(ex. create vehicle.dbf)

DELE..... removes information from a specified field

(ex. dele for recno()<100>3999)

DISPLAY.. displays the structures of fields to printer or

screen (ex. disp stru to print; disp all sku,qty>0)

INDEX.... sorts a database by a specified field(s) without

changing the record numbering (ex. index on location to temp)

LIST..... displays the structure, fields, or info to printer

or screen (ex. list problem, location,descript to print off)

MODI STRU. (modify structure) allows you to change or add

fields to a database (ex. use cust.dbf; modi stru)

PACK..... removes information marked for deletion from the

database

QUIT..... allows you to exit Foxbase (ex. quit)

REPLACE.. replaces all information in a field for a specified

condition (ex. repl all prg with "help")

SET...... used when the indices are already present to save

time (ex. product.ntx already avail. so, set index to sku)

can also be used to set up a file for printing (ex. set print

to /filename/)

SORT..... sorts a database by a specified field(s) and re-

numbers the records (ex. sort on inv_num to temp)

USE...... selects that database you would like to work with

(ex. use product.dbf)

NOTE: Most Dbase programs are KEY SENSITIVE. This means that you should be using upper case letters.

Have a question about point-of-sale hardware or MicroBiz software? Visit the MicroBiz WebBoard.

Click here to print this page