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 defaultsThe 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 |
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