PdxEditor

for Paradox and dBase tables vs. Borland Database Desktop (DBD)*

Feature matrix

Feature
Database Desktop
PdxEditor v.3.51.0.384
PdxEditor comment / circumvention
Works with Windows 10
No
Yes
Also with Win 10, rel. 1709, etc.
SQL centered
No
Yes
Most procedures as within scope of SQL
Handles Paradox 3.5, 4, 5, 7
Yes
Yes
 
Handles dBase III+, IV, 5
Yes
Yes
 
Read/Edit dBase 7 tables
No
Yes
 
Create/Modify dBase 7 tables
No
Yes
 
Dynamic Data Directory
No
Yes
Follows most recent table selection
In App PdxNetDir selection
No
Yes
Selectable run time
Set/Change Field Name Paradox
Yes
Yes
Paradox 3.5-4-5-7; dBase III+-IV-5
Set/Change Field Size Paradox
Yes
Yes
Paradox 3.5-4-5-7; dBase III+-IV-5
Set/Change Field Name dBase III+,IV,5
Yes
Yes
 
Set/Change Field Size dBase III+, IV, 5
Yes
Yes
 
Set/Change Field Name dBase 7
No
Yes
 
Set/Change Field Size dBase 7
No
Yes
 
Set/Change Field Type
Yes
No
PdxEditor manages via SQL CAST(field AS type) and Save as new table
Set/Change Field validity checks
Yes
No
Validity checks: Field required, Min. value, Max. value, Deafult value.
Referential integrity settings
Yes
No
 
Password settings
Yes
No
PdxEditor opens any Paradox and dBase table!
Set/Change Language Driver
Yes
Yes
 
Change Block Size of existing Paradox Table
No
No
Increase BDE Paradox Block Size, create equivalent table by SQL, copy data with INSERT INTO
Show Memo in DBGrid
No
Yes
Displays first 50 characters in grid
Edit Memo & FmtMemo
No
Yes
Popup window editor
Edit formatted RTF in standard Memo field
No
Yes
Can convert from/to RTF. Usefull for dBase tables.
View Graphics
No
Yes
BMP, PNG, JPEG, GIF, TIFF, ICO in popup window
Import/Export Grapics
No
Yes
BMP, PNG, JPEG, GIF, TIFF, ICO via popup window
CSV Text Import
No
Yes
Mappable Field Types/Sizes.
Boolean/Logical accepting 'True','False','1','0','NULL' and blanks. Spaces treated as blank.
Storable import schemas (profiles)
No
Yes
Stores/retrieves as CSV-formatted schema file.
CSV Text Export
No
Yes
Selectable comma, semicolon, tabs. Selectable encoding: Unicode, UTF-8, Windows 1252 or default Windows.
Autocreated schema file.
CSV Date/DateTime text export as ISO format irrespective of system settings
No
Yes
User selectable.
Excel Export
No
Yes
Basic Excel 2 format (MS Office/MS Excel not required). Memo/FmtMemo RTF-text converted to plain text with optional conversion of line breaks to literal '<br> ' tags.
Numeric and Date NULLs exports as blanks (i.e. NULL)
N/A
Yes
Both CSV text and Excel export
Execute SQL statements from app
Yes
Yes
PdxEditor with tripple tabbed SQL editor windows
Autosaving created SQL statements
No
Yes
PdxEditor saving statemensts as per user via Windows Registry
Save SQL result as Table
Yes
Yes
In format of current database driver: Paradox, dBase, FoxPro
In App SQL quick help
No
Yes
via popup menu selection of most SQL features
SQL handling dynamic date & time functions CURRENT_DATE and CURRENT_TIMESTAMP
No
Yes
via on the fly substitution** with date and datetime constants corresponding current system date and datetime as well as current datetime format
Reverse engineering SQL table definition
No
Yes
Generates a SQL CREATE TABLE statement using generic data types
Analysis af longest string data
No
Yes
Preprogrammed compound SQL feature
Associated WinHelp help
Yes
No
WinHelp is deprecated and will not work with Windows 10
Associated HTMLHelp and local or web-located WebHelp on LocalSQL
No
Yes
Original WinHelp manual recompiled to HTMLHelp and to browser based WebHelp. User selectable settings via INI-file for desired help system.

P.S.: In BDE terminology dBase III is actually dBase III+ equal to dBase III Plus. The preceding dBase III format is not compatible with dBase III+ and later.
* : The Borland Database Desktop 7.0 (DBD) as of 1996 - no newer existing version.
** : SQL statements as viewed in the SQL editor will stay unaltered keeping the CURRENT_DATE and CURRENT_TIMESTAMP variables.
Executed SQL statements as displayed using the [View SQL] function will display the current Date and DateTime constants converted from the CURRENT_DATE and CURRENT_TIMESTAMP variables.