< nknabe.dk

PdxEditor Update History

Most recent updates at top of list.

• 2025-03-05, vers. 5.6.0.625:
  Parsed extracted SQL sub statements from scripts trimmed from leading/trailing white space to give better overview on line position feed back in case of SQL syntax execution errors.
• 2024-08-04, vers. 5.6.0.623:
  Added runtime selectable toggle of MemoText display in DBGrid as well as toggle for display of the chosen MemoText prefix marker.
• 2024-08-02, vers. 5.6.0.621:
  Max. data length table analysis added max. length of Memo and FmtMemo text length (for RTF text: length including RTF-codes).
• 2024-08-01, vers. 5.6.0.620:
  Added Left, Center and Right alignment settings in the FormattedMemo editor as well for the RTF-mode of the Memo editor.
• 2024-06-15, vers. 5.6.0.618:
  Fixed stability issues on reloading SQL statements/scripts by changing all SQL tabs from RichEdit to Memo components.
  With this build, all the SQL tabs are of the high capacity type.
  2024-06-06, vers. 5.5.0.616:
  SQLtabs WordWrap scrollbars ssNone -> ssVertical.
  Bugfix (SQL1..SQL5 tab pre-process preview).
  Bugfix: SQL pre-process complex comment markings unresolved non-paired trailing start comment (/*) marker.
• 2024-06-04, vers. 5.5.0.612:
  Distinctinct high capacity SQL6 tab for more than 400 SQL lines.
  Improved dialogs concerning high volume SQL scripts.
  Text search added to all the SQL statement tabs.
• 2024-05-24, vers. 5.5.0.605:
  Added preview option of comment clean up pre-processed SQL.
• 2024-05-23, vers. 5.5.0.603:
  Multi line and mixed commenting pre-processing tweeked to comply with e.g. MySQL and SQLite comments processing, including support for inline comments (single line comments starting within the line of code).
  
• 2024-04-01, vers. 5.4.0.600:
  All SQL dialog statements tabs (SQL1 to SQL6) have been script enabled.
  Improved Find functionality (SQL6).
  Selectable SQL font Courier New or Lucida Console.
• 2024-01-02, vers. 5.3.0.596:
  Added text export option for Boolean/Logicals as Integers: 1/0/blanks as alternative to the existing TRUE/FALSE/blanks.
  Bugfix in Excel export module handling Boolean NULLs in first record fields.
• 2023-12-04, vers. 5.2.0.592:
  Added program launch error detections related to BDE settings and Windows 11.
  Optionally saving and reusing column widths.
• 2023-11-30, vers. 5.1.0.585:
  Changing table language driver by list selection dialog.
• 2023-11-25, vers. 5.1.0.582:
  Extended auto close time interval range.
• 2023-11-24, vers. 5.1.0.581:
  Added auto close progress bar dialog letting you interrupt the auto close down process.
• 2023-11-01, vers. 5.1.0.579:
  Added user selectable overwrite of pre-existing table name with delimited text import.
• 2023-09-14, vers. 5.1.0.577:
  Minor design tweaks.
• 2023-08-28, vers. 5.1.0.576:
  Generating associated descriptive Schema file with CSV/text export may be deselected from the Export menu.
• 2023-08-07, vers. 5.1.0.575:
  • Added user selectable option to accept SQL '-- single line comments', which may be used together with the BDE standard syntax /* delimited comments */.
  • Added Text Search within SQL Script.
  • Added "NOW()" as alternative SQL substitute for autoconverted CURRENT_TIMESTAMP.
  Correction to erroneous error response on semicolon(s) inside SQL single statements.
• 2023-04-16, vers. 5.0.0.565:
  Minor improvement to Memo popup window behaviour.
• 2023-03-18, vers. 5.0.0.562:
  • Added SQL script enabled feature processing mixed standard DDL/DML SQL scripts (SQL command batches).
  Processes scripts of up to more than 80.000.000 characters (though time consuming ... :-).
  Filtering out properly enclosed comments /* comment01; comment02 */ from SQL scripts, and error detecting SQL scripts for comment delimiters in various non-proper sequences (as e.g. '*/.../*',  '/*.../*...*/'  or  '/*...*/...*/', etc.)..

  Version 5

• 2023-03-14, vers. 4.2.0.551:
  Autoproportioned images in graphics window.
• 2023-03-01, vers. 4.2.0.550:
  • Added optional on-the-fly auto-conversion of various SQL-incompatible formatting characters when executing the SQL statement without altering the visible or stored SQL statement. Conversion optionally includes hard-spaces (#0160), en-dash (#0150), left and right "curly" single ‘quotes’ (#0145/#0146) as well as left and right "curly" „double” “quotes” (#0132/#0147/#0148).
• 2023-02-15, vers. 4.1.0.549:
  CURRENT_DATE and CURRENT_TIMESTAMP altered to universally substituting with the US date/US datetime format, as the BDE engine does not comply with some regional date and datetime formats.
• 2023-01-14, vers. 4.1.0.548:
  Added import from CDS MyBase files (*.cds or *.xml).
• 2023-01-07, vers. 4.0.0.541:
  Some surplus feed back dialogs deleted from the CDS export.
• 2022-11-29, vers. 4.0.0.540:
  Slightly enhanced Bytes input dialog.
• 2022-07-18, vers. 4.0.0.539:
  CDS export: Bytes field auto converted to String field, if Bytes field longer than 16 bytes (as CDS Bytes fields invariably translates to 16 bytes).
• 2022-07-15, vers. 4.0.0.538:
  Paradox input masks (Picture(s)) added to Validity Checks view.
  Fix of the retrograde typecast of Paradox data type Time in "Generate SQL CREATE from current table".
• 2022-07-12, vers. 4.0.0.535:
  New features
  Direct menu acces to:
    • rename current table incl. associated files,
    • copy a table incl. associated files to local database directory from local or distant table location,
    • delete a table incl. associated files,
    • view basic table properties,
    • view table field's Validity Checks,
    • added field restructure method including to set/lift Required field attribute,
    • adding/clearing Paradox Primary Index,
  • Bytes and VarBytes data from CSV source both imported with Delimited Text Import as Bytes(size) data.
  • SQL CREATE table structure description added reporting required fields,
  • SQL Editor now with five active executable auto stored SQL-tabs,
  • Adjusted more distinct color for alternating row shading,
  and a number of minor polishings of the application.

  Version 4

• 2022-06-08, vers. 3.77.0.476:
  Save Table to Paradox or dBase files reflecting current columns order also if reordered by manual columns dragging (previously columns order was reset before exports).
• 2022-06-08, vers. 3.76.0.473:
  Bugfix to properly handle columns references rearranged by DBGrid manual column dragging concerning Field Types info, Text Export schema profile and retrograde SQL CREATE generation.
• 2022-05-31, vers. 3.75.0.466:
  Included support for exporting Bytes to Excel, the Bytes exported as hexadecimals.
• 2022-05-30, vers. 3.75.0.465:
  Added Bytes field popup viewer for viewing stored Bytes arrays. Bytes are text exported as hexadecimals.
• 2022-05-25, vers. 3.74.0.463:
  Minor internal code maintenance - no changes in features or functionality.
• 2022-05-16, vers. 3.74.0.461:
  Export of RTF text from the datagrid popup dialog editor of either the Memo or FmtMemo type fields updated to not include trailing Null character.
  2022-05-15, vers. 3.74.0.460:
  Updated Delimited Text Export concerning 1) export of RTF-text (eliminating terminating Null characters), 2) export of binary field definitions (but not the binary data). Delimited Text Import added accept of defintion of binary fields, however still no data imported, but accessible for separate field level import/export. Exports eliminating the Null characters solves the problem with possible mid file Null characters related to exported RTF-data fields that on import inappropiately may be interpreted as preterm file termination.
  dBase: Updated context sensitive activation of generic BLOB dialog vs. Graphic dialog with dBase TypedBinary fields, as dBase does not offer distinct field types for graphics vs. other binaries (Binary Large OBjects: BLOB). The updated procedure will call the Graphic dialog if the cell is empty or detected holding a recognized image format, otherwise the generic BLOB field dialog is called - i.e. if non-graphic binary data or some unrecognized image format is detected in the cell. Forced calling the generic BLOB dialog by [Ctrl]-DoubleClick.
