PdxEditor
for Paradox and dBase tables vs. Borland Database Desktop (DBD)*
Feature matrix
Feature |
Database Desktop |
PdxEditor v.3.75 |
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, Default value. |
| Insert fields | Yes |
No |
PdxEditor manages using SQL ALTER TABLE TableName ADD FieldSpecs; |
| Rearrange field order | Yes |
No |
PdxEditor manages using SQL. |
| 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 |
| Logicals/Booleans as Check Boxes | No |
Yes |
Check box display can be toggled on/off |
| Show Memo in DBGrid | No |
Yes |
Displays first 6 to 50 characters in grid. May be configured via INI-file. |
| 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 Graphics | No |
Yes |
BMP, PNG, JPEG, GIF, TIFF, ICO via popup window |
| Import/Export binary large objects (BLOBs) | No |
Yes |
Via in-DBGrid popup dialog. |
| View/Enter Bytes fields arrays | No |
Yes |
Via in-DBGrid popup dialog. |
| 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: UTF-8, Windows 1252, Unicode UTF-16 or default Windows. Optional Byte Order Mark (BOM) for UTF-8 file export. 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. |
| Export to ClientDataSet (CDS) MyBase disc files as either binary .cds or as .xml | No |
Yes |
|
| 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 HTML Help and local or web-located WebHelp on LocalSQL | No |
Yes |
Original WinHelp manual recompiled to HTML Help 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.