Make your own free website on Tripod.com

HOW to USE the dBASE BROWSE COMMAND


The dBASE BROWSE command is a very powerful data entry and modification tool. It allows you to display up to display up to 17 records of the related file you are working on and as many fields as will fit on the screen. BROWSE gives you the ability to go up and down the data file and make any changes that are required.

A typical screen will look like this:

Records   Organize   Fields   Go To   Exit                           9:00:00 pm
+------------------------------------------------------------------------------+
¦DATE    ¦NAME                     ¦REFERENCE¦AMOUNT      ¦GL     ¦SOURCE      ¦
¦--------+-------------------------+---------+------------+-------+------------¦
¦09/30/91¦Depreciation Automobile  ¦JE 1     ¦     -100.00¦176    ¦JE          ¦
¦09/30/91¦Depreciation Equipment   ¦JE 1     ¦      -50.00¦177    ¦JE          ¦
¦09/30/91¦Depreciation Expense     ¦JE 1     ¦      150.00¦687    ¦JE          ¦
¦        ¦                         ¦         ¦            ¦       ¦            ¦
¦        ¦                         ¦         ¦            ¦       ¦            ¦
+------------------------------------------------------------------------------+
Browse  ¦C:\sa4\TRAN             ¦Rec 1/3          ¦File ¦        ¦   Num 

Press <F2> to toggle back and forth between the BROWSE and EDIT modes. EDIT allow you to isolate and look at one record, the highlighted fields may be changed. Some of the fields may have been set to the VIEW mode (read only), the rest are in an UPDATE mode (read and/or change).

The first line on the screen shows the Pull-down menu items and the date.

Pull-down menu may be accessed by pressing <F10> while browsing the file.

The Pull-down items can also be accessed by holding down the <Alt> key and
pressing the FIRST letter of the Pull-down menu.

The second line on the screen shows the field names that are on the file. If some of the fields are not shown on the screen see the <HOME> and <END> keys below.

Each other line on the screen under the heading represents a record in the file. Care should be taken when using the Browse command, as the characters are dynamically changed in the file (if in the UPDATE mode).

If you have an older IBM type keyboard (not the 101 Key Enhanced Keyboard), where the direction keys are on the numeric key pad, it is suggested that you leave the "NUM LOCK" key off and enter numbers from the top row of keys and use the numeric key pad to move the direction keys.

The following are the Pull-down Menus:
 Records
+----------------------------------+
¦   Undo change to record          ¦
¦----------------------------------¦
¦   Add new records                ¦
¦   Mark record for deletion       ¦
¦   Blank record                   ¦
¦   Record lock                    ¦
¦   Follow record to new position  ¦
+----------------------------------+
 
 Organize  
+--------------------------------+
¦  Create new index             ¦
¦  Modify existing index        ¦
¦   Order records by index       ¦
¦   Activate .NDX index file     ¦
¦   Include .NDX index file      ¦
¦   Remove unwanted index tag    ¦
¦--------------------------------¦
¦   Sort database on field list  ¦
¦   Unmark all records           ¦
¦   Erase marked records         ¦
+--------------------------------+ 
 
 Fields
+------------------------------------+
¦   Lock fields on left  {1}         ¦
¦   Blank field                      ¦
¦   Freeze field         {}          ¦
¦   Size field                       ¦
+------------------------------------+
 
 Go To   Exit
+-----------------------------------+
¦   Top record                      ¦
¦   Last record                     ¦
¦   Record number         {1}       ¦
¦   Skip                  {10}      ¦
¦-----------------------------------¦
¦   Index key search                ¦
¦   Forward search        {}        ¦
¦   Backward search       {}        ¦
¦   Match capitalization  YES       ¦
+-----------------------------------+
 
 Exit
+-----------------------------+
¦   Exit                      ¦
+-----------------------------+

Browse navigate instructions:

<Ctrl>+ --> (right arrow)  Beginning of the next word. 
<Ctrl>+ <-- (left arrow)  Beginning of the previous word. 
<Ctrl>+<Home Will open a memo field 
<Ctrl>+<Pg Dn

or <Alt>+<T>+<L> 