• 2022-05-12, vers. 3.73.0.454:
  Application About dialog added display of compatibility version of the current Windows system.
• 2022-05-11, vers. 3.73.0.453:
  Minor fix of user deselection of BOM inclusion when exporting text with UTF8 encoding.
• 2022-05-09, vers. 3.73.0.452:
  Delimited Text Export fixed to export substitution text <ParadoxOle>, <DBaseOle> or <TypedBinary> for data of the type indicated, as PdxEditor does not export binary data (previous versions did export this type of field data as text, which were not readily reimported from text source files). Graphics in dBase tables (dBase 5 & 7) may still be imported and exported via the DBGrid graphics popup dialog window storing graphics as TypedBinary used by dBase tables.
• 2021-07-08, vers. 3.72.0.451:
  Updated info on current Windows version as given i the About dialog. (API calls have been returning version 6.3 for Windows 10 in analogy with vers. 6.0, 6.1, etc. for Windows Vista, Windows 7, etc. - this has been addressed with new Windows 10 compliant API call).
• 2021-06-18, vers. 3.72.0.447:
  Bugfix: correcting column title/data allocation of ClientDataSet export, when column displays have been manually relocated in the DBGrid.
• 2021-06-15, vers. 3.72.0.446:
  ClientDataSet export preserving field type AutoInc, if table is empty (has no records).
