Instructions for Visual DbEditor++ V2.10.

(C) 2003, Jeremy Suiter + Others, All Rights Reserved.


Key use:

F2 - Duplicates current record

F3 - Deletes current record

F4 - Restores last deleted record (current browse session only)

F6 - Sets scope or filter

F8 - Freezes left hand column(s)

F9 - Un-freezes left hand column(s)

ALT-A	- Appends data to table

ALT-C	- Copies data to new table

ALT-D	- Delete records (bulk)

ALT-E	- Set database relations

ALT-G	- Goto record

ALT-K	- Pack table

ALT-L	- Locate record(s)

ALT-M	- Math functions (count/sum/average)

ALT-R	- Replace data (bulk)

ALT-S	- Seek record

ALT-U	- Un-delete (recall) records (bulk)

ALT-Z	- Zap table

CTRL-C	- Copies value into buffer

CTRL-X	- Cuts value into buffer

CTRL-V	- Pastes value into field


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


What's New

18/04/2003 V2.01 Michael McVicker (MMM comments).

Will now run from any directory.  Double clicking of file will open it.  Browse will now update while dragging scroll tab.

18/04/2003 V2.02 James Loughner.

Added ALT-I to insert record.

22/04/2003 V2.02 Jeremy Suiter.

Added support for SET CHARSET and SET COLLATION to .ini file instead of default (OEM) and ASCII.  Added ability to stop same file being opened twice.  Added date format to .ini file.  Added RUSHMORE, SMARTFILTER and OPTIMIZE settings to .ini file.  Added file overwrite checking.  Added correct display of EOF instead of record number for empty table

22/04/2003 V2.03 James Loughner.

Added support to compile using version prior to 1.82.  Added ability to compile so DbEditor acts like a function instead of standalone. See notes on compiling.

23/04/2003 V2.04 Jeremy Suiter.

Added maths functions count, sum and average.

24/04/2003 V2.05 Jeremy Suiter.

Cell edit moves to next field in record on ENTER key being pressed.

ESC now closes popup windows.

Added menu for hotkey items

25/04/2003 V2.06 Jeremy Suiter.

Fixed bug with structure edit (field name length problem)

Fixed bug when creating compound indexes for new file

Added readonly as option when opening a table

Added export option 'Export All'.  Does a DbGoTop() before exporting.  Default set via EXPORT_ALL in .ini file, set TRUE/FALSE.

27/04/2003 V2.06 Jim Loughner.

If compiled with /dDBEDFUNCTION and running in a thread the DBFS were not closed when return  to calling function so I added line 167 this modual to close all. Note this may cause problems if the dbeditor function is not called in it own thread.

30/04/2003 V2.07 Jeremy Suiter.

Added highlight border to input fields.  Turn ON/OFF via HILITE_GETS in DEFAULTS section of .ini file.

02/05/2003 V2.08 Jeremy Suiter

Removed #define for compiling with earlier versions and replaced with XPPVER instead for automatic compiling.

Fixed error with compiling using previous versions where DosErrorMessage function doesn't exist.

Modified utilities menu with sub menus.

06/05/2003 V2.08 Chris van Reeven

Added ability to supply alias when opening files

07/05/2003 V2.10 Jeremy Suiter

Added data dictionary.


Compiling
Visual DbEditor++ Compiling Instructions

Visual DbEditor++ was written using the latest version of Xbase++.  It can be compiled to run with earlier versions as well as a function that you can link into your own applications.

Compiling with earlier versions.

The application will automatically compile with earlier versions.

Compiling as a function

Visual DbEditor++ can be compiled as part of your own program.  It can also be called as a standalone function.

To do so compile all modules with -DBEDFUNCTION.  Then call function from it's own thread.

LOCAL oThread:=Thread():New()

...............

oThread:Start("DBeditor",DATAPATH,oOwner,defaultDBE)