Fixed bugs and new features
version 6.0.01 Jan 2024
- PMF can now be built against Qt5 as well as Qt6
- A LOT of work for Postgres
- Changed "Login" window
- Added "Find DBs" menu for PGSQL
- Small fixes for DB2 and SQLServer
version 5.1.31 Nov 2023
- NEW: Keep column widths on table refresh
- NEW: GENERATED ALWAYS columns can be reset on import
- NEW: Reclaim unused space (Table->Table properties->Reorganize)
- REORG uses latest API now
- FIX: crash on select bookmark
version 5.1.28 Nov 2022
- SQL Server: FIX: Wrap column names in auto-created SQL
version 5.1.26 May 2022
- Handle CLOBs over 32kB
- SQL Server: Handle data type "IMAGE"
- Fixed error messages on DB2 import
- Fixed LOB/XML export when constraints where present
version 5.1.25 June 2020
- Fixed some issues on "restore previous session"
- Redesigned bookmarks in SQL Editor
- Fixed Copy/Paste from txt files
- Fixed XMLXPath / Attributes pop-ups
version 5.1.24 November 2019
- Fixed wrong DLLs packed in 32bit version
- GUIDs (CHAR FOR BIT) are converted between SqlServer and DB2 in the
"right-click->Filter" field
- Bookmarks now also in SQL Editor
- Passwords now stored encrypted (automatic conversion from older
settings)
- DDL now in "Menu->Table properties"
- Fixed error in connection settings
version 5.1.23 April 2019
- Set and Reset Font for GUI
- Catalog and uncatalog nodes and databases
- Delete: This is now by done by cursor to prevent ovwerflowing
transaction logs
- Exporting LOBs refined: Keep size below 4GB
- Snapshot/Monitoring DB2 (Menu->Administration->Snapshot): Fixed
quite a few errors
- Export snapshot data to flat file and XML
- Hit F7 to create "Select * from [current table]"
- Fixed "Char For Bit" on Windows
- Disable ALT key in right-click "Filter"
- ...and as always fixed small bugs
version 5.1.22 November 2018
- New: Delete table contents, using a cursor to avoid overflow of
transaction log
- Fix: Searching in HEX Cols did not always work
- New: Database name displays in Window-title
- New: Key ALT is disabled "Right-click->Filter" field
- New: In "Menu->Query-DB", double-clicking a result will open the
table
version 5.1.21 June 2018
- Small changes to GUI: Import and Export are back again in the menu
- New DDL-Export in XML format
- New: Create DDLs (as plain text or XML) for all tables
- Fixed lots of smaller bugs
version 5.1.20 October 2017
- Small changes to GUI: Import and Export moved from menu to main
- Lots of work on DB2 LOAD: Check for HADR, LOGARCHMETH etc
- Improved Export/Import Options
- Smaller bugfixes on move columns and index filter
- Drop files on GUI and on the "SQL Editor" button
version 5.1.19 September 2017
- DB2: PMF now uses new APIs for Import and Load. These APIs were
introduced with DB2 v9. The old APIs would fail more often than not when
importing LOBs and XMLs from non-local storage.
- Fixed crash when rows with LOBs were copied&pasted
- Fixed weird refresh behaviour in Listviews
- Decode PNG and JPG lobs that are base64 encoded on the fly
- Fixed extended Sqleditor: Failed when column names included
"BEGIN"
- New: tabs now closable via button, icons for "close tab"
- New: LOAD menu (DB2 only)
- Fix: After moving columns in the view, sorting was disabled
- Fix: Creation of UNIQUE constraints sometimes referenced wrong columns
- Fixed crash when empty tab was selected before new tab was created
- New: edit doubl-byte in editor
- New: Create foreign key assistant (DB2 and SqlServer)
- Fix: Reading foreign keys ignored multiple
columned keys (SqlServer)
- New: Rename columns
- New: Index sub menu extended
- New: Create index menu extended
- Fix: "Refresh tabs on focus" now ignores DELETE
- New: In extended Sql editor: Comment/uncomment with CTRL-M
- New: DROP VIEW (DB2 and SqlServer)
- Fix: Update checker would loop too often
- New: Search and find in double-byte edit
- New: Format option in extended Sql editor
version 5.1.18 May 2017
- DB2: Exports can be split in multiple files. Useful when the exporting
LOBs over 4GB in total (Menu->Table->Export->Options->Tab
"LOB options", field "filecount")
- Internal: Identity colums are determined by name, not index. Fixes
some misbehavior
- Fixed crash when "Show XML" window was open and table data was changed
- Tabs in main view can be refreshed on focus-in event:
Menu->Settings->Refresh Tabs on focus
- DB2: Import data, override warnings
- Copy&Paste rows via CTRL+C/CTRL+V and STRG+INS/SHIFT+INS, also
faster pasting
- DB2(ODBC): Handles binary CHARs
- DB2(ODBC) on Linux: Link against db2, not unixodbc: Fixes XML/LOB
issues
- Show CR/LF in cells as multi-line cell
- Ext SQL: Default statement separator can be changed
- Ext SQL: Try to guess statement separator
- Open new tab (CTRL+N) to the right of current tab
- Edit CLOB data: use ANSI on Windows, UTF8 on Linux
- Paste Rows from clipboard: Use local8bit
- Show XML: Display XPath and XMLSQL on right-clicking a start tag
- New entry when right-clicking a cell: "Edit cell data" for raw
editing.
- FIX: Stupid key handler implementation removed
- Text completion can be disabled for "SQL cmd" field
- Fixed handling of xml over 32k
- DB2(ODBC): Fixed handling of DOUBLE/DECIMAL
- DB2: Upload LOB when no index is present
version 5.1.17 January 2017
- New for DB2: CLOBs are now editable directly (right-click a CLOB to
edit)
- New for DB2 (native API): Extensive options for exporting/importing
DEL and IXF data
- Fix for DB2 (native API): Updating large XMLs (over 32k) was broken
- Fix for DB2/DB2-ODBC: BLOBs, CLOBs and double/decimal types were
partially broken
- New: On desktops with dark color schemes (e.g. Linux MX16) PMF will
default to the system's scheme
- New for DB2: Handle DBCLOBs (edit directly from PMF)
- All: Copy&Pasting rows is much faster
- All: Paranthesis highlighting in editor
- Fix for DB2: Inserting/Updating multiple LOBs in the same row works
now
- And multiple smaller fixes
version 5.1.16 October 2016
- INSERT was partially broken when default columns were present
- It's now possible to paste rows from DB2/DEL files
- Added semicolons in DDLs and removed apostrophies
- Improved behavior of "SQL Cmd" entry field
- DB2/ODBC plugin: On some platforms reading CLOBs was broken
- DB2/ODBC plugin: Fixed reading of default values for columns
- Plugin for SqlServer: Auto-detect TDS version on Linux
- DB2: Fixed generating PrimaryKey statement in DDL
- ExtSQL and XML-Editor now accept dragging and dropping files
version 5.1.15 August 2016
- Major change: Select multiple cells and right-click to update all
selected cell values.
- Numerical cell data is now right-justified
- Icon to add new tabs
- Fixed "Query DB"
- Fixed GRAPHIC/VARGRAPHIC for DB2
- Table in Export-menu is now pre-selected whenever possible
- Downloader for updates
version 5.1.14 July 2016
- This is more of a maintenance release. A few very minor bugs are fixed
- Fixed crash on "Check for updates" dialog
- XMLs may now contain apostrophies
- It's now possible to build the DB2 plugins seperately
- Fixes to enable compilation with the latest gcc compiler (e.g. on
Manjaro 16)
version 5.1.13 May 2016
- SqlServer: Fixed truncated database names (apparently names are cut
off at the first hyphen)
- Added a little color
- Added support for LONGVARBINARY
- Improved reading GRAPH and VARGRAPH types
- Major change: UPDATE and DELETE will now use UNIQUE constraints (INDEX
or KEY) instead of full row selects when the table has a UNIQUE
constraint
- Fixed crash on export "As Text" for Sql Server
- Fixed timer events on exports and imports
- Preselect schema in menus
- Added BIGINT for Sql Server
- Fixed reading UNIQUE column information for Sql Server
- Fixed crash on CHAR/VARCHAR
- Fixed GetDDL vor DB2/ODBC
- CHAR now recognized as fixed type
- Added USE context in helper routines for Sql Server
version 5.1.11 November 2015
- New plugin: DB2 via ODBC.
- New "Filter" in right-click menu, column-based search made easy
- New "Update" in right-click menu
- Fixed left/right-arrow key handling and some lesser bugs
version 5.1.10 October 2015
- Improved text completion (again)
- An empty row makes inserting new rows easier
- Added "Open LOB with..." and "load LOB from file" as context-menu
- Context-menu for LOBs/XMLs... are now enabled or disabled depending on
column type
- DB2: Table names and column names are now wrapped in quotes for
case-sensitive environments
version 5.1.09 August 2015
- Added a little color: Cell color will change on blanks at beginning or
end of strings, or upon double apostrophies
- DB2: BIND message path now on [user]/temppath, so binding in Win
should work without Admin-rights
- New option in Menu/Settings: Enter/Return will call SAVE which in turn
COMMITs pending changes
- Fixed crash when empty user-actions were called
- Improved text completion
- Column names and table names are now always wrapped in quotes, so
upper/lower case issues should go away.
version 5.1.08 July 2015
- New feature: Scriptable right-click actions; right-click a cell to
create and run scripted SQL statements
- New feature: BLOBs that are compressed with gzip are unpacked on the
fly
- MIME type of LOBs is used to start the corresponding application
(editor for text, viewer for images etc. )
- "Single row" in the menu implemented for Sql Server
- FIX: DB2: PRIMARY KEYs can now be dropped
- UPDATEs on tables with LONG datatypes: PMF will now check for
PRIMARY/UNIQUE keys to determine the best way to run UPDATEs
- XMLs over 32k can now be edited/saved
- New feature: The stored command history can be filtered by table
- And as ever, lots of smaller fixes
(Versions 5.10.06 and 5.1.07 were never published)
version 5.1.05 April 2015
- Added support for GRAPHIC type (VARGRAPHIC, ...) This is a double-byte
(DBCS) char string, and it's kind of obsolete
- Fixed very bad bug when updating rows that contain LONG or TRUNCATED
data
- Context menu: SELECT DISTINCT is now ordered
- Fixed crash on IXF/DEL export
- Fix: SQL_FLOAT (DB2) was not initialised
- Checking for new versions can be disabled
version 5.1.04 March 2015
- First public release of PMF5. Nothing to fix yet. Feels strange.