PhraseExpress 歷史版本列表
更新時間：2019-04-10
更新細節：
What's new in this version:
Enhancements:
- Import Tool: Added an option for whether or not to fully qualify table names in generated insert statements for delimited, Excel, and fixed width imports
- Database Browser: Added support for View Contents - Limit Results for SQLite, HSQLDB, and H2
- Added an Edit -> Backup User Data menu option for backing up all user specific RazorSQL data such as preferences, connections, etc. to a zip file
- Query Results: Added a locale specific number formatting option on the Edit -> Preferences -> Query Results screen
Changes:
- Associate File: If file is already open on an unconnected and unmodified tab, connect that tab instead of creating a new tab
- Launch Edit Table Tool from query results: If the query is a select * query and all the results are retrieved, use the already retrieved results for editing instead of re-executing a new query
- Edit Table Tool: Max rows to retrieve per table now use the connection profile specific max rows setting instead of the global max rows setting from the preferences
- Edit Table Tool: Query to populate uses a limit clause for certain databases to prevent retrieval of extra rows and improve performance
Bug Fixes:
- Connection Wizard: If profile is deleted, copied, or renamed, profile tree does not update immediately
更新時間：2019-04-08
更新細節：
更新時間：2019-04-07
更新細節：
更新時間：2019-03-30
更新細節：
What's new in this version:
Enhancements:
- Connection Wizard: Added a tree view for existing connection profiles for faster selection
- Connection Wizard: Added the ability to categorize connections inside sub-folders
- Added a columnEncryptionSetting configurable property for the MS SQL Server JDBC driver
- DynamoDB: Added the ability to scan for values inside of Map columns. See https://razorsql.com/docs/dynamodb_sql_support.html for syntax details
- Connection Process: Added the ability to associate a file to a connection profile. Whenever the connection profile is connected, the file will load in the SQL editor
Changes:
- Salesforce: Updated API version to 45
- Execute procedure tool - if procedure returns a result set, results are now displayed in the query results tab of the main window
- Oracle: If DBMS Output is turned on, and query / statement does not return results but does return output, output is displayed in the query results section
- Added ability to call SQL Server / Sybase functions that return a table via the Call Procedure Tool
- Import Tool: Create Table from Import: If data values are decimal, will pre-populate decimal type with estimated precision and scale set on the create table window
Bug Fixes:
- MySQL and MariaDB: Column aliases not always appearing as column names in query results for queries that use aliases for the column names
- Initial screen size may be larger than current screen for multiple monitor machines having monitors with different resolutions
更新時間：2019-03-21
更新細節：
更新時間：2019-03-05
更新細節：
更新時間：2019-03-05
更新細節：
What's new in this version:
Enhancements
- DynamoDB: Added support for parallel scans with a comment hint syntax. For example, select /*parallel:5:100*/ * from table where id < 10000 5 is the number of parallel threads 100 is the max results returned per thread
- Salesforce: Describe Table Tool: Added a Reference Table column to the Columns tab
- Salesforce: Query Builder: Added the ability to add more than one table to select queries
- Query Results: Create Table from Results: Added option to create table from results on another connection of the same database type
Changes
- Edit Table Tool: Changed so that the table containing the table data always expands to the full size of the window and has a smaller minimum size
- Auto Reconnect: If database is disconnected, and auto reconnection process works, set the selected database on the connection to the database at the time the connectio was lost instead of the database set on the connection profile
- Salesforce: Added support for toLabel function in queries
- PostgreSQL: Changed display of int2, int4, and int8 columns to smallint, integer, and bigint
- The following files are now handled as zip files when opening: .odb, .odf, and .odt
更新時間：2019-02-17
更新細節：
What's new in this version:
- Spelling fix in original GUI text
- Minor code cleanup
更新時間：2019-02-08
更新細節：
What's new in this version:
Enhancements:
- Added a Recent Queries (All Connection) option to the SQL menu
- Added a Recent Queries (This Connection) option to the SQL menu
- Firebird: Added a DB Tools -> Create -> Create Database tool
- Firebird: Added the ability to create a new database when setting up a new Firebird connection
Changes:
- Added a preference to enable turning off storage of SQL history
更新時間：2019-01-30
更新細節：