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.