• 2021-06-13, vers. 3.72.0.445:
  Added export to ClientDataSet (CDS) disc files as .cds or .xml files (aka MyBase).
• 2021-04-03, vers. 3.71.0.430:
  Minor fix to make alternating row shading fully compatible with pre-XP style Windows Classic theme concerning text color in focused cells.
• 2021-03-28, vers. 3.71.0.429:
  Added optional alternating row shading for better visual row to row distinction.
  Adjustable number of characters from Memo data fields displayed in the data grid specified via the INI-file. Accepted numbers 6 to 50, default 8.
• 2021-03-17, vers. 3.70.0.426:
  Updated embedded document icons supplying specific document/table file icons readily spotted in the Windows Explorer, sligthly diffenrent and easily distinguishable from the application icon.
  
• 2021-03-14, vers. 3.70.0.425:
  Optional display of Boolean/Logical fields as Check Boxes. Check Boxes can be toggled on and off.
  Check Boxes displays NULL values as grayed boxes, and check boxes may receive NULL values as well by selectable option.
  vs.
• 2021-03-05, vers. 3.61.0.409:
  SQL dialog tables list size saved via Windows Registry.
• 2021-03-02, vers. 3.61.0.407:
  SQL form added resizing splitter between tables and fields list.
• 2021-03-01, vers. 3.60.0.405:
  Fixed initial suggested file extension when doing text exports.
• 2021-02-19, vers. 3.60.0.404:
  Improved Delimited Text Import error detection on source files with field data not compatible with selected field data type mapping or on source files with incorrect record structure - e.g. with incorrect use of solitary quotes inside fields.
  Dialog displays text data source line and field triggering the import error.
  http://nknabe.dk/database/pdxeditor/help/index.html?import-error-detection.html
• 2020-09-27, vers. 3.59.0.401:
  Added registering/unregistering of file association of Paradox and/or dBase files to PdxEditor of current location. Interface for this may be subject to updates.
  File association is valid for Current User only irrespective of possible Windows Admin logon.
• 2020-08-05, vers. 3.58.0.398:
  Added import, export and optional display of milli Seconds (mS) for Time (Paradox), TimeStamp (Paradox) and DateTime (dBase 7) fields.
• 2020-08-03:
  Updated application manual: Differentiated date range capacity for Pdx 3.5-5 vs. Pdx 7 tables. dBase field type name TimeStamp > DateTime.
  Added dBase specification link.
• 2020-06-04:
  Updated application manual concerning BDE language drivers.
• 2020-05-24, vers. 3.57.0.395:
  Optional text conversion of characters &, < and > into HTML character codes changed into converting only the < and > characters (into &lt; and &gt; respectively).
• 2020-04-02, vers. 3.55.0.389:
  Delimited Text Import, correction of required Schema file header
  from required (missing text qualifier in front of FieldName):
  "DataType";"Size";FieldName"
  to required:
  "DataType";"Size";"FieldName"
• 2020-04-02, vers. 3.55.0.388:
  Fixed indicator of currently active decimal separator in Delimited Text Import window.
• 2020-03-31, vers. 3.54.0.387:
  Optional Byte Order Mark (BOM) when exporting UTF-8 character encoded text files.
  UTF-8 files without BOM may be needed when exporting targeting e.g. a MySQL database which is not import compliant with BOM-marked UTF-8 files.
• 2020-03-14, vers. 3.53.0.386:
  Help access F1 and Ctrl-F1 switched to Application Help called by F1 and Local SQL Manual called by Ctrl-F1.
  Main Form as well as SQL-related forms enabled for both help calls.
  
• 2019-10-29, vers. 3.51.0.384:
  Added optional trim of leading spaces in source fields when importing as Delimited Text Import.
  Fix of missing field sizes in exported schema files.
  Fix of inactive Query export.
