DBF Viewer 2000
DBF Viewer 2000 Online Help
Introduction
Hotkeys
Command line options
Working with dbf files
Opening DBF files
Creating New DBF file
Modifying dbf file structure
Viewing statistics
Import/Append records
Save As/Export
Working with records
Adding records
Editing records
Deleting records
Replacing records
Filling records
Sorting records
Searching and Filtering
Searching by criteria
Filtering records
How To
Export DBF to CSV
Export DBF to XLS (Excel)
Export DBF to XML
Export DBF to SQL
Commands
File
Edit
View
Tools
Options
Information
Support
How to purchase
Top  Previous  Next

Filling records in DBF File


DOWNLOAD
for FREE

In DBF Viewer 2000, open the desired DBF file. Then, select Edit | Fill menu or use CTRL-L shortcut. This will bring up the following dialog:

Fill records in DBF File

Select the field you want to work with. Then choose the fill mode: Record number, Constant, Sequence from constant. Here is what they mean:

  • Record number – select this if you want to fill in the corresponding record number as the value of each record.
  • Constant – records of the field are set to this constant value.
  • Sequence from constant – this option works as the consequential counter starting from the specified constant value. The constant value is put into the first record of the range. Then the value is increased and put to the next record and so on. Specify the starting value in the box below.

By default DBF Viewer 2000 processes all of the records in the DBF file. If necessary, you can limit the range of records using the "Use records range" option. Enable the option and specify the first and last numbers of records. DBF Viewer 2000 will process only the specified record interval.

Filling records via Command Line

Filling records with constant

"c:\Program Files (x86)\DBF Viewer 2000\dbview.exe" mydatabase.dbf /FILL:SUM:100

Filling records by filter

"c:\Program Files (x86)\DBF Viewer 2000\dbview.exe" mydatabase.dbf /FILTER:myfilter.txt /FILL:SUM:100


DOWNLOAD
for FREE

Updated Wed, 15 Feb 2023
Back to DBF Viewer 2000 Home

Page top | Contacts |  Copyright © HiBase Group, 2002-2023