Thank you for your interest in JasonQuery Software.
Thank you for all your feedback and best wishes!
2021/02/17, version 0.54
New:
1. Options Form - "Copy Settings..."
--You can copy all settings from specified connection name
Enhancement:
1. Connection Form - Connection List
--Add new column - Tab Back Color
2. Check for updates: The minimum unit is changed from "hour" to "day"
2021/02/04, version 0.53
New:
1. Main Form
--Report Bugs: Open the "reportbugs.html" with your default browser
Enhancement:
1. Main Form - Release Notes
--Convert the format from TEXT to HTML
--Open the "releasenotes.html" with your default browser
2021/02/01, version 0.52
New:
1. Main Form - Right-click menu of TabControl
--Add "New SQL Editor" item
Enhancement:
1. Export all data to Excel
--Automatically detect whether Excel is in the cell editing mode, and if so, show prompt message.
2. Export all data to CSV - The progress form
--Disable form resizing
--Disable the ESC key to prevent the form from being closed. (The form can only be closed via the cancel button)
3. Updater.exe
--Support multiple languages - Call from JasonQuery
2021/01/25, version 0.51
New:
1. Support "one-click update" to update the program
--[Help] > [Check for updates], click [Update Now] button
--Manually run Updater.exe
2021/01/11, version 0.50
New:
1. Query Editor Form
--Support for variables in SQL statements
2020/12/30, version 0.49
Bug Fix:
1. Query Editor Form
--Copy as Query Condition: For numeric types, single quotes are not required before and after
Enhancement:
1. Query Editor Form
--Export All data to Excel: Save the exported file path and name in the drop-down list
2020/12/21, version 0.48
Bug Fix:
1. Query Editor Form
--for PostgreSQL: Fix the bug of incorrect positioning when there is an error in the executed SQL statement
2. Fix the bug of "Disconnect automatically"
2020/12/14, 0.47
Bug Fix:
1. Check for Updates Form
--Stop using "1MB.co" to detect new version, because it no longer provides free service.
2. Query Editor Form
--Minor bug fixes for "Indent", "Unindent", "Comment", "Uncomment"
--Data Grid: After pressing the Ctrl+End key, then scroll the mouse wheel, it will become zoom in or zoom out
--Query Editor's quick search bar: FindNext / FindPrevious, can't search for "CX" in "CCXX"
Enhancement:
1. Query Editor Form
--Data Grid: After triggering "Next Page", always focus to Data Grid
2. Options Form
--SQL to Code: Add description of Style 1~3
3. Check for Updates Form
--Add two button: Show description of "How to update manually" and "Open the path of JasonQuery"
2020/12/09, version 0.46
Enhancement:
1. Connection Form
--Change the database icons downloaded from icons8.com
Bug Fix:
1. Query Editor Form
--Data Grid's quick search bar: search function
2020/12/07, version 0.45
Enhancement:
1. QueryEditor Form
--Make the "Find and Replace" panel movable
Bug Fix:
1. SQL History Form
--Minor bug fixes for search function
2020/12/03, version 0.44
Bug Fix:
1. Query Editor Form
--Paging Query: If "Paging Query" is disabled, "PageDown/Key Down" will not trigger "Next Page" automatically
2. for PostgreSQL
--fix "This PgSqlTransaction has completed; it is no longer usable." error
2020/12/01, version 0.43
Bug Fix:
1. QueryEditor Form
--Minor bug fixes for "UPPER Case" and "lower Case"
2020/11/30, version 0.42
New:
1. Connection Form
--Enable Pooling: Connection pooling enables JasonQuery to use a connection from a pool of connections that do not need to be reestablished for each use.
--Once a connection has been created and placed in a pool, JasonQuery can reuse that connection without performing the complete connection process.
Bug Fix:
1. Minor bug fixes for "Disconnect automatically"
2020/11/25, version 0.41
New:
1. Options Form
--Data Grid: "Set Focus to Data Grid after Execute Query Statement" (disabled by default)
Enhancement:
1. SQL History Form
--Minor bug fixes and improvements.
2. Update the help content of "Raw Data Mode" button
2020/11/19, version 0.40
New:
1. Support SQL Server (SchemaBrowser is not yet complete!)
2. Query Editor Form
--Support "Paging Query" function (Oracle/PostgreSQL/SQL Server)
--Preset to query 500 records each time
--User can triggering "Next Page" to append next 500 records
--Press "Next Page" button (at the bottom right corner of the screen)
--Press "PageDown" or "Key Down" (Press the key in the last row)
--Scroll to the bottom of the Data Grid
--User can enable/disable "Paging Query" function temporarily (the checkbox is at the bottom right corner of the screen)
3. Options - Data Grid
--User can enable/disable "Paging Query" function
--User can change the number of queries each time (100/500/1000/2000/5000)
Updated Component:
1. Devart.Data.dll - 5.0.2551
2. Devart.Data.Oracle.dll - 9.13.1127
3. Devart.Data.PostgreSql.dll - 7.19.1759
New Component:
1. Devart.Data.SqlServer.dll - 3.0.397
2020/11/09, version 0.39
Enhancement:
1. Query Editor Form
--Ehnance "Cancel" button
2020/11/03, version 0.38
Enhancement:
1. Query Editor Form
--Code to SQL - for C#. When the keywords at the beginning of the following are detected, the whole line will be regarded as a null value.
--if, else
2020/10/30, version 0.37
Bug Fix:
1. Query Editor Form
--Fix "Save" function when save "SQL History" to JasonQuery.db
2020/10/29, version 0.36
Enhancement:
1. Query Editor Form
--Expand the file size allowed to open to avoid "out of memory" errors
--JasonQuery x86: The recommended file size is less than 50MB.
--JasonQuery x64: The recommended file size is less than 300MB.
2020/10/12, version 0.35
Bug Fix:
1. Export all data to Excel:
--fix Worksheet Name issue
--fix Back Color issue
Enhancement:
1. When executing non-query batch SQL statements, write SQL History from 1 to multiple to avoid no response when querying SQL History.
2. Update the help content of "Raw Data Mode" button
2020/10/05, version 0.34
Bug Fix:
1. Export all data to Excel:
--If the data type is numeric (such as int, number, etc.), it should be displayed as numeric in Excel
New:
1. Export all data to Excel:
--Users can define or save the exported settings
(such as filename, save as type, worksheet name, color of grid, etc.)
2020/09/29, version 0.33
Bug Fix:
1. Query Editor Form
--Press the "Commit" or "Rollback" buttons: The execution method is changed from "SQL command" to "function" due to bug issue
Enhancement:
1. Options Form
--Data Grid: add "Raw Data Mode" option, user can decide whether to use "Raw Data Mode" or not
2020/09/28, version 0.32
Bug Fix:
1. Query Editor Form
--Press "Commit" or "Rollback" button, save "commit;" or "rollback;" into SQL History
Enhancement:
1. for PostgreSQL, for "Data Type" Identification, add new "Data Type" below
--boolean, smallint, bigint, real, double precision, int32[], text[]
2020/09/26, version 0.31
Bug Fix:
1. Query Editor Form
--If the SQL statement has specified variables (for example :name), locate the error message in :name
Enhancement:
1. Connection Form
--Necessary fields, presented with light yellow background
--Rewrite: Each Data Source uses its own independent object
2020/09/17, version 0.30
Enhancement:
1. Query Editor Form
--Press the "Commit" or "Rollback" buttons
--The execution method is changed from "function" to "SQL command"
--For example, press the "Commit" button, execute the "commit;" command directly
--For example, press the "Rollback" button,execute the "rollback;" command directly
--Auto Replace
--According to the definition of Replacement, automatically adjust column height (display up to 3 columns)
2020/09/14, version 0.29
New:
1. Query Ediotr Form
--Save As: add shortcut F12
2. In windows other than the "Query Editor", you can press "Ctrl+N New SQL Editor" or "Ctrl+O Open File".
Enhancement:
1. Execute "commit;" or "rollback;" separately, and hide the prompt message "Not yet committed or rollbacked!".
2. For PostgreSQL, if the "Enable Auto Rollback" is not checked after the connection, the "Rollback button" will be automatically enabled when SQL statement is executed.
3. If execution command has not finish, the user presses the "commit" or "rollback" button at this time, it will be automatically ignored to avoid unnecessary error.
2020/09/09, version 0.28
New:
1. Query Editor Form
-- Add "Raw Data Mode"
--If it's enabled, it can speed up data display greatly.
--Press "?" button, Show detail message
Enhancement:
1. "Disconnect automatically"： Add "Never" item; the initial default value is changed to "Never"
Bug Fix:
1. Query Editor Form
--Data Grid's search function
--for PostgreSQL: Fix prompted positioning shift error
2. Connection Form
--Fix "Copy" button
2020/09/03, version 0.27
New:
1. Options Form
--Data Grid: add "Preview CLOB Data" (it's disable by default)
2. Query Editor Form
-- Add "Options" button
--User can switch quickly fro "Result Copy Quoting With", "Result Copy Field Separator", "Preview CLOB Data"
Enhancement:
1. Query Result: When "Preview CLOB Data" is disabled
--for Oracle, BLOB Filed，Show "(BLOB)"
--for Oracle, CLOB/NCLOB Field，Show "(CLOB)"