• 2019-10-28, vers. 3.51.0.380:
  Some adjustments of the text export function:
  Conversion of " (double quote character) to " changed to conversion to "" (dual double quote character).
  Conversion of ' (single quote character) to '' (dual single quote character) abandoned, as the single quote character will not interfer with field demarcation as double quote is the text qualifier.
  Conversion of ampersand (&), lesser than (<) and greater than (>) made optional via the Export menu.
  Adjustment of the Delimited text data import function:
  Number of sample lines displayed in the Delimited text import window made user selectable via the INI-file settings.
  Added error handler procedure for Delimited text import: if source files contained errors with some rows having more fields than defined by the source file header, this could lock the recieving table from further access until application closure. The added error handler takes care of this and adds specific feed back on field and row numbers causing errors but without hindering further import of remaing records.
• 2019-10-25, vers. 3.50.0.377:
  Added DBGrid font option Verdana.
• 2019-10-24, vers. 3.50.0.376:
  Added info in Help-About dialog about sytem's current OEM CodePage of significance for display of extended ASCII characters i BDE tables.
  Extended information in the application help on various BDE/CodePage issues.
• 2019-10-22, vers. 3.50.0.375:
  Added DBGrid font Lucida Console.
  Available DBGrid font sizes extended to 8 - 10 - 12 - 14 point and fonts Tahoma, Arial, Courier New.
  Application HTML Help (.chm) added to the PdxEditor.zip file.
• 2019-10-10, vers. 3.50.0.370:
  Lots of improvements (information will be updated ...).
• 2019-09-07, vers. 3.10.0.322:
  Tripple active SQL tabs in SQL window.
• 2019-09-06, vers. 3.10.0.320:
  Dual active SQL tabs in SQL window.
  Auto conversion to datatype Integer of AutoIncrement fields when SQL querying tables.
  Added field display of datatypes for SQL queries (the SQL menu).
  
• 2019-09-02, vers. 3.10.0.316:
  BCD (Binary Coded Decimal) fields made fully accessible and editable as any other field. BCD fields will export to CSV/text and Excel as FLOAT.
  Application ported back from Delphi XE3 to Delphi XE solving the profound problems of Delphi XE3 compiled Paradox applications not reliably handling BCD data fields, the XE3 problem as investigated to be consistent across and independent of the Windows versions at both design time and run time.
  The PdxEditor application will thus for the future stay with the proven Delphi XE development environment.
  Background: A number of simple paradox reader/editors (all 32-bit) created from scratch and same source code compiled with Delphi 7, Delphi 2009, Delphi XE and Delphi XE3 on PCs with Windows XP-32-bit (Delphi 7 and Delphi 2009), Windows 7-32-bit (Delphi XE), Windows 7-64-bit (Delphi XE and XE3) and Windows 10-64-bit (Delphi XE and XE3) all narrowing the BCD-problem being linked to the Delphi XE3 IDE or it's 32-bit compiler.
  All the Delphi 7, Delphi 2009 and Delphi XE compilations of the Paradox app works seamlessly across various versions of Windows, 32- as well as 64-bit. Only the Delphi XE3 compilations fails handling BCD fields on whatever Windows platform and PC.
  Delphi versions after Delphi XE3 have not been tested (BDE-support has been included in the Delphi IDE untill Delphi XE6, presently still available as separate download for Delphi XE7 to 10.3). The Paradox BCD fields tests with Delphi 7 to XE and XE3.
  To prevent SQL creation of non valid Paradox BCD-fields a syntax check on DECIMAL(s[,p]) parameters have been added to the PdxEditor.
  
• 2019-08-29, vers. 3.9.0.303:
  Memo plain text displaying first 50 characters in datagrid cell (previously first 25 characters).
  Memo plain text line break characters (CRLF, CR or LF) ad hoc converted to spaces when displayed in datagrid cell.
  Excel export of RTF-coded Memo/FmtMemo text converted to plain text when exported to Excel.
  Line breaks in Memo/FmtMemo text optionally converted to literal '<br\> ' when exported to Excel, default = True.
  Excel export dialog: overwrite prompt added.
  User selections of [DBGrid Auto Edit], [Text Export: ISO Date ...] and [Excel Export: Transform Line Breaks ...] stored as per user (Windows Registry).
  2019-08-27, vers. 3.9.0.299:
  Third party Excel export module modified to also export Memo, FmtMemo and Currency.
  CSV/Text File Export: Non empty binary (BCD, Graphic, OLE, Binary, Bytes) source fields marked in exported text-file as '<Binary>'.
  Extended RTF-detection for Grid display and Memo auto detection of RTF-formatted content: Now not only detecting leading '{\rtf1' but also terminating '}' and auto compensation for possible erroneous leading or trailing line breaks or white spaces. Also auto detection for mismatching number of opening { and closing } braces in RTF source data.
  Bugfix: If querying a table including an AutoInc field and trying to save the query result as a new table this evoked a conversion error due to a common database feature not accepting transfer of data into an AutoInc field. With the present fix AutoInc data from the queried table by default will not be transferred as the AutoInc values will be autocreated in the new table starting from the value of 1 irrespective of the AutoInc values of the source table. If AutoInc values are intended transferred to the new table, the AutoInc field of the source table must be converted on the fly into a plain Integer field to enable the target field (Integer) to receive transfer of the AutoInc values as e.g.
  SELECT CAST(AutoIncField AS INTEGER) [, other fields] FROM TableName
  Bugfix: Text exporting Memo and FmtMemo fields previously only converting line breaks of the type #13#10. Now also converting line breaks of the types #13 (data generated by Macs prior til Mac OS X) and #10 (data generated by UNIX, Linux, current Macs).
  
