Default Settings for Visual DbEditor++

There are various default settings that you can set. These setings are held in the DbEditor.ini file. There is one section for the program's default settings and then you can add specific DBE settings by creating a section for that DBE.

Program defaults

The program will accept a list of filenames passed as the first parameter to the filename seperated by a comma. All files listed are opened using the default settings from DbEditor.ini.

eg. c:\visual dbeditor\dbeditor c:\data\temp.dbf,c:\data\temp1.dbf

Nearly all of these settings can be set via the File/Options menu item. The settings are saved to the defaults section in the .ini file. The following settings can be set via the Options menu item:-

DBE | Default database engine
Table extension | Table extension used when opening database tables
Extension description | Description of default table extension
Data directory | Data directory to be used when opening files
Show deleted records | Switch on/off ability to show deleted records
Multi user | Switch on/off multi user (exclusive on/off)

There are others that can be set, but via the .ini file only.

Rushmore | Rushmore filter optimizer
Optimize | Expression optimizer
Smartfilter | Smart filtering
Date Format | Application date format
Collation table | Default collation table
Character Set | Default character set
Uppercase | Force listed fields to uppercase entry
Export All | Does a go top before exporting
Hilight Gets | Hilights selected entry field

DBE Settings

Specific DBE settings can be set in the .ini file. Each DBE must have it's own section heading with the settings listed below. See the example below to see how to set components of the FOXCDX DBE.

Example of a .ini file

[DEFAULTS]
DBE=FOXCDX
COLLAT=ASCII
CHARSET=OEM
RUSHMORE=ON
SMARTFILTER=ON
OPTIMIZE=ON
DATE_FORMAT="dd/mm/yyyy"
TABLE_EXT=DBF
EXT_DESC=DBF Files
DATA_DIR=C:\visual dbeditor\data\
SHOW_DELETED=Off
MULTI_USER=True
UPPER_CASE=CCODE,PCODE
EXPORT_ALL=FALSE
HILITE_GETS=OFF

[FOXCDX]
SETTING1=COMPONENT_DATA,FOXDBE_CREATE_2X,.T.
SETTING2=COMPONENT_DATA,FOXDBE_LOCKMODE,FOXDBE_LOCKMODE_2X
SETTING3=COMPONENT_DATA,FOXDBE_MEMOBLOCKSIZE,64
SETTING4=COMPONENT_ORDER,CDXDBE_COMIX,.T.
SETTING5=COMPONENT_ORDER, DBE_LOCKMODE,LOCKING_EXTENDED