Last record of the file. 
<Ctrl>+<Pg Up

or <Alt>+<T>+<T> 

First record of the file. 
<F2 Toggle between Browse/Edit 
<F3

or <Shift>+<Tab> 

Move to previous field (will open a memo field) 
<F4

or <Enter> or <Tab> 

Move to next field (will open a memo field)U 
<Shift>+<F5

or <Alt>+<G>+<I> 

Index key search 
<Shift>+<F8 DITTO: Copies the data for the field you are in from the previous record. 
<Shift>+<F9 QUICK REPORT: Print a report using default settings 
<F10 Access to Pull Down Menus 
Up Arrow 

or <Ctrl>+<K> 

Move cursor to previous row (in Browse); or previous field (in Edit). 
Down Arrow 

or <Ctrl>+<J> 

Move cursor to next row (in Browse); or next field (in Edit) 

 This command is useful if you had a series of records to delete. By holding the 'Ctrl' key down and alernately pressing 'U' and 'J', the record will be marked for deletion and the cursor will move down to the next record 

Backspace  Delete previous character 
--> (right arrow) 

or <Ctrl>+<L> 

(UPDATE) will move the cursor one character to the right. If the cursor is at the last position of the last field, the cursor will move to the first field of the next record. 

 (VIEW) will move the cursor one FIELD to the right. 

<-- (left arrow) 

or <Ctrl>+<H> 

(UPDATE) will move the cursor one character to the left.. If the cursor is in the first position of the field, then it will move to the end of the previous field. If the cursor is at the first position of the first field, the cursor will move to the first field of the previous record. 

 (VIEW) will move the cursor one field to the left. 

<Ins

or <Ctrl>+<V> 

Toggle between Insert/Typeover. This will set the character INSERT to ON or OFF. when <Ins> is pressed you will see 'INS' appear at the bottom right of the screen. Now when you type any characters,they will be inserted at the position of the cursor.To turn the Insert OFF, just press <Ins> again and the 'INS' will disappear.. 
<Del

or <Ctrl>+<G> 

will delete the character at the position of the cursor. Move the cursor to the character you wish to delete, press <Del> key. 
<Pg Up

or <Ctrl>+<R> 

will move the cursor to the previous screen. This will show the previous 16 records. If you are at the top of the file, nothing will happen. 
<Pg Dn

or <Ctrl>+<C> 

will move the cursor to the next screen. The next 16 records in the file will be shown on the screen.If you are at the bottom of the file,the last record will show at the top of the screen. 
<Ctrl>+<U to mark a record for deletion.When the cursor is on the line of the record you have marked for deletion,'DEL' will appear on the bottom right of the screen. The record is not physically deleted from the file until the file is 'PACKED'. You can undelete the record by placing the cursor on the line of the deleted record and holding the <Ctrl> key down and press <U> again, you will note that the 'DEL' disappears. In some of the Browse screens we have turned of the deletion feature in order to protect the integity of the data. 
<Ctrl>+<T will delete the DATA within field from the cursor position to the beginning of the next word of the field. Move the cursor to the field you wish to delete the data from and holding the <Ctrl> key down and press <T>. 
<Ctrl>+<Y will delete the DATA within field from the cursor position to the end of the field. Move the cursor to the field you wish to delete the data from and holding the <Ctrl> key down and press <Y>. 
<End

or <Ctrl>+<B> 

will move the screen to display the LAST field of the record. (if not all the fields in the record are displayed on the screen) Press <End> and you will now see the last field to the right, but you now will not be able to see the left field(s). 
<Home

or <Ctrl>+<Z> 

will move the screen to display the FIRST field of the record. (if not all the fields in the record are displayed on the screen) Press <Home> and you will now see the first field to the left, but you now will not be able to see the right field(s). 
<Ctrl>+<End

or <Ctrl>+<W> 

to exit the BROWSE screen and save the last change you have made. 
<Esc to exit the BROWSE screen and NOT save the last change made. If you wish to Undo a change but stay in the Browse command press <Alt>+<R>+<U>. 

[Home]  [Top]  [Overview]  [Operations]  [Appendix]