• 2019-08-21, vers. 3.9.0.293:
  Fixed update of Status Bar when closing SQL.
• 2019-08-20, vers. 3.9.0.292:
  Added optional INI-item (in PdxEditor.ini) under the [LocalHelp] section:
  OmitHtmlFilePrefix =
  where the value 1 omits adding the "file:///" prefix to paths for locally stored WebHelp html files.
  This may solve problems loading local WebHelp on some older Windows versions (e.g. Windows XP) where the application's internal API communication in some instances may not accept the "file:///" prefix.
  Default value is 0.
• 2019-08-20, vers. 3.9.0.291:
  Added tolerance for local html paths without trailing backslash in the INI [LocalHelp], Location =.
• 2019-08-20, vers. 3.9.0.290:
  Modified INI-file.
  HTML Help introduced as an optional alternative to using WebHelp. User selection via the INI-file.
  HTML Help file (LocalSQL.chm) included in the distributed zip file (PdxEditor.zip).
• 2019-08-16, vers. 3.9.0.283:
  Introducing associated autogenerated INI-file (PdxEditor.ini) for user selectable choice of using WebHelp located either on web server or as previously stored locally.
• 2018-12-30, vers. 3.8.0.281:
  Bugfix concerning loading error of Midas.dll on certain computers. Midas.dll is used by the application for internal interim storage during text-import.
• 2018-12-11, vers. 3.7.0.279:
  Bugfix in Excel export to correctly export NULL values also for numeric fields.
• 2018-11-25, vers. 3.7.0.272:
  Delimited text import added selectable FormattedMEMO (FMTMEMO) provided the text source field contains at least leading
  "{\rtf1" - if not, the RTF source may be imported as standard MEMO text, which could later be converted into readily readable formated text (not tested for non-western coded RTF text).
• 2018-11-19, vers. 3.7.0.271:
  Added user selectable ISO format for date and datetime text export.
• 2018-11-15, vers. 3.7.0.268:
  Added CURRENT_DATE and CURRENT_TIMESTAMP selectable SQL variables.
  As the otherwise standard SQL CURRENT_DATE and CURRENT_TIMESTAMP functions are not handled by the Borland Database Engine (BDE), and thus usually neither by Paradox nor by dBase, these variables are runtime converted into Date or DateTime constants accepted by the BDE and thus enabling storage of standard SQL statements with dynamic date and datetime handling by the PdxEditor query feature.
• 2018-11-01, vers. 3.7.0.265:
  Delimited text import explicitly informing acceptance of logical 'True'/'False', '1'/'0', blank, 'NULL' in the text source file. Blank source fields as well as literal 'NULL' are both imported as NULL values. Import from source fields is case independent.
• 2018-10-22, vers. 3.7.0.257:
  Redesigned database selection in the Database menu to:
  [Use Local Database (Directory Relative to Application Directory)]
  [Select Database by Alternate Directory]
  [Pre-select Non-Alias Database by Directory ...]
  [Use Current Directory as Local Database]
  The Alternate Directory is the most recently used user selected directory distinct from the application's own directory.
• 2018-09-07, vers. 3.4.0.204: Not distributed.
  First preliminary delimited text import.
  Added Excel export (Excel 2.1 format to ensure independency of MS Excel or MS Office modules).
• 2018-07-11, vers. 3.2.0.197:
  First published version.
  Minor fix of dBase optional conversion of numerical float fields into backwards compatible BCD format.
• 2018-06-22, vers. 3.1.0.165: Not distributed.
  Help system changed from WinHelp to html based WebHelp.

  Version 3

• 2010-04-11, vers. 1.0.0.01: Not distributed.
  First functional PdxEditor for Paradox table viewing and editing.