May 26th, 2012The main program updates ( Main ):
· Upd: update command line ( Command-line: ): Add the Start and Execute a Script the file, 2. Close Tab (-ct) or Application (ca) function
· DB type: Access = 0, Excel = 1, dBase = 2, FoxPro = 3, Firebird = 4, MySQL = 5, SQLServer = 6, SQLAzure = 7, SQLCe = 8, SQLite = 9, PostgreSQL = 10, Oracle = 11 the OleDB = 12, Odbc = 13, an OData = 14, the DB2 = 15, for Informix = 16, Sybase, = 17
· DB type (0 to 17)], the DB file / Profile name]
· database4.exe -?
· database4.exe "c: \ 1.mdb"
· database4.exe "c: \ 1.sdf"
· database4.exe 0 "c: \ 1.mdb"
· database4.exe 0 "c: \ 1.mdb" "c: \ 1.sql"-ca
· database4.exe 6 codelib
· database4.exe 6 codelib "c: \ 1.sql"-ct
· the Support for the AutoLogin (MySQL / SQL Server / SQL Azure / PostgreSQL / Oracle / IBM DB2/Informix/Sybase of ASE)
· Add: the TRIGGERS right menu increases caused by processing (Enable / Disable) (Oracle / PostgreSQL / Firebird / the SQL Server)
· Upd: (Firebird) FirebirdSql.Data.FirebirdClient.dll 2.7.7 update components ( ) (2012/05/25)
· Add: backward compatibility support for IBM DB2 9.5 database version
· Upd: Update file format support type *. mdb / the * .mde / .accdb / the * .accde/.xls/.xlsx/.xlsm/.xlsb/.gdb/.fdb/.sdf/.db/.db3 /. the sqlite / *. dsn / * udl / *. dbc is
· Upd: contains many small fixes and optimize the update ... the cumulative processing
Table ( Table Editor ):
· Upd: (Firebird) to support the existing field is NULL / NOT NULL status update processing
· Add: Support of Firebird 2.0 or higher field in a table describe the update process ( Column Comments )
· Cumulative support for the Access / MySQL / SQL Server / PostgreSQL / in Oracle / an IBM DB2 / of Firebird and other databases
· Upd: [new] table processing Default Value mode [edit] table automatically added the default QuotedString
· Amendment, eliminating the need for a null value when default QuotedString processing, to avoid the establishment of a default null value
Generated by the script ( Data Definition Language ):
· Fix: (Oracle) correction TRIGGER syntax generated content, END ALTER TRIGGER need to GO dealt with separately to avoid problems
· Fix: (PostgreSQL) correction TRIGGER syntax generation, does not support the version 9.0 database
· Upd: (PostgreSQL) to update the INDEX syntax to generate, support the expression ( expression ) index name processing
SQL Performance Analyzer ( SQL Profiler ):
· Upd: update the historical record mode (Log Mode): SQL command to perform different background color to distinguish between failure
SQL Editor ( SQL Editor ):
· Fix: amendments to the Copy to the Clipboard RTF output formats, both the selected text may appear error
· Upd: simplify the clipboard to paste processing (Paste), the original menu function Unformatted Text / HTML Format changed to selective projects drop-down processing
May 12th, 2012The main program updates (Main):
· Add: Add Table message is displayed (TABLE statistics): the size of the Table, Indexes, size ... etc. (4515)
· Database with SQL Server / SQLAzure / MySQL / PostgreSQL / Oracle / Sybase ASE / Firebird / IBM DB2/Informix etc.
· Add: Support for PostgreSQL / Oracle / IBM DB2 table field describes the update process (Column Comments) (4508/4 515)
· Accumulated to support the Access / MySQL / SQL Server / PostgreSQL / in Oracle / an IBM DB2 and other database
· Update upd: (PostgreSQL) CONSTRAINTS object Display, exclusion is not null CHECK display and processing (4515)
· Add: the title bar to join (Database Tools / shortcut menu code catalog / reference link) (Quick Links) (4 515)
· Fix: (SQL Server) the amendment Browse [all] database mode (Browse all databases) under AttachDb over two related operations can not handle normal issues (4515)
· Upd: significantly improved the SQL Server table field descriptions (table edit / script generation) processing speed (Column Comments) (4508)
· Upd: to solve the GAC including NET 2.0 version of the component (eg System.Data.SQLite.dll) due to Mixed mode assembly result in being unable to start (4508)
· Upd: update Italian interface language Italian language (by Paolo, Saudin) (4508)
· Upd: contains many small fixes and optimize the update ... the cumulative processing (4515)
· Misc: Compatible with MySQL 5.5.24 (2012/05/07) / MySQL 5.1.63 (2012/05/07)
· Misc: Compatible with IBM DB2 10.1 (2012/04/30)
Generated by the script (Data Definition Language):
· Upd: (Access) to update the TABLE syntax to generate, increase the field of the WITH COMPRESSION attribute message is displayed (4515)
· Upd: (SQL Server) to update the DATABASE syntax generation, increase the properties of the Extended Properties Database message is displayed (4515)
· Upd: (SQL Server / SQLAzure) to enhance the table (TABLE) script to generate the processing speed (4515)
· Fix: (SQLAzure) amend and update the index field sort display state (Sort Order) (4515)
Index (Index Editor):
· Upd: (PostgreSQL) to update previous versions of the PostgreSQL 8.3 does not support indexed sort settings (4515)
Row editing (Data Editor):
· Fix: fixes and improvements of the editor under the refresh (4508)
· Upd: reproduce data update Column (the Duplicate the Row,): in the [additional] Wait (4508) modify the state after new
May 5th, 2012Table ( Table Editor ):
· Add: (Access / MySQL / SQL Server) to support field in a table to describe the update process ( Column Comments )
· Add: (Access) to support the Access field was renamed Processing
· Upd: the Data Type field (length) exception handling, to avoid name in here to change the type of information rather than the length
· Upd: Update the Data Type column bit enable field categories can change the enable status updates
· Fix: Fixed (446?) Causes [exists and can be updated]. Field attributes Data Type (length) can not re-change problems
SQL Editor ( SQL Editor ):
· Upd: rewrite (Page Down / Up) Switch handle fixed-point switch to replace in a position to move the cursor and then switch processing
· Fix: Fixed (Select All) have been selected fragments of any text word, if we perform the selected all the contents (Select All), contains only the location of all the contents of the bottom, but not all
· Upd: Update to save processing (Save), specified the open files at the click save position remains unchanged, no longer forced to save to the Code Manager
· Upd: 1. New Open (Open) functionality with the taskbar, save (Save) state, and tools are listed to save the state the same
· Fix: Fixed SQL editor to set HorizontalRuler = True, the AutoComplete ( AutoComplete for ) to cover the contents of the current input
Row editing ( Data Editor ):
· Add: Update XML browser ( XML Viewer ): increase in the Tree object browser mode
Generated by the script ( Data Definition Language ):
· Upd: (MySQL) to update the TABLE syntax generation, increase the ENGINE, the DEFAULT CHARSET, the COLLATE, COMMENT, and other message is displayed
SQL Performance Analyzer ( SQL Profiler ):
· Add: Add a text search function ( Find In Grid ): rows can be found in the school to analyze historical data
The main program updates ( Main ):
· Upd: improved portability mode processing (Portable Mode): support [sibling] database relative path (relative path) processing
· Add: (Excel) to add Excel Macro-Enabled Workbook (*. Xlsm) with an Excel Binary Workbook (*. Xlsb) and other file formats support
· Fix: (Oracle) to correct the official in Provider the NVARCHAR2 maximum length defined error
· Add: (OData) Add Raw raw data with Tree Tree ( Raw / Tree ) Display
· Upd: (OData) is a major update to optimize the connection with many of the access speed
· Fix: (OData) update the OData access AssociationSet attribute name and address Name and Association property name is inconsistent with the exception occurred
· Upd: (SQLAzure) support SQL Azure 11.xx or higher version, to solve the version not function properly connect to open
· Upd: contains many small fixes and optimize the update ... the cumulative processing
· Misc: Compatible with of Firebird 2.0.7 (2012/04/12)
· Misc: Compatible with the MySQL 5.5.23 (2012/04/12)
April 24th, 2012Table ( Table Editor ):
· Add: (Access / MySQL / SQL Server) to support field in a table to describe the update process ( Column Comments )
· Add: (Access) to support the Access field was renamed Processing
· Upd: the Data Type field (length) exception handling, to avoid name in here to change the type of information rather than the length
· Upd: Update the Data Type column bit enable field categories can change the enable status updates
· Fix: Fixed (446?) Causes [exists and can be updated]. Field attributes Data Type (length) can not re-change problems
SQL Editor ( SQL Editor ):
· Upd: rewrite (Page Down / Up) Switch handle fixed-point switch to replace in a position to move the cursor and then switch processing
· Fix: Fixed (Select All) have been selected fragments of any text word, if we perform the selected all the contents (Select All), contains only the location of all the contents of the bottom, but not all
· Upd: Update to save processing (Save), specified the open files at the click save position remains unchanged, no longer forced to save to the Code Manager
· Upd: 1. New Open (Open) functionality with the taskbar, save (Save) state, and tools are listed to save the state the same
· Fix: Fixed SQL editor to set HorizontalRuler = True, the AutoComplete ( AutoComplete for ) to cover the contents of the current input
Row editing ( Data Editor ):
· Add: Update XML browser ( XML Viewer ): increase in the Tree object browser mode
Generated by the script ( Data Definition Language ):
· Upd: (MySQL) to update the TABLE syntax generation, increase the ENGINE, the DEFAULT CHARSET, the COLLATE, COMMENT, and other message is displayed
SQL Performance Analyzer ( SQL Profiler ):
· Add: Add a text search function ( Find In Grid ): rows can be found in the school to analyze historical data
The main program updates ( Main ):
· Upd: improved portability mode processing (Portable Mode): the relative path (relative path) to support database processing
· Add: (Excel) to add Excel Macro-Enabled Workbook (*. Xlsm) with an Excel Binary Workbook (*. Xlsb) and other file formats support (4497)
· Fix: (Oracle) to correct the official in Provider the NVARCHAR2 maximum length defined error (4000 -> 2000)
· Add: (OData) Add Raw raw data with Tree Tree ( Raw / Tree ) Display
· Upd: (OData) is a major update to optimize the connection with many of the access speed
· Fix: (OData) update the OData access AssociationSet attribute name and address Name and Association property name is inconsistent with the exception occurred
· Upd: (SQLAzure) support SQL Azure 11.xx or higher version, to solve the version not function properly connect to open
· Upd: contains many small fixes and optimize the update ... the cumulative processing
· Misc: Compatible with of Firebird 2.0.7 (2012/04/12)
· Misc: Compatible with the MySQL 5.5.23
April 12th, 2012· Add: (OData) Add Raw raw data with Tree Tree ( Raw / Tree ) Display
· Upd: (OData) is a major update to optimize the connection with many of the access speed
· Fix: (OData) update the OData access AssociationSet attribute name and address Name and Association property name is inconsistent with the exception occurred
· Upd: (SQLAzure) support SQL Azure 11.xx or higher version, to solve the version not function properly connect to open
· Upd: contains many small fixes and optimize the update ... the cumulative processing
SQL Editor ( SQL Editor ):
· Upd: 1. New Open (Open) functionality with the taskbar, save (Save) state, and tools are listed to save the state the same
· Fix: Fixed SQL editor to set HorizontalRuler = True, the AutoComplete ( AutoComplete for ) to cover the contents of the current input
April 6th, 2012Generated by the script ( the SCRIPT AS ):
· Add: Update Data (INSERTs) script to generate support for the export option is set ( Export Options )
· Eases Migration to compatible database can be generated into the command script
The main program updates ( Main ):
· Upd: program to simplify set up processing (Options) to make it more consistent and intuitive
· Original custom other connection parameters set Options -> Additional Connection Parameters (Global) relocated to their respective connections menu
· Upd: (SQLite) updated component System.Data.SQLite.DLL 1.0.80.0 (3.7.11) (2012/03/31)
· Add: (SQLite) to support the database backup ( Backup the Database ), to back up the general database or memory database backup to a file
· Add: (SQLite) memory database ( Memory database )
· Add: Support Access table renamed processing (Renaming database table)
· Add: Print function to support the vertical / horizontal selection ( Portrait / Landscape )
· Upd: (Firebird) FirebirdSql.Data.FirebirdClient.dll 2.7.5 update components ( ) (2012/03/28)
· Upd: contains many small fixes and optimize the update ... the cumulative processing
· Upd: Update Database. NET Additional Files (2012/03/27)
· Misc: Compatible with the MySQL 5.5.22 (2012/03/21)
- Table ( Table Editor ):
· Upd: support (SQLite / FoxPro), field length update the Data Type (Length)
· Upd: the length of the field Data Type (Length) is empty and no parameters ReadOnly status update processing
March 30th, 2012· Add: Support Access table renamed processing (Renaming database table)
· Add: (SQLite) memory database ( Memory database ) ( )
· Add: Print function to support the vertical / horizontal selection ( Portrait / Landscape )
· Upd: (Firebird) FirebirdSql.Data.FirebirdClient.dll 2.7.5 update components ( ) (2012/03/28)
· Upd: contains many small fixes and optimize the update ... the cumulative processing
· Upd: Update Database. NET Additional Files (2012/03/27)
· Misc: Compatible with the MySQL 5.5.22 (2012/03/21)
Table ( Table Editor ):
· Upd: support (SQLite / FoxPro), field length update the Data Type (Length)
· Upd: the length of the field Data Type (Length) is empty and no parameters ReadOnly status update processing
March 24th, 2012· Upd: support (SQLite / FoxPro), field length update the Data Type (Length)
· Upd: the length of the field Data Type (Length) is empty and no parameters ReadOnly status update processing
- The main program updates ( Main ):
· Upd: contains many small fixes and optimize the update ... the cumulative processing
· Upd: Update Database. NET Additional Files (2012/03/23)
· Misc: Compatible with the MySQL 5.5.22 (2012/03/21)
March 16th, 2012· Fix: Update KEYS object browser to support the same field multiple reference (the Multiple Foreign Keys)
· Upd: Solving the interface does not support the Themes service is not enabled color custom settings ( Custom Color )
· Upd: (Firebird / MySQL / SQL Server) Improved connection automatically enabled database services, not yet completely avoid enabled lead to connection failure has occurred
· Upd: improve the user experience and optimize the display interface ( New User Interface )
· Upd: interface color custom to increase the label color settings ( Tab Color )
· Upd: (SQLCe) to support the repair password protected database ( Manually Verify and Repair Database )
· Fix: (SQL Server) the amendment to browse database mode ( Browse all databases ) AttachDb not supported
· Upd: (MySQL) updated component MySql.Data.dll 6.5.4 (2012/03/06)
· Upd: contains many small fixes and optimize the update ... the cumulative processing
· Misc: Compatible with the SQL Server 2012 RTM / SQL Server 2012 Express / LocalDB (2012/03/06)
Database Diagrams ( Database Diagram ):
· Add: Add a table associated to delete processing ( Delete relationships )
· Fix: fixes and updates Multiple cross-reference the associated display (the Multiple Foreign Keys)
Row editing ( Data Editor ):
· Add: Edit menu to add conditions to filtering ( Filter Expression )
Generated by the script ( the SCRIPT AS ):
· Upd: updated Data (INSERTs) script to generate support AutoIncrement field is omitted or not output processing
Generated by the script ( Data Definition Language ):
· Fix: (SQLCe) amendments to the Multiple Foreign Keys column name to display the sequence of problems
March 5th, 2012· Addnew custom interface color settings ( Custom Color )
· Fixcorrection can not be deleted SQLCe index object
· UpdUpdate portability mode settings are saved (Portable Mode)
· Upd(SQLCe) update components for SQL Server Compact 4.0 SP1 (4.0.8854.1) (2012/02/29)
· Upd(PostgreSQL) updated components Npgsql.dll 2.0.11.93 (2012/02/21)
· Upd(MySQL) updated component MySql.Data.dll 6.5.3 (2012/02/23)
· Updbetter deal for the Date data type (data display / edit data / script generation)
· Database contains SQLite / Firebird / SQL Server / SQL Azure / PostgreSQL / MySQL / IBM DB2/Informix/FoxPro etc.
· Updcontains many small fixes and optimize the update ... the cumulative processing
· MiscCompatible with the PostgreSQL 9.1.3 (2012/02/27) / MySQL 5.5.21 (2012/02/17)
Table ( Table Editor ):
· UpdEdit row support click on the field sort processing ( Column the Sorting )
· Upd(SQLite) to support the field in a table type of update processing (Change ColumnType) (non-native)
· Upd(SQLite / Firebird / ODBC / the OleDB) update on the table increase the field (the Add Columns) support changing the NULL / NOT NULL set (4440)
· Correction can not fix(Firebird) increase in the table of existing data fields (the Add Columns)
Generated by the script ( the SCRIPT AS ):
· UpdUpdate the INSERT and UPDATE script to generate support AutoIncrement field omitted processing
Generated by the script ( Data Definition Language ):
· Updsupport for the Multiple Foreign Keys syntax
February 27th, 2012· Upd: better deal for the Date data type (data display / edit data / script generation)
· Database contains SQLite / Firebird / SQL Server / SQL Azure / PostgreSQL / MySQL / IBM DB2/Informix/FoxPro etc.
· Upd: (MySQL) updated component MySql.Data.dll 6.5.3 (2012/02/23)
Table ( Table Editor ):
· Upd: (SQLite) to support the field in a table type of update processing (Change ColumnType) (non-native)
· Upd: (SQLite / Firebird / ODBC / the OleDB) update on the table increase the field (the Add Columns) support changing the NULL / NOT NULL set
· Correction can not fix: (Firebird) increase in the table of existing data fields (the Add Columns)
Generated by the script ( the SCRIPT AS ):
· Upd: Update the INSERT and UPDATE script to generate support AutoIncrement field omitted processing
Generated by the script ( Data Definition Language ):
· Upd: support for the Multiple Foreign Keys syntax
February 24th, 2012· Add: support for the Visual FoxPro Database Database Management: Support for existing full functionality and features ( )
· Add: increase an AutoIncrement, CHECK constraints, Foreign Keys, the Database Diagram and other support
· Fix: Resolved and the date and time format handling ( Date and a DateTime a DataTypes )
· Fix: solve the debugging VFP command easily lead to the file locking problem File must be opened exclusively. OR, File is in. use.
· Add: increase CHECK constraints object to display and process
· Support for SQL Server / SQL Azure / PostgreSQL / Firebird / SQLite / Oracle / IBM DB2/Informix/Sybase ASE / FoxPro and other database
· Fix: (SQLite / Sybase ASE), amendment may affect the information line editor or other problems
· Upd: (Firebird) update the TRIGGERS objects, hidden the unnecessary SYSTEM_TRIGGER Objects
· Upd: (SQLite) table structure transactions to support the INDEX and CHECK automatically rebuild processing (non-native)
· Updates to fix: (Oracle), the type of information may lead to not function properly edit and browse the delay problem
· Upd: (MySQL) updated components MySql.Data.dll 6.5.2 (2012/02/11)
Upd: updated the command-line number ( the Command-line ):
· Upd: Update Database. NET Additional Files (2012/02/17)
· Upd: contains many small fixes and optimize the update ... the cumulative processing
· Misc: Compatible with the MySQL 5.5.21 (2012/02/17)
SQL Performance Analyzer ( SQL Profiler ):
· Upd: Log the Mode support an OData / the OleDB / ODBC / Excel / the dBASE / FoxPro, and other databases
Code management ( Code Manager ):
· Fix: Fixed heavy brush lead to the original open SQL can not find where the original node position
· Not refresh fix: amendments directory renamed
· Upd: add the directory and renamed to add an exception character tips and Processing
Database Backup and Restore ( Backup / Restore Database ):
· Upd: (MySQL / PostgreSQL) database backup to support the additional parameter-setting ( Additional the arguments )
· Upd: (MySQL / PostgreSQL) backup and restore the machine to install the database eliminates the need for additional file processing (Additional Files)
· Upd: the SQL Server backup and restore support script mode ( Script Action to New Query Window )
February 20th, 2012· Add: (SQL Server / SQL Azure / PostgreSQL / Firebird / SQLite / Oracle / IBM DB2/Informix/Sybase) increase CHECK constraints object to display and processing
· Upd: (Firebird) update the TRIGGERS objects, hidden the unnecessary SYSTEM_TRIGGER Objects
· Upd: (SQLite) table structure transactions to support the INDEX and CHECK automatically rebuild processing (non-native)
· Updates to fix: (Oracle) (4400), the type of information may lead to not function properly edit and browse the delay problem
· Add: support for the Visual FoxPro Database Database Management: Support for existing full functionality and features ( )
· Upd: (MySQL) updated components MySql.Data.dll 6.5.2 (2012/02/11)
Upd: updated the command-line number ( the Command-line ):
· Upd: Update Database. NET Additional Files (2012/02/17)
· Upd: contains many small fixes and optimize the update ... the cumulative processing
SQL Performance Analyzer ( SQL Profiler ):
· Upd: Log the Mode support an OData / the OleDB / ODBC / Excel / the dBASE / FoxPro, and other databases
Code management ( Code Manager ):
· Fix: Fixed heavy brush lead to the original open SQL can not find where the original node position
· Not refresh fix: amendments directory renamed
· Upd: add the directory and renamed to add an exception character tips and Processing
Database Backup and Restore ( Backup / Restore Database ):
· Upd: (MySQL / PostgreSQL) database backup to support the additional parameter-setting ( Additional the arguments )
· Upd: (MySQL / PostgreSQL) backup and restore the machine to install the database eliminates the need for additional file processing (Additional Files)
· Upd: the SQL Server backup and restore support script mode ( Script Action to New Query Window )
February 17th, 2012· Add: support for the Visual FoxPro Database Database Management: Support for existing full functionality and features ( )
· Upd: (MySQL) updated components MySql.Data.dll 6.5.2 (2012/02/11)
Upd: updated the command-line number ( the Command-line ):
· Upd: Update Database. NET Additional Files (2012/02/17)
· Upd: contains many small fixes and optimize the update ... the cumulative processing
Database Backup and Restore ( Backup / Restore Database ):
· Upd: (MySQL / PostgreSQL) database backup to support the additional parameter-setting ( Additional the arguments )
· Upd: (MySQL / PostgreSQL) backup and restore the machine to install the database eliminates the need for additional file processing (Additional Files)
· Upd: the SQL Server backup and restore support script mode ( Script Action to New Query Window )
Code management ( Code Manager ):
· Not refresh fix: amendments directory renamed
· Upd: add the directory and renamed to add an exception character tips and Processing
February 9th, 2012· Upd: increase the time spent in the execution of SQL commands ( SQL execution time ) Total time is the implementation of output, it takes time
· Upd: (SQLite) updated component System.Data.SQLite.DLL 1.0.79.0 (3.7.10) (2012/01/28)
· Upd: code optimization, significantly increasing the row browse the display speed by about 40% +
· Upd: (MySQL) updated component MySql.Data.dll 6.5.1 (2012/01/23)
· Upd: (Sybase) to join the data browser exception, cause the browser to interrupt ignored due to the Provider itself a bug. Eg: "Value was either too large or too small for a Decimal to."
· Upd: contains many small fixes and optimize the update ... the cumulative processing
Index ( Index Editor ):
· Upd: (SQLite) joining sqlite_autoindex index object generated with the script
· Add: indexing support for changing the field order processing ( Change the Column Positions )
· Upd: the index field and the script is generated in accordance with the order of the actual establishment of the (ordinal position)
· Fix: (Sybase) Fix the index script to generate the right questions (Provider bug)
SQL Editor ( SQL Editor ):
· Fix: solve using the runas command to run the the SQL Formatting plug-in feature does not show the problem
· Upd: When the editor is set after the change (Options-> Editor Settings) will also update all open Editor settings
· Upd: Fixed auto-sensing ( IntelliSense ):. to avoid the display of useless blank project
SQL Performance Analyzer ( SQL Profiler ):
· Upd: (SQL Server) to increase the database (Database Name) field (4407)
· Fix: (SQL Server) to solve the problem does not support the Global Mode, remote connection
Code management ( Code Manager ):
· Upd: SQL file content search additional search button (Search Button) processing in addition to the original Enter to F5
Generated by the script ( the SCRIPT AS ):
· Fix: correction UPDATE generated more ") the end of the character of the problem
Connection settings ( Connection Profile ):
· Fix: amendments to the existing connection settings if you change the connection authorization can not be memory problems
January 25th, 2012· Upd: code optimization, significantly increasing the speed of the row view shows more than about 40% +
· Upd: (MySQL) to update components MySql.Data.dll 6.5.1 (2012/01/23)
· Upd: (Sybase) to join the data view exceptions, ignored by Provider bug causes the browser to break its own problems. Eg: "Value was either too large or too small for a Decimal."
· Upd: Other minor fixes and optimization includes many updates ... they accumulate processing
Index editor ( Index Editor ):
· Add: support for changing the indexing field sequential processing ( Change Column Positions )
· Upd: index field generated by the actual creation of the script displayed in the order (Ordinal position)
· Fix: (Sybase) Index Scripting generate incorrect fix the problem (Provider's own bug)
SQL Performance Analyzer ( SQL Profiler ):
· Upd: (SQL Server) to increase the database (Database Name) field shows the
· Fix: (SQL Server) to connect remotely to solve the next problem is not supported Global Mode
Connection settings ( Connection Profile ):
· Fix: correction of the existing connection settings, change the connection if the license can not remember the issue
January 18th, 2012· Add: Added support for SQL Server Express LocalDB database management: full functionality and features to support existing ( Automatically enumerate instances ) ( )
· Upd: trading patterns ( Transaction Mode ): increased recognition (Commit) and recovery (Rollback) treatment failure error message is displayed (4400)
· Add: (SQL Server) support detach the database processing ( Detach Database )
· Fix: (Oracle) SQL command to resolve possible "Arithmetic operation resulted in an overflow" exception
· Upd: (Oracle) updated components Oracle.DataAccess.dll 11.2.0.3.0 (2011/12/28)
· Fix: (DB2) correction can not be opened problem of non-default database
· Upd: increase. NET Framework v4.0 Full version of the test, avoid only install v4.0 Client version of the operating environment, the problem can not start
· Misc: Compatible with MySQL 5.5.20 (2012/01/06)
· Upd: Other minor fixes and optimization includes many updates ... they accumulate processing
Row editing ( Data Editor ):
Upd: improved text editor with text browser ( Text Editor and Text Viewer ):
· Support for XML syntax highlighting (XML Syntax Highlighting) (4392)
· Support search and print functions (Find and Print)
· This supports a larger view
· Fix: Cell Editor ( Cell Editor ): correction field in a table without Primary Keys when editing, can not be more than once to save or import processing, the need to refresh after treatment (4392)
· Upd: CELL viewing and editing support for double-dealing ( DoubleClick to View and Edit a cell )
· Upd: Batch Import ( Batch Import ): Support includes but not AutoIncrement PrimaryKey field import processing
Connection settings ( Connection Profile :
· Fix: (SQL Server) correct connection settings ( Connection Profile : When using AttachDbFilename specify the database name automatically, to avoid the result can not be opened
· Upd: (Oracle) connection management reassign Oracle Client no longer need to restart the program processing (to solve the problem itself Oracle.DataAccess)
· Upd: (DB2) to restore and improve server automatically processing examples ( Browse for servers )
· Fix: Delete the list of projects with the Connection Manager ( Connection Manager and List ), together with the Profile settings will be dealt with (with the Delete Profile settings), while addressing the new problems if the same name
· Fix: Click the drop-down automatically if it fails the database examples, in the early environment (eg XP) will cause problems
Code Management ( Code Manager ):
· Add: Support drag and drop Move SQL example files ( Drag and Drop a SQL file )
SQL Editor ( SQL Editor ):
· Upd: Auto-sensing process ( IntelliSense ): improving the conditions of multi-line SQL table field perception processing
January 3rd, 2012· Add: Added support for SQL Server Express LocalDB database management: full functionality and features to support existing ( Automatically enumerate instances ) ( )
· Upd: increase. NET Framework v4.0 Full version of the test, avoid only install v4.0 Client version of the operating environment, the problem can not start
· Fix: (DB2) correction can not be opened problem of non-default database
· Upd: Other minor fixes and optimization includes many updates ... they accumulate processing
SQL Editor ( SQL Editor ):
· Upd: Batch Import ( Batch Import ): Support includes but not AutoIncrement PrimaryKey field import processing
SQL Editor ( SQL Editor ):
· Upd: Auto-sensing process ( IntelliSense ): improving the conditions of multi-line SQL table field perception processing
December 22nd, 2011The main program updates ( Main ):
· Upd: fish's dotNET about to enter its ninth year, all the software upgrade to the full . NET Framework 4.0 development environment, to provide more room for growth in the future
· (Note: the the. NET Framework update, the commercial licensed version ( Commercial Use ) free upgrade)
· Solve the operating environment without installing Microsoft Visual C + + 2010 Runtime , you can not start the problem
· Upd: (Firebird) updated components FirebirdSql.Data.FirebirdClient.dll 2.7.0 (2011/12/19)
· Upd: (Oracle) updated components Oracle.DataAccess.dll 11.2.0.2.50 (2011/09/20)
· Upd: (Sybase) updated components Sybase.AdoNet4.AseClient.dll 4.157.80.0 (2011/08/26)
· Upd: (Sybase) update additional connection settings and exception handling ( Additional Connection Parameters )
· Add: New Turkmen interface language Turkmen language
· Upd: portable mode (Portable Mode) under a more complete treatment of all portable settings are saved
· Upd: Connection Manager ( Connection Manager and List ): Automatic Updates (Access / Excel / Firebird / SQLCe / SQLite / OleDB (*. udl) / ODBC (*. dsn)) file location
· Upd: (MySQL / SQL Server/PostgreSQL/DB2) DATABASE and SCHEMA new and improved auto-delete brush handle
· Upd: Update Database. NET Additional Files (2011/12/09)
· Upd: Other minor fixes and optimization includes many updates ... they accumulate processing
· Misc: Compatible with MySQL 5.1.60 (2011/10/30) / MySQL 5.5.19 (2011/12/07)
· Misc: Compatible with PostgreSQL 9.1.2 (2011/12/05)
SQL Editor ( SQL Editor ):
· Upd: Batch Import ( Batch Import ): Set the delimiter share ( delimiter ), and increase the final set of memory processing
· Add: New tag name name change process ( Rename Tab ), newly opened to replace the original query (New Query) when the query processing
· Fix: When the contents of the transaction at no additional save or rename the tag name without sync problems (Windows and SQL code tag list node)
· Upd: Auto-sensing process ( IntelliSense ): 1. increase TableName + "." perception of treatment, (2) update the Tab character handling (with blank), 3 update exception handling
Database Backup and Restore ( Backup / Restore Database ):
· Upd: (MySQL / PostgreSQL) renamed to restore the database to support the new database
· Upd: (MySQL / PostgreSQL) to switch to backup and restore system built-in or additional approach (Additional Files), reducing the program package
· Upd: (PostgreSQL) to rewrite the backup and restore process, restore format and supports Plain
· Upd: (MySQL) backup contains the complete contents of the Procedures and Functions, etc
December 12th, 2011· Upd: portable mode (Portable Mode) under a more complete treatment of all portable settings are saved
· Upd: Connection Manager ( Connection Manager and List ): Automatic Updates (Access / Excel / Firebird / SQLCe / SQLite / OleDB (*. udl) / ODBC (*. dsn)) file location
· Upd: (MySQL / SQL Server/PostgreSQL/DB2) DATABASE and SCHEMA new and improved auto-delete brush handle
· Upd: Update Database. NET Additional Files (2011/12/09)
· Upd: Other minor fixes and optimization includes many updates ... they accumulate processing
· Misc: Compatible with MySQL 5.1.60 (2011/10/30) / MySQL 5.5.19 (2011/12/07)
· Misc: Compatible with PostgreSQL 9.1.2 (2011/12/05)
SQL Editor ( SQL Editor ):
· Add: New tag name name change process ( Rename Tab ), newly opened to replace the original query (New Query) when the query processing
· Fix: When the contents of the transaction at no additional save or rename the tag name without sync problems (Windows and SQL code tag list node)
· Upd: Auto-sensing process ( IntelliSense ): 1. increase TableName + "." perception of treatment, (2) update the Tab character handling (with blank), 3 update exception handling
Database Backup and Restore ( Backup / Restore Database ):
· Upd: (MySQL / PostgreSQL) renamed to restore the database to support the new database
· Upd: (MySQL / PostgreSQL) to switch to backup and restore system built-in or additional approach (Additional Files), reducing the program package
· Upd: (PostgreSQL) to rewrite the backup and restore process, restore format and supports Plain
· Upd: (MySQL) backup contains the complete contents of the Procedures and Functions, etc.
November 28th, 2011SQL Editor ( SQL Editor ):
· Upd: Auto-sensing process ( IntelliSense ): 1. increase the Table Columns perception processing
· fix QuotedString exceptions
· 3 increase the TAB key to complete processing
· Upd: support [single] SQL command semicolon (;) batch processing (SELECT / INSERT / UPDATE / DELETE / CREATE / ALTER / DROP / USE xxx;)
The main program updates ( Main ):
· Add: increase the Sybase additional connection settings ( Additional Connection Parameters )
· Upd: portable mode (Portable Mode) to set options to increase the overall database connection settings are saved with the relevant major
· Upd: (ODBC / OleDB) to avoid errors in the database driver itself, resulting in row editing, field joint QuotedString can not be displayed properly complete the editing problems (such as Unify SQLBase )
· Upd: (ODBC) update the field in a table display, increase the Schema specifies the process to avoid the same table but different Schema, resulting in repeated field problems (such as Unify SQLBase ) (four thousand three hundred and forty-nine)
· Upd: (SQLite) updated components System.Data.SQLite.dll 1.0.77.0 (3.7.8) (2011/11/28)
· Upd: (MySQL) update backup program (mysqldump.exe) since the latest version of MySQL 5.5.18 (2011/11/16)
· Upd: (DB2/Informix) updated components IBM.Data.DB2.dll / IBM.Data.Informix.dll 9.7.5.2 (2011/10/28)
· Fix: (DB2) correction can not be normal browsing PRIMARY / FOREIGN KEY INDEX edit window created problems
· Fix: (Sybase ASE) when the correction started dbschema Index Table to read different problems
· Upd: (SQL Server / MySQL / Firebird) changed its name to restore the database when processing the cancellation was renamed when the Exception Handling
· Upd: strengthening the response to the error message shows examples of error messages to provide a more complete set of display (4340)
· Fix: Other minor fixes and optimization includes many updates ... they accumulate processing
· Misc: Compatible with Microsoft SQL Server 2012 Release Candidate 0 (RC0) / Express (2011/11/17)
· Misc: Compatible with MySQL 5.1.60 (2011/10/30) / MySQL 5.5.18 (2011/11/16)
· Misc: Compatible with IBM DB2 9.7.5 (2011/11/14) / IBM Data Server Client Version 9.7 Fix Pack 5 Packages (2011/10/28)
Script generated ( Data Definition Language ):
· Upd: (SQL Server / SQL Azure / MySQL / PostgreSQL / Oracle / Sybase ASE/DB2/Informix) increase the reference information table Schema Name
Script generated ( SCRIPT AS ):
· Fix: (Oracle) solution with spaces if ColumnType as: NUMBER (38,0), lead to the generation field is not displayed correctly when the problem (This update applies to all database processing)
· Upd: integrated into the original Generate Scripts SCRIPT AS Data (INSERTs) , it clearly is more consistent operation
· Add: Added script to generate VIEWS objects (SCRIPT AS SELECT / INSERT / UPDATE / DELETE / CREATE)
· Add: Added TABLES / PROCEDURES / FUNCTIONS object to create a script to generate (SCRIPT AS CREATE) (Properties with content)
November 21st, 2011· Upd: Auto-sensing process ( IntelliSense ): 1. increase the Table Columns awareness processing, (2) amend QuotedString exceptions
· Upd: (MySQL) update backup program (mysqldump.exe) since the latest version of MySQL 5.5.18
· Upd: (DB2/Informix) updated components IBM.Data.DB2.dll / IBM.Data.Informix.dll 9.7.5.2
· Fix: (DB2) correction can not be normal browsing PRIMARY / FOREIGN KEY INDEX edit window created problems
· Fix: (Sybase ASE) when the correction started dbschema Index Table to read different problems
· Upd: (SQL Server / MySQL / Firebird) changed its name to restore the database when processing the cancellation was renamed when the Exception Handling
· Upd: strengthening the response to the error message shows examples of error messages to provide a more complete set of display
· Fix: Other minor fixes and optimization includes many updates ... they accumulate processing
· Misc: Compatible with Microsoft SQL Server 2012 Release Candidate 0 (RC0) / Express
· Misc: Compatible with MySQL 5.1.60 (2011/10/30) / MySQL 5.5.18
· Misc: Compatible with IBM DB2 9.7.5 (2011/11/14) / IBM Data Server Client Version 9.7 Fix Pack 5 Packages (2011/10/28)
Script generated ( Data Definition Language ):
· Upd: (SQL Server / SQL Azure / MySQL / PostgreSQL / Oracle / Sybase ASE/DB2/Informix) increase the reference information table Schema Name
Script generated ( SCRIPT AS ):
· Upd: Generate Scrips integrated into the original SCRIPT AS Data (INSERTs) , it clearly is more consistent operation
· Add: Added script to generate VIEWS objects (SCRIPT AS SELECT / INSERT / UPDATE / DELETE / CREATE)
· Add: Added TABLES / PROCEDURES / FUNCTIONS object to create a script to generate (SCRIPT AS CREATE) (Properties with content)
November 11th, 2011· Add: New Sybase ASE database management: full functionality and support for existing properties ( )
· Add: Connection Manager ( Connection Manager ): New Access, Excel, Firebird, SQLite, SQLCe connection settings such as additional functionality (Additional Connection Parameters)
· Upd: updated ODBC settings, operating environment to support the x64 ODBC Data Source Administrator ( 64bit/32bit ) set selection
· Upd: updated ODBC settings, add menu heavy brush handle (Refresh List), easy to set up after the heavy brush list
· Upd: (MySQL) Browse [all] database ( Browse All Databases ): PARAMETERS object and display increased FUNCTIONS (with [specified] database)
· Upd: Database Diagrams ( Database Diagram ): Improved Save (SaveAs) and print (Print) function, the full output of the screen
· Fix: (dBase) right-click menu correct the CREATE INDEX can not be opened problem
· Upd: (MySQL) database to support browser USE command to switch display processing (with SQL Server, Sybase)
· Upd: improved portability mode switching processing, auto-restore the default path
· Fix: Other minor fixes and optimization includes many updates ... they accumulate processing
Script generated ( SCRIPT AS ):
· Add: New PROCEDURES object query script generated (SCRIPT AS EXECUTE), support for SQL Server, SQL Azure, Sybase, MySQL, Firebird, DB2, Informix
· Add: Added script to generate the query object FUNCTIONS (SCRIPT AS SELECT), support for SQL Server, SQL Azure, Sybase, MySQL, Firebird, DB2, Informix, PostgreSQL
· Fix: correction that led to a model script (SCRIPT AS) failed to generate the problem
Script generated ( Data Definition Language ):
· Add: more complete table syntax generated display ( DDL Full Details ), supports syntax display Foreign Key
· All database systems support SQL Server, SQL Azure, SQLCe, SQLite, Access, MySQL, Firebird, PostgreSQL, Oracle, DB2, Informix, Sybase
· Add exception handling, such as a database is not supported for dBase, Excel, OleDB, ODBC
· Upd: updated table DDL syntax generation process, additional INDEX syntax shows, if the Foreign Key will be omitted when dealing with (the same Primary Key)
· Upd: rewrite SQLite, Firebird, MySQL, Oracle DDL syntax table are changed to the built-generation approach (instead of the raw processing), and increase the display INDEX syntax (with other databases)
· Fix: (Firebird) correction PROCEDURES generated DDL script objects: data type DOUBLE-> DOUBLE PRECISION
· Fix: (Firebird) FUNCTIONS object DDL scripts to generate correct: 1. Full support field_sub_type display processing, (2) textual errors RETUENS-> RETURNS
October 27th, 2011· Add: Add Database charting capabilities ( Database Diagram * ): an intuitive way to display the data table associated with the state, support mouse wheel scroll, charts, save and print output ... etc.
· All database systems support SQL Server, SQL Azure, SQLCe, SQLite, Access, MySQL, Firebird, PostgreSQL, Oracle, DB2, Informix
· Upd: database object search ( Search Objects ): open to the general users ( Commercial License )
· Upd: Update the command timeout setting (Command timeout), the maximum value of the original 300s-> 3000s
· Upd: query page Log Mode increases History Save function (SaveAs. ..)
· Upd: (MySQL) update backup program (mysqldump.exe) since the latest version of MySQL 5.5.17 (2011/10/19)
· Fix: (DB2/Informix) Click disconnected Connection.Close amendment pending issues
· Upd: Optimization Generate Scripts output approach, speeds are significantly improved, more economical memory
· Upd: (PostgreSQL) support PostgreSQL 8.1.x or above (?) Version
· Upd: (Access / Excel / dBase) INSERT scripts to generate increased GO command processing
· Add: Library Service Management ( Service Manager ): support for IBM Informix Service Management
Add: (Access) support for database compression and repair manual handling:
· ( Manually Compact and Repair Database ) can be selected directly on the database at the same time compression and restoration process, support (*. mdb; *. accdb; *. mde; *. accde) format
Add: (SQLCe) supports automatic and manual database repair process:
· ( Manually Verify and Repair Database ) can directly open the selected database to detect and repair process, and to fix the problem and remove the problem of providing data query processing (4309)
· (Automatically Repair Database) When you open the database to get the error code, it will fix the problem and remove the problem of providing data query processing
· Upd: Connection Manager ( Connection Manager ): update Firebird, OData, Informix and other connection information display and management
· Upd: row editing ( Data Editor ): updates and support xml data type handling
· Upd: data browsing and editing, support for right-aligned numerical display (Right align numeric values) (Options-> Query settings)
· Upd: objects renamed (Rename Object) after updating the relevant information processing
· Upd: multiple language files update and correction
· Fix: Other minor fixes and optimization includes many updates ... they accumulate processing
· Misc: Compatible with SQL Server 2008 SP3 (10.00.5500.00) (2011/10/06)
SQL Editor ( SQL Editor ):
· Upd: New Query tag name can be customized (New Query Tab)
· Upd: Update tab added option 'Besides all off' (Tab-> Close All But This), all closed (Windows-> Close All)
· Upd: AutoComplete ( AutoComplete ): added complete model (Completion Mode) and the proposed model (Suggestion Mode) switch settings, etc.
October 20th, 2011· Fix: (DB2/Informix) Click disconnected Connection.Close amendment pending issues
· Upd: Optimization Generate Scripts output approach, speeds are significantly improved, more economical memory
· Upd: (PostgreSQL) support PostgreSQL 8.1.x or above (?) Version
· Upd: (Access / Excel / dBase) INSERT scripts to generate increased GO command processing
· Add: Library Service Management ( Service Manager ): support for IBM Informix Service Management
Add: (Access) support for database compression and repair manual handling:
· ( Manually Compact and Repair Database ) can be selected directly on the database at the same time compression and restoration process, support (*. mdb; *. accdb; *. mde; *. accde) format
Add: (SQLCe) supports automatic and manual database repair process:
· ( Manually Verify and Repair Database ) can directly open the selected database to detect and repair process, and to fix the problem and remove the problem of providing data query processing
· (Automatically Repair Database) When you open the database to get the error code, it will fix the problem and remove the problem of providing data query processing
· Upd: Connection Manager ( Connection Manager ): update Firebird, OData, Informix and other connection information display and management
· Upd: row editing ( Data Editor ): updates and support xml data type handling
· Upd: data browsing and editing, support for right-aligned numerical display (Right align numeric values) (Options-> Query settings)
· Upd: objects renamed (Rename Object) after updating the relevant information processing
· Upd: multiple language files update and correction
· Fix: Other minor fixes and optimization includes many updates ... they accumulate processing
· Misc: Compatible with SQL Server 2008 SP3 (10.00.5500.00) (2011/10/06)
SQL Editor ( SQL Editor ):
· Upd: New Query tag name can be customized (New Query Tab)
· Upd: Update tab added option 'Besides all off' (Tab-> Close All But This), all closed (Windows-> Close All)
· Upd: AutoComplete ( AutoComplete ): added complete model (Completion Mode) and the proposed model (Suggestion Mode) switch settings, etc.
September 30th, 2011Row editing ( Data Editor ):
· Add: new data types and support System.Net.NetworkInformation.PhysicalAddress processing (including script-generated (Scripts))
· Upd: updates and support NpgsqlTypes.BitString, System.TimeSpan, System.GUID, System.Net.IPAddress handle data types (including a script to generate (Scripts))
Main program updates ( Main ):
· Upd: (MySQL) to update components MySql.Data.dll 6.4.4 (2011/09/23)
· Upd: (PostgreSQL) to update components Npgsql.dll 2.0.11.92 (2011/09/29)
· Upd: (PostgreSQL) update backup and restore program (pg_dump.exe / pg_restore.exe) since the latest version of PostgreSQL 9.1.1 (2011/09/26)
· Add: New data visualization display ( Data Visualization *) : offers a variety of visual output, data analysis, comparison, save the image as output and printing, etc.
· Add: New IBM Informix Database Management: full functionality and features to support the existing
· Upd: (DB2/Informix) add exception handling to address the IBM Data Server Client version used by the program may not start cause the problem, users can upgrade to the latest version 9.7 Fix Pack 4
· Upd: (OData) updated to support Microsoft DataMarket Services / Data Quality Services (DQS) browsing and debugging process
· Upd: (OData) 1Object Browser can open an external browser by right-click menu, (2) auto-complete function to improve OData ( AutoComplete )
· Fix: resolve SQL Command (join) query debugging, the field with the same name more than two can not be displayed when dealing with the issues
· Upd: (MySQL) update backup program (mysqldump.exe) since the latest version of MySQL 5.5.16 (2011/09/12)
· Fix: (PostgreSQL) backup path can not fix the memory problem
· Fix: other minor fixes and optimization contains many updates and other cumulative processing
· Misc: Compatible with Oracle Database Express Edition 11g Release 2 (2011/09) (four thousand two hundred eighty)
· Misc: Compatible with MySQL 5.5.16 (2011/09/12)
Index editing ( Index Editor ):
· Upd: updated when the new index empty field check processing
Code Management ( Code Manager ):
· Fix: fix new sample file save problem, only for the current [new] SQL editing labels
September 28th, 2011· Add: New data visualization display ( Data Visualization *) : offers a variety of visual output, data analysis, comparison, save the image as output and printing ... etc.
· Add: New IBM Informix Database Management: full functionality and features to support the existing
· Upd: (DB2/Informix) add exception handling to solve using the IBM Data Server Client version can cause problems not start the program, users can upgrade to the latest version 9.7 Fix Pack 4
· Upd: (OData) updated to support Microsoft DataMarket Services / Data Quality Services (DQS) browsing and debugging process
· Upd: (OData) 1. Object Browser can open an external browser by right-click menu, (2) auto-complete function to improve OData ( AutoComplete )
· Fix: resolve SQL Command (join) query debugging, the field with the same name more than two can not be displayed when dealing with the issues
· Upd: (MySQL) update backup program (mysqldump.exe) since the latest version of MySQL 5.5.16 (2011/09/12)
· Upd: (PostgreSQL) update backup and restore program (pg_dump.exe / pg_restore.exe) since the latest version of PostgreSQL 9.1.0 (2011/09/12) (4.28 thousand)
· Fix: (PostgreSQL) backup path can not fix the memory problem
· Fix: other minor fixes and optimization contains many updates ... and other cumulative processing
· Misc: Compatible with Oracle Database Express Edition 11g Release 2 (2011/09) (four thousand two hundred eighty)
· Misc: Compatible with MySQL 5.5.16 (2011/09/12)
Index editing ( Index Editor ):
· Upd: updated when the new index empty field check processing
Code Management ( Code Manager ):
· Fix: fix new sample file save problem, only for the current [new] SQL editing labels
September 10th, 2011· Upd: update Parse Only approach, only for the implementation of analysis and processing will not have any create, update and return the data
· Fix: fix transaction mode ( Transaction Mode ) established under the SQL command CREATE can not handle the problem object
· Add: (Firebird) to support database backup and restore ( Backup / Restore Database: MySQL / PostgreSQL / SQL Server / Firebird )
· Upd: updated build templates CREATE TRIGGER
· Fix: (SQLite / MySQL / Oracle) correct view TRIGGER DDL lost the role of the property pages
· Upd: (DB2) update DataTypes (xCHAR () -> xCHAR ()), to avoid the Open Table name can not obtain the correct field problems
· Add: (Firebird) supports remote connection process ( Remote Connection )
· Add: (OData) increase the authorized user login name and password specified way ( Authentication )
· Upd: (OData) update version and revision EDM approach, providing more support for version format
· Upd: (OData) to simplify setup, enter the URL automatically increase the correction
· Fix: (OData) amend and update the test treatment
· Fix: (PostgreSQL) correct management and use non-default connection account login, drop-down list will result in a database exception occurred (FATAL: 3D000: database "???" does not exist)
· Add: (Object / Code / SQL Browser) to add the name of the shortcut keys to copy the object ( Copy Selected Text : Ctrl + C)
· Upd: a non-Administrator privileges at startup, disable the original Service Manager to Control Panel -> Services to replace
· Upd: If the executable file (Database3.exe) UAC permission to be placed in the directory or ReadOnly, when the set portable mode (Portable mode) when you add exception handling
· Upd: (MySQL) As Out of sync with server , therefore, to temporarily return to old components MySql.Data.dll 6.4.3 -> 6.3.7
· Add: Added French interface language French language
· Upd: Customized language editor ( Custom Language Editor ): 1. automatically switches Google language settings, 2 right to open inquiry Microsoft translator, 3 Fixed UAC environment can not handle the problem
· Fix: other minor fixes and optimization contains many updates ... and other cumulative processing
Row editing ( Data Editor ):
· Upd: ( Cell Editor ) when open or import BLOB content can not view will switch to HEX mode display
· Upd: refresh or update the Filter, you can maintain the original position (column)
· Upd: When no primary Key and field with a default value, [New added] sync refresh the display after the default, to avoid the moment can not update or delete the question
· Fix: [New added] when the field is of type bit (Boolean) input in the absence of default under the False
· Fix: (Access / dBase) correction field of type bit (Boolean) When no primary Key and can not update or delete the question
· Upd: (SQLAzure / SQL Server) updated the script editor to generate the INSERT, the date field to a common format (YMD) ( Unseparated String Format ), in order to adapt to different environments
SQL Performance Analyzer ( SQL Profiler ):
· Upd: Log Mode integrated Query Tab , the convenience query execution performance and History
· Upd: Log Mode implementation record under the accession Parse Only
SQL Editor ( SQL Editor ):
· Upd: Improved search function (Find): search shortcut key F3 to switch to a different page in the editorial content to continue to search processing
August 12th, 2011· Upd: refresh or update the Filter, you can maintain the original position (column)
· Upd: When no primary Key and field with a default value, [New added] sync refresh the display after the default, to avoid the moment can not update or delete the question
· Fix: [New added] when the field is of type bit (Boolean) input in the absence of default under the False
· Fix: (Access / dBase) correction field of type bit (Boolean) When no primary Key and can not update or delete the question
· Upd: (SQLAzure / SQL Server) updated the script editor to generate the INSERT, the date field to a common format (YMD) ( Unseparated String Format ), in order to adapt to different environments
Main program updates ( Main ):
· Upd: (MySQL) As Out of sync with server , therefore, to temporarily return to older components MySql.Data.dll 6.4.3 -> 6.3.7
· Add: Added French interface language French language
· Upd: Update customized language editing ( Custom Language Editor ): 1. language list, select or create a Google automatically switch the language settings match, 2 additional right-click menu on Microsoft Language Portal translation options
· Fix: other minor fixes and optimization contains many updates. They accumulate processing
August 6th, 2011· Upd: integration of the list of connections ( Connection List ) connection with the recent record (Recent Connections): specifies the database connection record of the last 15 pen
· Add: (Oracle/DB2/MySQL) increase FUNCTIONS database information browse / create / delete / display DDL and other related functions
· Upd: (DB2) update PROCEDURES display and amend the related issues
· Upd: (OData) update the connection exception when the connection URL is invalid or can not be normal connection
· Fix: (SQL Server/MySQL/DB2) Amendment (4225) led to the SQL command (GO) lost the role of the batch
· Fix: When the object name with a solution "(", the name will get affected by incorrect operation of related issues switching up and down the page StackOverflowException of exceptions
· Add: Objects Expand / Collapse (Expand / Collapse Objects): add shortcut keys Ctrl + Right
· Add: (Access) database to increase PROCEDURES message view / create / delete / display DDL and other related functions
· Upd: (MySQL) update backup program (mysqldump.exe) since the latest version of MySQL 5.5.15 (2011/07/28)
· Add: (MySQL) database to increase Procedure Parameters message is displayed
· Upd: (MySQL) update the default connection string, instead of the original use procedure bodies to check parameters parameter
· Fix: (PostgreSQL) because of the associated correction FUNCTIONS DDL changes lead to the original display and delete functions lost the role of the
· Fix: (Oracle) correction SEQUENCES because the original object-related changes lead to loss of the role of the show
· Fix: (Oracle) amend the index editor ( Index Editor ), due to changes in lead-related problems can not be displayed
· Upd: update the Export to XLS Format, support OpenOffice.Org / LibreOffice , MSOffice is not installed automatically when switching call processing
· Upd: Update Paste from HTML Format, support OpenOffice.Org / LibreOffice , MSOffice is not installed automatically when switching call processing
· Fix: (SQL Server) to load the database AttachDbFilename correct way through, the problems related to the path set by "\" generated an exception problem
· Upd: (SQLCe) address through third-party tools if the upgrade version of the database and the database name and path are the same, will result in a record with the original set of different problems can not be re-opened
· Fix: other minor fixes and optimization contains many updates, they accumulate processing
SQL Performance Analyzer ( SQL Profiler ):
· Fix: (MySQL) correction Session Mode records exist Error Log Mode (4226)
· Upd: When the Global Mode is not supported by the database itself (such as: MSDE, SQL Server "Denali" Express database, etc.), automatically switch to the Log Mode
Row editing ( Data Editor ):
· Fix: correction result in the status bar message update or delete rows automatically refresh after a batch update, an exception or failure of issue
· Fix: correct column type bit (Boolean), and existing data to NULL, when no primary Key can not update or delete the question
SQL Editor ( SQL Editor ):
· Upd: auto-complete optimization process: 1. If QuotedString in 'xx' blank save after inserting text processing, (2) Click on Space inserted to avoid the line and back
· Upd: Automatic optimization of object-aware processing ( IntelliSense ): 1. QuotedString increase awareness processing, (2) when the start character contains QuotedString automatically added when you insert the end of character
· Fix: correction line after auto-complete feature can not properly handle the issue ( AutoComplete ) (*)
· Add: SQL Formatting plug-in : Download the command-line Utility ' SqlFormatter.xxxzip 'and Put' SqlFormatter.exe 'in the same Directory as' Database3.exe
July 27th, 2011· Fix: When the object name with a solution "(", the name will get affected by incorrect operation of related issues
· Fix: avoid browser quickly and when a row is a result of continuous switching up and down the page StackOverflowException of exceptions
· Add: Objects Expand / Collapse (Expand / Collapse Objects): add shortcut keys Ctrl + Right
· Add: (Access) database to increase PROCEDURES message view / create / delete / display DDL and other related functions
· Add: (MySQL) database to increase FUNCTIONS message view / create / delete / display DDL and other related functions
· Add: (MySQL) database to increase Procedure Parameters message is displayed
· Upd: (MySQL) update the default connection string, instead of the original use procedure bodies to check parameters parameter
· Fix: (PostgreSQL) because of the associated correction FUNCTIONS DDL changes lead to the original display and delete functions lost the role of the
· Fix: (Oracle) correction SEQUENCES because the original object-related changes lead to loss of the role of the show
· Fix: (Oracle) amend the index editor ( Index Editor ), due to changes in lead-related problems can not be displayed
· Upd: update the Export to XLS Format, support OpenOffice.Org / LibreOffice , MSOffice is not installed automatically when switching call processing
· Upd: Update Paste from HTML Format, support OpenOffice.Org / LibreOffice , MSOffice is not installed automatically when switching call processing
· Fix: (SQL Server) to load the database AttachDbFilename correct way through, the problems related to the path set by "\" generated an exception problem
· Upd: (SQLCe) address through third-party tools if the upgrade version of the database and the database name and path are the same, will result in a record with the original set of different problems can not be re-opened
· Fix: other minor fixes and optimization contains many updates ... they accumulate processing
SQL Performance Analyzer ( SQL Profiler ):
· Upd: When the Global Mode is not supported by the database itself (such as: MSDE, SQL Server "Denali" Express database, etc.), automatically switch to the Log Mode
Row editing ( Data Editor ):
· Fix: correction result in the status bar message update or delete rows automatically refresh after a batch update, an exception or failure of issue
· Fix: correct column type bit (Boolean), and existing data to NULL, when no primary Key can not update or delete the question
SQL Editor ( SQL Editor ):
· Fix: correction line after auto-complete feature can not properly handle the issue ( AutoComplete )
· Upd: Automatic optimization of object-aware processing ( IntelliSense ): 1. QuotedString increase awareness processing, (2) when the start character contains QuotedString automatically added when you insert the end of character
July 20th, 2011Main program updates (Main):
· Upd: update the Export to XLS Format, support OpenOffice.Org / LibreOffice , MSOffice is not installed automatically when switching call processing
· Upd: Update Paste from HTML Format, support OpenOffice.Org / LibreOffice , MSOffice is not installed automatically when switching call processing
· Fix: (SQL Server) to load the database AttachDbFilename correct way through, the problems related to the path set by "\" generated an exception problem
· Fix: other minor fixes and optimization contains many updates ... they accumulate processing
Row editing (Data Editor):
· Fix: correction (4206) result in the status bar message update or delete rows automatically refresh after a batch update, an exception or failure of issue
July 8th, 2011· Add row text search ( Find In Grid )
· Can for the browser (Browse) and edit (Edit) to search the contents of the selected data processing, dramatically reducing editing time to find the selected output
· Shortcut Keys: Find Next (F3) / Find Previous (Shift + F3) / Find All (Ctrl + E)
· New Database Object Search ( Search Objects ) (*)
· For database objects can be (TABLES / VIEWS / PROCEDUREC / FUNCTIONS / SEQUENCES) and other search deal
· Shortcut Keys: Search (Ctrl + E)
SQL Editor ( SQL Editor ):
· Upd: Improved search and replace function ( Find / Replace ): support for different page editorial content search process, search for a different editorial content without having to shut down again after the restart search (4206)
· Upd: Update auto-complete feature ( AutoComplete ): breakdown of the different database objects icon
Connection Settings ( Connection Profile ):
· Upd: (Oracle) improving user experience, when the Oracle Instant Client settings change automatically restart when the increase in query processing, to avoid not work
· Fix: correct connection settings to add and delete Profile and other related issues
Main program updates ( Main ):
· Upd: browser (Browse) and edit (Edit), provide a more intuitive and complete status bar ( Status ) message shown
· Upd: (MySQL) update backup program (mysqldump.exe) since the latest version of MySQL 5.5.14
· Upd: (MySQL) to update components MySql.Data.dll 6.4.3
· Upd: (SQLite) to update components System.Data.SQLite.dll 1.0.74.0 (3.7.7.1)
· Add: (MySQL / SQL Server) to increase display all database functions ( List All Databases ): When the connection settings do not specify a database, the connection will open the database while eliminating the need to switch processing
· Upd: (SQL Server / SQL Azure) object browser supports full SCHEMA display and sort by group processing
· Upd: (PostgreSQL / IBM DB2) to improve refresh processing: where SCHEMA only for individual objects under the refresh, to improve processing speed
· Fix: (ODBC / OLEDB) amended (4.9.4183) if the connection when the database does not support exception handling PROCEDURES
· Fix: other minor fixes and optimization contains many updates ... they accumulate processing
Row editing ( Data Editor ):
· Fix: correction copy function (Copy) Cell content is NULL when the same browser to copy the text NULL output processing
· Upd: updated batch import feature ( Import ): 1. the type of treatment for different fields, the main Key and non-text type field will be omitted when the batch import process, (2) increase the shortcut key (Ctrl + I) (4199 )
· Fix: correction by ( Cell Editor ) Import BLOB file, the field is not NULL display synchronized to System.Byte [] the issue
Code Management ( Code Manager ):
· Add: Add the given category search process ( Classes ): can narrow your search to find the speed to accelerate income
Table edit ( Table Editor ):
· Fix: (MySQL) table amendments do not specify a Schema editing problems.
July 5th, 2011· Upd: (SQLite) to update components System.Data.SQLite.dll 1.0.74.0 (3.7.7.1) (2011/07/04)
· Upd: (MySQL) to update components MySql.Data.dll 6.4.3 (2011/07/04)
· Upd: Update auto-complete feature ( AutoComplete ): breakdown of the different database objects icon
· Add: (MySQL / SQL Server) to increase display all database functions ( List All Databases ): When the connection settings do not specify a database, the connection will open the database while eliminating the need to switch processing
· Fix: correct connection settings to add and delete Profile and other related issues
· Upd: (SQL Server / SQL Azure) object browser supports full SCHEMA display and sort by group processing
· Upd: (PostgreSQL / IBM DB2) to improve refresh processing: where SCHEMA only for individual objects under the refresh, to improve processing speed
· Fix: (ODBC / OLEDB) amended (4.9.4183) if the connection when the database does not support exception handling PROCEDURES
· Fix: other minor fixes and optimization contains many updates ... they accumulate processing
Code Management ( Code Manager ):
· Add: Add the given category search process ( Classes ): can narrow your search to find the speed to accelerate income
Row editing ( Data Editor ):
· Upd: updated batch import feature ( Import ): 1. the type of treatment for different fields, the main Key and non-text type field will be omitted when the batch import process, (2) increase the shortcut key (Ctrl + I)
· Fix: correction by ( Cell Editor ) Import BLOB file, the field is not NULL display synchronized to System.Byte [] the issue
Table edit ( Table Editor ):
· Fix: (MySQL) table amendments do not specify a Schema editing problems
July 1st, 2011Code Management ( Code Manager ):
· Add: Add the given category search process ( Classes ): can narrow your search to find the speed to accelerate income
Row editing ( Data Editor ):
· Upd: updated batch import feature ( Import ): 1. the type of treatment for different fields, the main Key and non-text type field will be omitted when the batch import process, (2) increase the shortcut key (Ctrl + I) (4199 )
· Fix: correction by ( Cell Editor ) Import BLOB file, the field is not NULL display synchronized to System.Byte [] the issue
Table edit ( Table Editor ):
· Fix: (MySQL) table amendments do not specify a Schema editing problems
Main program updates ( Main ):
· Upd: (MySQL) to update components MySql.Data.dll 6.4.2 (2011/06/29)
· Upd: Update auto-complete feature ( AutoComplete ): breakdown of the different database objects icon
· Add: Connection settings added ( Run as a Different user ): Apart from the command line (Command-line: runas ) approaches, can be more easily handled directly through the interface settings
· Add: (MySQL / SQL Server) to increase display all database functions ( List All Databases ): When the connection settings do not specify a database, the connection will open the database while eliminating the need to switch processing
· Fix: correct connection settings to add and delete Profile and other related issues
· Upd: (SQL Server / SQL Azure) object browser supports full SCHEMA display and sort by group processing
· Upd: (PostgreSQL / IBM DB2) to improve refresh processing: where SCHEMA only for individual objects under the refresh, to improve processing speed
· Fix: (ODBC / OLEDB) amended (4.9.4183) if the connection when the database does not support exception handling PROCEDURES
· Fix: other minor fixes and optimization contains many updates. They accumulate processing
June 22nd, 2011· Add: Connection settings added ( Run as a Different user ): Apart from the command line (Command-line: runas ) approaches, can be more easily handled directly through the interface settings (4190)
· Add: (MySQL / SQL Server) to increase display all database functions ( List All Databases ): When the connection settings do not specify a database, the connection will open the database while eliminating the need to switch processing (4190)
· Fix: correct connection settings to add and delete Profile and other related issues (4190)
· Upd: (SQL Server / SQL Azure) object browser supports full SCHEMA display and sort by group processing (4190)
· Upd: (PostgreSQL / IBM DB2) to improve refresh processing: where SCHEMA only for individual objects under the refresh, to improve processing speed (4190)
· Fix: (ODBC / OLEDB) amended (4.9.4183) if the connection when the database does not support exception handling PROCEDURES (4190)
· Fix: other minor fixes and optimization contains many updates ... they accumulate processing (4190)
June 15th, 2011Main program updates (Main):
· Add: (Firebird) Add FUNCTIONS collection of information: including display, delete, update, DDL and other functions dealing with the content ... (4183)
· Add: (ODBC / OLEDB) increase in the object browser and delete functions PROCEDURES (4183)
· Upd: (ODBC / OLEDB) update VIEWS object browsing, support for the specified SCHEMA NAME display processing (4183)
· Upd: (ODBC / OLEDB) increased SCHEMA NAME, DATABASE NAME-related processing and display (4183)
· Upd: (PostgreSQL / IBM DB2) update re-brush treatment, under the weight in the specified brush SCHEMA all objects, is no longer handle all the erasing SCHEMA (4183)
· Upd: (Excel / dBase) table editing and browsing support for Edit / Open (TOP 500 rows) treatment (4183)
· Upd: (Excel) 1. Clear the data type is not supported, 2. The object browser shows only the tables with a $ character to avoid repeated, 3. Key table editor to remove the setting (4183)
· Add: Update Generate Scripts output to FILE Disposition: Add HTML format (*. htm) output format (4183)
· Upd: Update Generate Scripts output to FILE Disposition: support for all built-in output formats CSV / XML / TXT / XLS / SQL / HTM (4183)
· Upd: Update Generate Scripts output to FILE Disposition: change to direct output (with Results to File) to reduce memory usage (4183)
· Upd: updated results to the file (Results to File) approach (4183)
· Add: Add Russian interface language Russian language (4176)
· Fix: Fixed Query (x) * Undo restored if entirely due to differences still lead the title Windows -> Query (x) repeated the question (4176)
· Upd: the main station with firebirdsql.org revision and update multiple reference document links (4176)
· Upd: (MySQL) to join charset = utf8 as the default connection string (4176)
· Upd: (MySQL) update components MySql.Data.dll 6.4.1 (2011/06/06) (4176)
· Upd: (Firebird) update components FirebirdSql.Data.FirebirdClient.dll 2.6.5 (2011/06/03) (4176)
· Upd: (SQLite) update components System.Data.SQLite.DLL 1.0.73.0 (3.7.6.3) (2011/06/02) (4176)
· Fix: Various other small fixes and includes optimization of the cumulative update ... and other processing (4183)
Table editing functions (Table Editor):
· Fix: Fixed can not add fields after the [immediately] to delete the field in question (4183)
Row editing functions (Data Editor):
· Upd: (SQL Server / SQL Azure) support Microsoft.SqlServer.Types.Sql [xxxx] to delete the row when no Key Processing (4183)
· Upd: Support SByte (TinyInt), System.Net.IPAddress data type processing (including script generated (Scripts)) (4176)
· Upd: (PostgreSQL) support BitString, Geometric Types (Box, Circle, Path, LSeg, Point, Polygon) data type processing (including script generated (Scripts)) (4176)
· Upd: (Oracle) modify the Long data type by default does not show the problem (4176)
· Fix: Fixed in the new additional failure Cancel (Escape), still have an empty row of the problem (4176)
· Fix: Fixed (4.8.4167) Enum handling of NULL string data type (4176)
June 15th, 2011Row editing functions (Data Editor):
· Upd: Support Object (Sql_Variant), Byte (TinyInt), Time (TimeSpan), DateTimeOffset data type processing (including script generated (Scripts)) (4167)
· Upd: (SQL Server / SQL Azure) support the Geography / Geometry / Hierarchyid data type processing (including script generated (Scripts)) (4167)
· Fix: Fixed error when saving if and where the first column of the exception handling (4167)
· Upd: Improved row row when editing open display processing speed (4167)
· Fix: Fixed Cell [edit mode] Click Del to delete row shortcut keys with the problem of conflict (4160)
Table editing functions (Table Editor):
· Upd: Support delete duplicate Column (Delete duplicate rows): When the delete column contains duplicate columns, you can choose whether to delete or cancel processing (4160)
· Upd: add row, the support column with a default attribute handling (Default Value) (4143.1)
The main program updates (Main):
· Upd: Update Italian interface language Italian language (by Paolo Saudin) (4167)
· Upd: When replacing the font happens Only TrueType fonts are supported. This is not a TrueType font. When asked to increase again, to avoid the exception message (4167)
· Upd: View all WinForm display problem for different DPI Update (4167)
· Upd: (MySQL) update the backup program (mysqldump.exe) the latest version from the MySQL 5.5.13 (2011/05/13) (4167)
· Add: (Access) to increase the support of Link Tables (4160)
· Add: [drop and command-line] to open the database supports auto-detection processing (Auto-Detect file format: Access / Firebird / Excel / SQLite / SQLCe (*.*)), no matter what the file extension (4150)
· Fix: (FB / SQLCe / SQLite) database before and after the closure of open empty password string, to avoid the effects associated with operation processing (4150)
· Fix: (SQLCe) revised set the password is empty can not handle the problem (4150)
· Fix: (SQLCe) Fixed Ver 3.1 can not set the password problem (4150)
· Upd: (SQLCe) new database (Create Database) increase in encryption mode selection Encryption Mode = (Platform Default / Engine Default) (4150)
· Upd: (SQLCe) update when the re-set the password (Protect Database) to maintain the original after encryption mode Encryption Mode = (Platform Default / Engine Default) (4150)
· Upd: (SQLCe) to add more property pages Ver 3.5/4.0 database related information (Database properties) (4150)
· Upd: (MySQL / PostgreSQL) connection when using Windows authentication mode: 1. The database backup and restore will be disabled, 2. Script processing to create the built model (4150)
· Upd: (MySQL) update the backup program (mysqldump.exe) the latest version from the MySQL 5.5.12 (2011/05/05) (4150)
· Upd: (SQLite) updated to remove reference to non-data Message Data Types and Non Integer types when IsAutoIncrementable autoincrement attribute (of the table contains the editor) (4150)
· Upd: (OData) update the reference information does not belong to OData Reserved Words remove part (of auto-complete and syntax highlighting included) (4150)
· Upd: Update auto-complete feature (AutoComplete): Support OData $ prefix Processing (4150)
· Upd: optimization package deal, reducing the program about the size of the compressed-700KB (4150)
· Upd: Improved generated INSERT script (Generate INSERT statement scripts): Updated date and type of the output value of processing (4150)
· Fix: Various other small fixes and includes optimization of the cumulative update ... and other processing (4160)
· Upd: Support for Visual Studio IDE: (4150)
May 13th, 2011The main program updates:
· Add: [drop and command-line] to open the database supports auto-detection processing (Auto-Detect file format: Access / Firebird / Excel / SQLite / SQLCe (*.*)), no matter what the file extension
· Fix: (FB / SQLCe / SQLite) database before and after the closure of open empty password string, to avoid the effects associated with operation processing
· Fix: (SQLCe) revised set the password is empty can not handle the problem
· Fix: (SQLCe) Fixed Ver 3.1 can not set the password problem
· Upd: (SQLCe) new database ( Create Database ) increase in encryption mode selection Encryption Mode = (Platform Default / Engine Default)
· Upd: (SQLCe) update when the re-set the password ( Protect Database ) to maintain the original after encryption mode Encryption Mode = (Platform Default / Engine Default)
· Upd: (SQLCe) to add more property pages Ver 3.5/4.0 database related information (Database properties)
· Upd: (MySQL / PostgreSQL) connection when using Windows authentication mode: 1. The database backup and restore will be disabled, 2. Script processing to create the built model
· Upd: (MySQL) update the backup program (mysqldump.exe) since the latest version of MySQL 5.5.12 (2011/05/05)
· Upd: (SQLite) updated to remove reference to non-data Message Data Types and Non Integer types when IsAutoIncrementable autoincrement attribute (of the table contains the editor)
· Upd: (OData) update the reference information does not belong to OData Reserved Words remove part (of auto-complete and syntax highlighting included)
· Upd: Update auto-complete feature ( AutoComplete ): Support OData $ prefix Processing
· Upd: optimization of packaging, decreases the program about the size of the compressed-700KB
· Upd: Improved generated INSERT script ( Generate INSERT Statement scripts ): Updated date and type of the output value of processing
· Fix: Various other small fixes and includes optimization of the cumulative update ... and other processing
May 7th, 2011· New Connection Manager (Connection Manager)
· Support the specified database type display
· Support the last access time display
· Support the re-naming deal
· Different from the [recent] Connection list limit of 30 pen, there is no limit the number of Connection Manager, but still beyond the older parts of the distinction between gray display
· Upd: (Access) support the update process Default Value
The main program updates:
· Upd: Update table DDL syntax to generate: When not included in the INDEX, the increase CONSTRAINT x UNIQUE x syntax display
· Fix: (SQLCe) correction table properties page ( TABLE Properties ) can not open the browser issues DDL
· Upd: (MySQL / SQLAzure / SQL Server) updated the index generates DDL syntax: cancel remove the presence of grammar, syntax displays only the establishment
· Upd: (SQLite) update components System.Data.SQLite.DLL 1.0.72.0 (3.7.6 +) (2011/05/01)
· Upd: (IBM DB2) update components IBM.Data.DB2 9.7.4.2 (2011/04/05)
May 2nd, 2011Table editing functions (Table Editor):
· Add: (Access / MySQL / PostgreSQL / Oracle / SQLCe / SQLAzure / SQL Server / IBM DB2) to support changes to the existing form fields null state (Modify NULL State)
· Fix: (Oracle) modified timestamp data type field length of the display problems
Index editing (Index Editor):
· Upd: Index Property Page ( INDEX Properties ) update the DDL syntax is generated automatically if the students belong to a PRIMARY KEY CONSTRAINT syntax
· Upd: To update and amend the index to the state, when the transaction when the Primary Key
· Fix: (Access / dBase / PostgreSQL / ODBC) Fix the index DDL syntax is generated within the property page is not the right questions
The main program updates (Main):
· Upd: (MySQL / PostgreSQL) database connection management support Windows authentication connection mode
· Upd: (MySQL) update components MySql.Data.dll 6.4.0 (2011/04/22)
· Upd: Table property page ( TABLE Properties ) update the DDL syntax generation, integration of data tables and indexes (TABLE + INDEXES) Full DDL syntax
· Fix: Fixed field type when the length of the tree as the default null value and return will be omitted when the handle, to avoid exceptions (eg: Oracle NUMBER default return empty)
· Fix: (Oracle) Fixed (4.6) lead to the original tree after the merge modules column NOT NULL message is not displayed correctly in the problem
· Upd: Improved search and replace feature ( Find / Replace ): regular expression (Regular Expression) to support multi-line (Multiline) treatment
· Fix: Second amendment (ibid.), when to switch between different tables and then return (of including: Access/OleDB/Odbc/DB2/PostgreSQL/Firebird/SQLCe)
· Fix: Various other small fixes and includes optimization of the cumulative update ... and other processing
April 26th, 2011The main program updates (Main):
· Fix: Fixed table node if [not to start before the] open the property page, the generated content will not include DDL Primary Key issues (impact includes: Access/OleDB/Odbc/DB2/PostgreSQL/Firebird/SQLCe)
· Upd: Update auto-complete feature ( AutoComplete ) in the open state, if the shortcut keys to perform other functions will automatically shut down to avoid conflict
· Upd: Update via [File] Open the query tab, increase the full path to the prompt message is displayed ( Tip Text )
April 22nd, 2011· Fix: Fixed editing status is not updated under the AutoIncremental display issues
· Fix: (Firebird) Fixed length char data type field does not display the problem
· Fix: (DB2) modified dbclob and graphic data type field length of the display problems
· Fix: (Oracle) modified nchar data type and field length nvarchar2 display problems
· Fix: (Oracle) data type definition error correction Provider problems TIMESTAMP ({0} WITH xxx) -> TIMESTAMP ({0}) WITH xxx
· Fix: (MySQL) to address and support enum data types can not be defined with the set of issues
· Fix: (MySQL) amended the definition of Provider data types the wrong question (TINY INT UNSIGNED-> TINYINT UNSIGNED)
· Upd: (PostgreSQL) to modify the definition of data_type field change to take udt_name name, data type is more consistent with the Provider
· Fix: (PostgreSQL) amended the definition of Provider data types the wrong question (Double-> Double Precision)
· Upd: (Firebird) support the Embedded version of the table properties page (TABLE Properties) DDL generation process
· Upd: Update part of the database field length of the show, when the length is omitted, the default size display processing
· Fix: Various other minor fixes included, the interface language and optimization for updates ... they accumulate Processing
April 19th, 2011Row editing functions (Data Editor):
· Add: Add batch import feature ( Import ): can be batch imported from the Clipboard, or CSV (Comma delimited) (*. csv) text format for processing
The main program updates (Main):
· Add: (Access) to increase Access MDE Database (*. mde), ACCDE Access Database ( *. accde ) database format support
· Add: (Access) Add Make MDE / ACCDE database (*. mde / *. accde) database format (Tools-> Make MDE / ACCDE)
· Upd: (PostgreSQL) update PostgreSQL 9.0.4 (2011/04/18)
· Fix: (PostgreSQL) Fixed (4.5) set to change due to Npgsql.dll 2.0.11.91 part of it, leading to backup / restore, and part of the DDL generation useless issues
· Fix: (MySQL) Fixed (4.5) if the implementation of the SQL syntax that caused the error, the program will be repeated again addressed
· Upd: Update Italian interface language Italian language (Updated) (by Paolo Saudin)
April 11th, 2011· Add: Add function to reproduce row (Duplicate a Row): can copy the current as a new column, repeat the input time can be saved to speed up the rate of new editorial column (4117)
· Add: Support update repeat Column (Alter duplicate rows): When the update column contains duplicate columns, you can choose whether to update or cancel processing (4117)
· Upd: BOOLEAN column type and data content to NULL, will distinguish between the background color display (4117)
· Fix: BOOLEAN column type is added to support the new default is NULL and the treatment time (4117)
· Upd: (MySQL) update the backup program (mysqldump.exe) since the latest version of MySQL 5.5.11 (2011/04/07) (4117)
· Fix: other minor fixes and optimization contains updated cumulative processing (4117)
April 5th, 2011Row editing functions ( Data Editor ):
· Add: Add BLOB viewer / update and export feature ( View, Update and Export BLOB ): you can easily browse, update, save BLOB fields of information about the content, support for all database
· Upd: data field is set to null value handling (Set Cell as NULL): to support Byte () data type processing
· Fix: Fixed update fields with the treatment of type GUID
The main program updates ( Main ):
· Add: (ODBC / OleDB) Add (table editing / Index Editor) treatment ( Table Editor / Index Editor )
· Upd: (ODBC) database index tree increases UNIQUE / NON-UNIQUE message is displayed
March 21st, 2011The main program updates ( Main ):
· Add: Add transaction mode ( Transaction Mode ): in the implementation of the contents of the database after the approval (Commit) or reply (Rollback)
· Example illustrates the increase and the LIKE wildcard filtering (Wildcard characters: * Zero or more characters,? Any single character, # Any single digit (0-9))
· Fix: other minor fixes and optimization contains updated cumulative processing
March 15th, 2011Table editing functions ( Table Editor ):
· Upd: (Access / Firebird / MySQL / PostgreSQL / Oracle / SQLCe / SQLAzure / SQL Server / IBM DB2) to support changes to the existing form field type and field length ( Modify DataType and Length )
· Upd: (MySQL) support to change existing table AUTO_INCREMENT column attribute
· Upd: (MySQL) the default text type field will no longer display single quotes''
The main program updates ( Main ):
· Add: (MySQL / PostgreSQL / Oracle / SQLAzure / SQL Server / IBM DB2) new database object filtering, can be developed to reduce the database to include or exclude objects displayed ( Include or exclude objects )
· Upd: Password Zhangduoxianzhi to increase the original 24 to 64 characters long to avoid the problems can not enter the password
· Upd: (MySQL) tree field contains the unsigned numeric type text message displayed
· Upd: (MySQL) CREATE PROCEDURE create templates updated
· Fix: (PostgreSQL) amendment does not load the database in case of connection, and then open the context menu problem when an exception message
· Fix: other minor fixes and optimization contains updated cumulative processing
March 3rd, 2011· Add: (SQL Server / Oracle / IBM DB2) Add Server examples features ( Browse for servers ) (4079)
· Upd: (SQL Server) update backup and restore the database approach ( Backup / Restore DB ) (4079)
· Upd: (SQL Server) to rewrite and revision of the relevant code, completely replace the SQL Server Management Objects related components approach, the program significantly reduced package size (> 2MB) (4079)
· Upd: update database property page (Database Properties) relevant information and (DDL) content (4079)
· Increase the list of command line help (Help) database3.exe /? (4079)
· Fix: other minor fixes and optimization contains updated cumulative processing (4079)
February 22nd, 2011· Add: Support command line processing (Command-line)
· DB type: Access / Excel / dBASE = 0, Firebird = 3, MySQL = 4, SQLServer = 5, SQLAzure = 6, SQLCe = 7, SQLite = 8, PostgreSQL = 9, Oracle = 10, OleDB = 11, Odbc = 12 , OData = 13, DB2 = 14
· DB type + : eg 1. Database3.exe "c: \ 1.mdb", 2. Database3.exe 0 "c: \ 1.mdb", 3. Database3.exe 5 codelib
· Add: Open the program to increase password protection to prevent others from using ( Password protect access to Database. NET )
· Upd: (SQLCe) v3.1/3.5 table editing and generate DDL, increasing the length of format data type handling (varbinary ({0}), binary ({0}), nvarchar ({0}), nchar ({0 }), numeric ({0}, {1}))
· Fix: (SQLCe) Fix upgrade database function, not synchronized to refresh SQL Cenkaoziliao result does not correctly handle some issues
· Fix: (SQLCe / Oracle / PostgreSQL) table script fields in order to establish if more than 10 time scheduling problem
· Fix: Fixed in the next row editing font settings if the change will have exceptional problem
February 18th, 2011Row editing functions ( Data Editor ):
· Upd: support multi-line edit fields and display the content ( Multi-Line Text )
· Add: Shortcut key to move to the new increase in column (Move to new row: Shortcut Keys: Ctrl + N)
· Upd: Digital type field is automatically set to NULL if emptied Processing
· Upd: When the switch is set to update the row editing To edit the main menu to state
The main program updates ( Main ):
· Upd: (OleDB) a complete database system to support different sources of information in the name of the table field type (TypeName) Message Display
· Fix: auto-complete feature ( AutoComplete ): amendments to certain conditions quickly enter the space bar + other characters have a problem
· Add: table editing features ( Table Editor ): increase the access key field (Insert Column: Shortcut Keys: Ctrl + N)
February 10th, 2011· Upd: (SQLCe) update the default connection parameters Max Database Size = 4091; Max Buffer Size = 1024; (4,058.1)
February 10th, 2011The main program updates ( Main ):
· Add: Add SQL Performance Analyzer ( SQL Profiler ): You can use SQL Profiler to monitor, analyze or save each record and used to improve the optimization of procedures
· Fix: Fixed export format by default split character (Delimiter) Tab but actually is; character of the error
· Fix: Fixed Editor Tab to toggle between the different databases, if the title name is not subsequently update with
· Fix: Fixed the same time open more than one Database. NET program, close the issues that may arise after the treatment
· Add: Add a complete set projects editor ( Editor Settings ): the same program controls inherit the same settings editor
· Upd: (MySQL) update the backup program (mysqldump.exe) the latest version from MySQL 5.5.9 (2011/01/19)
February 7th, 2011Row editing functions ( Data Editor ):
· Upd: Support NULL display in edit mode (with the browse mode)
· Upd: editing and browsing DateTime field, display the full format (yyyy-MM-dd HH: mm: ss), to address related issues
The main program updates ( Main ):
· Add: Message node integrate the database reference website resources ( Integrates Referenced URL ), without memory or take the time to find and make more easy and rapid development
· Fix: (MySQL / PostgreSQL / SQL Server) correction [first start] and [cut and link different sources], the duplicate database update problem
· Upd: (MySQL / PostgreSQL / Oracle) Connection management support for the database name without the connection handle, (SQL Server) without the database name automatically switch to the default Master
· Upd: Update CREATE (TRIGGER / SEQUENCE) to establish grammatical patterns, different for different database syntax to provide individual-specific templates
· Upd: (PostgreSQL) update PostgreSQL 9.0.3 (2011/01/31)
· Upd: update a database service management ( Service Manager ): increase the failure to restore the state and displays an error message
January 28th, 2011Row editing functions ( Data Editor ):
· Add: Support for setting a null value data field processing (Set Cell as NULL: Shortcut Keys: Ctrl +0) (4044)
· Upd: DateTime column shows the full format (yyyy-MM-dd HH: mm: ss), to address related issues (4044)
· Upd: different countries, the decimal notation decimal update processing (4044)
· Fix: Add ROW if failed, re-amended the problem can not be added after (4044)
· Fix: allow NULL, but not the text type field update process (4044)
· Fix: (Access) amended and deleted without Key editing DateTime fields can not handle the problem (4044)
· Upd: add the same record row to delete detection (with update) (4044)
· Upd: increase SQLite database browsing and editing of exceptions, when the data contains an incorrect value of the field and include the error message is still displayed (4044)
· Fix: Fixed occasional cursor after the completion of the problems the state is not restored (4044)
January 17th, 2011· Add: Configuration file path to increase the portability mode ( Portable mode ), easy to move with the time when the designated position in the portable (eg: flash drive), even if the disk name change will not be affected
· Support the [Authorized Version] In portable mode, in different environments will not need to re-enter the record in the environment, to ensure the safety and convenience of use
· Upd: (SQLCe) update SQL Server Compact 4.0 components (4.0.8482.1) (2011/01/05) (x86) / (x64)
· Upd: Update optimization customized language editing features ( Custom Language Editor )
· Fix: other minor fixes and optimization update includes handling, more than one hundred
· Upd: right-click menu heavy brush finishing the current object name (refresh range) (Refresh [xxx]) to display in the ToolTip
· Fix: (PostgreSQL) FUNCTION property page updated to support the full DDL Display
· Fixed FUNCTIONS refresh (Refresh) changed its name to result in the loss due to the role of new issues
· Fix: Fixed the default font setting display problems
January 8th, 2011· Upd: update multiple user experience, including the enable state of the taskbar, menus and interface display more consistency and simplification
· Add: New version of automatic update detection ( Automated Update Checking )
· Fix: Fixed in the absence or closure Aero environment and the Auto-Hide Taskbar, the maximized window will result in blocking the Taskbar problem can not be displayed by the mouse
· Upd: (Oracle) replacement of components Oracle.DataAccess.dll 11.2.0.2.1 (2010/11/19), replace stop development of the System.Data.OracleClient
· The change has been ruled out pre-existing issues (including the Provider's own bug, and user experience), for access to Oracle database will also significantly increase the speed and Improvement
· Upd: (MySQL) rewritten to restore the database (*. sql) approach, and to increase the response to the error message
· Upd: (MySQL) update components MySql.Data.dll 6.3.6 (2011/01/02)
· Upd: (MySQL) update the backup program (mysqldump.exe) the latest version from MySQL 5.5.8 (2010/12/03)
· Upd: (Access / Excel) to improve the user experience, when not installed Access 2007 (or Higher) of the environment to read *. accdb / *. xlsx or create *. accdb file,
· Will automatically offer to download and install Access Database Engine of the message is displayed, regardless of operating environment is the x86/x64 are installed (x86) version
· Upd: (dBase) When reading the data table version and format can not handle (eg: External table is not in the expected format.),
· Will automatically offer to download and install Visual FoxPro ODBC Driver message displays, provide support through ODBC processing
· Fix: other minor fixes and optimization update includes handling, more than one hundred
Function text editor (Text Editor):
· Upd: Update the status bar ( StatusBar ) include: 1. The database type of display, 2. the implementation of the source data alert message, 3. connected with the offline color indicator
· Add: increase text editor, print the contents of processing
· Upd: strengthening the file encoding detection, the BOM / NOBOM / DEFAULT a more accurate treatment
Database message is displayed ( DB Information ):
· Upd: (ODBC / OLEDB) to increase INDEXES exceptions, to avoid opening the database itself does not support or other status
January 4th, 2011· Upd: optimization of the main interface, controls and icons, the program inherits the background color of window background color (when AERO is open)
· Upd: Password Changduoxianzhi original 14 to 24 characters long to avoid the problems can not enter the password
Upd: row editing ( Data Editor ):
· Upd: condition filter (Filter Expression) by adding an error message when the response to treatment
· Upd: Update supported way to delete a table row without Key Processing
· Fix: No Key correction table edit other fields as NULL when the issue
Upd: table editing features ( Table Editor ):
· Fix: (PostgreSQL/DB2) Fixed new table Schema is not specified, the problem
· Fix: (PostgreSQL) changed its name to the updating of field processing
Upd: update the database message is displayed (DB Information):
· Add: Right Menu Added table renamed processing, support includes: SQLite / SQLCe (3.1/3.5/4.0) / MySQL/PostgreSQL/Oracle/DB2/SQL Azure / SQL Server
· Add: right-click menu options to support new Process List contains: MySQL / PostgreSQL / Oracle / SQL Server
· Add: right-click menu options for integration of new database tools database features (Backup / Restore / Create / Shrink / Protect / Upgrade / ProcessList)
· Upd: right-click menu displays the current object name refresh (refresh range)
· Fix: (DB2) to resolve the name to avoid duplicate display issue PROCEDURES
· Fix: (PostgreSQL) Revision and update the index display processing
Upd: Update SQL editor features (SQL Editor):
· Upd: When the Open File or Paste Text to load the content, it is converted to a standard line (CRLF) format, the database part of the solution not the normal operation of the Provider (eg: SQLite Provider)
· Upd: updated file open the file encoding handling
· Upd: support for an external file drag and drop to the editor on
· Upd: Update auto-complete feature ( AutoComplete ): improve the user experience: 1. increase the icon display, 2. to support the mouse scroll wheel, 3. contains other minor updates
Upd: code management ( Code Manager ):
· Upd: directory location where the memory is turned on, can vary with different tabs to switch and avoid issues arising save
· Upd: updated when you double-click the name of the project Open search results display issues
December 26th, 2010· Supports dBase database index processing, 3. Fixed Access Table if the index can not be displayed without the original New Index Options (4012)
· Upd: 4. Tables and data processing line editing support for Auto Increment (4012)
· Fix: No Key correction table can not be updated when you edit NULL field problems (4012)
· Fix: Revision and update information form for the Boolean field is different from the database approach (4012)
· Upd: edit field will be NULL when NULL data text display (same visit) (4012)
· Fix: (SQLite) to establish and update the script editor row DateTime field data when the form is handled (4012)
· Upd: (PostgreSQL/DB2) Added support for Auto Increment row processing (4012)
Upd: table editing features ( Table Editor ):
· Upd: restore support for table editing Excel (4012)
· Upd: Update Save as HTML formatting, to avoid the selection / copying text Line number is the problem with the copy (4012)
· Upd: increase the default SqlKeywords to Syntax Highlight and AutoComplete, the supplementary part of the Provider itself the default ReservedWord problem of incomplete (eg DB2) (4012)
· Add: (SQL Server "Denali") Add SEQUENCES set of messages: contains display, delete, query processing and other functions ... (4012)
· Add: (Firebird/PostgreSQL/Oracle/DB2/SQL Server "Denali") increase the collection of information SEQUENCES heavy brush (Refresh) treatment (4012)
· Add: right-click menu by adding new CREATE VIEW, CREATE PROCEDURE, CREATE FUNCTION, CREATE SEQUENCE, CREATE TRIGGER and other simple functions like version of the establishment (4012)
· Upd: (dBase / Excel) revised and updated property page contains the DDL, the new menu and delete functions table (4012)
· Fix: other minor fixes and optimization update includes handling, more than one hundred (4012)
December 22nd, 2010· Upd: 1. To support the default update processing field, 2. Fixed default value added processing field, 3. Fixed install the Driver Package package caused the problem is not the problem can not start
· Upd: (PostgreSQL) update PostgreSQL 9.0.2 (2010/12/14)
December 18th, 2010· Add: Add IBM DB2 database management and support all existing functions, through the complex DB2 Database. NET is more simple processing (REQ: IBM Data Server Driver Package (25MB) )
· Upd: Database Service Manager ( Service Manager ): support for IBM DB2 (currently supported include Firebird / MySQL / PostgreSQL / SQL Server / SQL Server Express / Oracle Express / IBM DB2)
· Upd: (SQLCe) MRU memory to open the database version to omit the automatic detection processing when the next turn, but if the failure automatically switches to the automatic detection processing
· Upd: (MySQL) update MySQL 5.1.54 (2010/11/30)
· Upd: row editing ( Data Editor )
· Upd: simplified: When the tables no longer exist without Key can be directly edited manually specified
Upd: table editing features ( Table Editor ):
· Fix: (Oracle) correction data processing and display with a two-parameter form of the problem (such as: INTERVAL DAY {(0)} TO SECOND {(1)})
· Upd: (PostgreSQL) database to improve information re-brush treatment, only for heavy brush where the SCHEMA for processing
· Upd: (PostgreSQL) to the original CREATE DATABASE CREATE SCHEMA function
· Fix: (PostgreSQL) Fixed open the Schema property pages of certain names (eg public) caused no response of the
· Fix: other minor fixes and includes optimization of update processing
December 14th, 2010Upd: (SQLCe) supports SQL Server CE 3.1/3.5/4.0 different database version:
· Automatically detects open the database version
· Support the version of the database upgrade process (3.1-> 3.5-> 4.0)
· Support of new versions (3.1/3.5/4.0) database,
· Support the Table / Row / Index so edited, and contains all the other functions
· Fix: other minor fixes and includes optimization of update processing
December 13th, 2010· Add: Add index editing ( Index Editor ): support for all database system (Access / Firebird / MySQL / Oracle / PostgreSQL / SQLite / SQL Server / SQL Azure / SQLCe)
· Add: Add BLOB database fields to save to a file function ( BLOB Save as File )
· Upd: Table script edit mode ( Script Mode ): 1. supports syntax highlighting, 2. support the current database [create table] syntax reference links
· Upd: Update auto-complete feature ( AutoComplete ): improve the user experience: 1. when they lose focus, direct closure, 2. the selected text without processing
· Upd: Save and export the file path to add memory and other processing
Upd: to make the database message is displayed:
· Add: (SQL Azure / SQL Server) Add FUNCTIONS set of messages: contains display, delete, DDL and other functions dealing with the content ...
· Upd: (PostgreSQL) do not appear CHECK type CONSTRAINTS updated with pgAdmin
· Upd: (PostgreSQL) update INDEXES support Unique / Clustered message is displayed
· Upd: (SQL Azure) update INDEXES support Unique message is displayed
· Upd: the original database PROCEDURE / TRIGGER content display to open the DDL shown in the properties page, the distinction between the treatment and the establishment of implementation
· Fix: other minor fixes and includes optimization of update processing
December 6th, 2010Upd: Update SQL editing features:
· Upd: strengthening the code text search processing, through the shortcut key (Alt + F) opens directly to load [the cursor on the text] without the selected search speed up the processing (3990)
· Upd: Update auto-complete feature ( AutoComplete ): improving user experience, a more complete treatment-related issues (3990)
· Upd: Code Manager : 1. Update the search list display, 2. add Tooltips display the full path, 3. simplified context menu [new] features (3990)
· Upd: Database open the history list ( Recently used lists ): 1. add Lock / Unlock / Delete functions, 2. shortcut keys 1 to 9, an extension of the shortcut keys az, 3. recorded the largest increase in the list to 30 pen (3990)
· Lock) when the first list shows the lock and was not beyond the historical record is automatically deleted from time to time, (Unlock) again to resume the general list when clicked; (Delete) to delete when you can click to remove from the history list
· Upd: Customized Language editing features ( Custom Language Editor ): support for automatic translation Google Translate (3990)
· Fix: contains minor amendments and other relevant information updated and user experience (3990)
November 22nd, 2010· Add: new taskbar Results to Grid and Results to File the results of output options, the default is (to Grid) directly to the output display, (to File) directly to the output file (supports CSV / XML / TXT / XLS / SQL)
· Add: Work out the results of the output without additional Parse Only the implementation of processing
· Upd: When the row in edit mode, the taskbar automatically hide off function of non-treatment
· Upd: (Firebird) update components FirebirdSql.Data.FirebirdClient.dll 2.6.0 (2010/11/17), support for Unicode file name processing
· Upd: (Firebird) Cankaoziliao (Reference) the information adding Functions
· Upd: (MySQL) update MySQL 5.1.53 (2010/11/03)
November 15th, 2010· Upd: (SQL Server) the first to support SQL Server "Denali" 11.00.1103 (3969)
· Upd: (SQL Server) update component Microsoft SQL Server "Denali" Management Objects 11.00.1103 (3969)
· Upd: (Access) table editing features ( Table Editor ): increase the Auto Increment add and display processing (special support treatment) (3963.1)
· Upd: (Firebird / PostgreSQL / Oracle) to make the database message is displayed: increase SEQUENCES node [show] and right [here] and [erase] (3969)
· Upd: simplify the task bar integration [New / compression / protection] database and other functions to the context menu, display and operation will be more intuitive (3969)
· Upd: join. NET Framework version detection to avoid circumstances that do not support the implementation problems occurred that caused the exception (3969)
· Fix: (ODBC) x64 environment modified ODBC Data Source Administrator can not open the question (3963)
· Fix: (PostgreSQL / Oracle) amendment to switch to VIEWS / PROCEDURES node does not display addressed Schema (3969)
· Upd: (PostgreSQL) AutoComplete with Reference to join Reserved Words of support (3963)
· Upd: (PostgreSQL) update components Npgsql.dll 2.0.11 (2010/11/06) (3963)
· Upd: (MySQL) update MySQL 5.1.52 (2010/10/11) (3963)
· Fix: (SQLCe) amendment to end the database file if it does not reconnect after version upgrade issues (3963)
· Upd: (SQLCe) update SQL Server Compact 4.0 components CTP2 (4.0.8435.1) (x86) / (x64) (3963)
· Upd: (Oracle) update a database service management ( Service Manager ), support for Oracle Express Management (3969)
October 31st, 2010· Add: (v3) Added latest network database management functions ( OData (Open Data Protocol) and Microsoft Dallas Services ) (3956)
· Upd: improved auto-complete feature: 1. SQLKeywords outputs are converted to upper case, 2. Tables / Views / Procedures to join the list, 3. Optimize efficiency, 4. Improve the user experience problems (3956)
· Add: add way to manually specify Primary Keys, Primary Keys offers free information table row editing (3956)
· Upd: No Primary Keys support for Excel and existing data table row editing (3956)
· Upd: status bar by adding the name of Keys and Auto Increment field status display (3956)
· Upd: Add more exception handling, and add / delete a status update when the RowCount (3956)
Upd: table editing features ( Table Editor ):
· Add: Add dBase table editing features (3956)
· Add: (dBase) increase in right click menu to delete (Delete) function: Table (3956)
· Upd: Update simplified Chinese interface language Chinese Simplified language (contributed by Du Xiaojiang) (3956)
· Upd: (dBase) when browsing the database is not [ DOS 8.3 filename ] standard name, it will automatically open the box can be automatically asked for the proposed name change, such as manually renamed, or choose to cancel processing (3956)
· Upd: Improved table column shows double-click to start treatment with heavy brush exception handling (3956)
October 26th, 2010Upd: Update SQL editing features:
· Add: add auto-complete feature ( AutoComplete ), can save time without having to find the SQL syntax to use memory to speed up development time (3952)
· Upd: increase query processing, when you close the Edit Tab and the content has been asked whether transactions (3948)
· Add: increase the shortcut keys Shortcut key: Save: Ctrl + S (3948)
Upd: table editing features ( Table Editor ):
· Add: (Access / MySQL / SQLite / SQL Server / SQL Azure / SQLCe) new rows (INSERT ROW) support for Auto Increment automatic processing (3952)
· Add: (MySQL / SQLite / SQL Server / SQL Azure / SQLCe) increase the Auto Increment add and display processing (3948)
· (PostgreSQL) increase the Auto Increment display processing (3948)
· Upd: (Firebird / MySQL / Oracle / PostgreSQL / SQL Server / SQL Azure / SQLCe) increased UNIQUE Constraints delete processing (3948)
· Upd: Update Multiple Constraints delete processing (3948)
· Upd: improving user experience, add more exception handling (3948)
Upd: to make the database message is displayed:
· Add: (Firebird / MySQL / Oracle / PostgreSQL / SQLite / SQL Server / SQL Azure) Add TRIGGERS collection of information, right-click menu support: View (Open), delete (Delete) (3948)
· Add: (SQLite) to increase right-click menu to delete (Delete) function: Table / Index / Trigger (3948)
· Add: VIEWS collection of information, right-click menu to increase browser before the 1000 document data table feature (Open (Top 1000 Rows)) (3948)
· Upd: KEYS collection of information, increase UNIQUE Constraints display and contextual menu to delete processing (3948)
· Upd: Double-click the database node in the same sub-menu function INSERT TEXT Right (3948)
· Upd: (Oracle) recovery System.Data.OracleClient connection to provide components of the original table editing features are still supported (3945)
· Oracle Database Instant Client path handling: Simple deployment: oci.dll, orannzsbb11.dll, oraociicus11.dll
· Upd: (MySQL) output format Generate Scripts (3945)
· Upd: (MySQL / PostgreSQL / SQL Server) as the default Generate Scripts to export not be completed, it will switch to the second model export treatment (treatment with other databases) (3948)
· : contains minor amendments and other relevant information updated and user experience (3948)
October 20th, 2010· Upd: (Oracle) recovery System.Data.OracleClient connection to provide components of the original table editing features are still supported (3945)
· Restore the specified Oracle Database Instant Client path handling: Simple deployment: oci.dll, orannzsbb11.dll, oraociicus11.dll
· Upd: (MySQL) output format Generate Scripts (3945)
· Fix: contains minor amendments and other relevant information updated and user experience (3945)
October 14th, 2010· Add: Add script editing mode ( Script Mode ): New data table mode to switch the script add custom content (3939)
· Add: (v2) added SQLCe 3.5 table editing features are currently supported SQLCe 3.5/4.0 (3939)
· Fix: (MySQL / SQLite) correction [new] data table if the database contains a table that already exists, all tables will be shown examples of error (3939)
· Upd: Data editing functions ( Data Editor )
· Add: Add edit table data before the 1000 document function (Edit 1000 Rows) (3939)
· Add: Add Filter conditions of filtering: You can edit the custom scope, use the same WHERE method (3939)
· Add: New View before the 1000 document data table feature (Open (Top 1000 Rows)) (3939)
· Upd: optimizing the database when the database connection when the examples are more processing speed (3939)
· Upd: (PostgreSQL) database update service management ( Service Manager ), to support the latest version 8.4 and the subsequent (3939)
· Upd: (MySQL) (v3) updated components MySql.Data.dll 6.3.5 (2010/10/11) (3939)
October 6th, 2010· Fix: (PostgreSQL) amended connections in some environments may occur (FATAL: 3D000: database "???" does not exist) in the state (3931)
October 2nd, 2010· Upd: (Oracle) replacement of components Oracle.DataAccess.dll 11.2.0.1.2 , replace stop development of the System.Data.OracleClient (3927)
· Upd: (Oracle) integration of Oracle Database Instant Client install or set up without additional, compatible x86/x64 Environment (3927)
· Upd: address / * GO * / GO annotations if it contains, it will be broken down into the SQL command question (3927)
· Upd: table editing features ( Table Editor ): (SQLite) to support existing table [settings Cancel] Primary Key Processing (3927)
· Fix: (MySQL / PostgreSQL / SQL Server / SQL Azure) Fixed database connection management examples when the drop-down Ruoyi enter a database name does not exist, the leading examples of the problem can not be performed (3927)
· Upd: Update Polish interface language Polish language (contributed by Jarosław Głowacki) (3927)
· Upd: (PostgreSQL) update PostgreSQL 9.0.0 (2010/09/20) (3927)
· Upd: (MySQL) update MySQL 5.1.51 (2010/09/23) (3927)
September 18th, 2010· Add: additional shortcut keys Shortcut key: Delete to delete the field processing
· Fix: contains many updates, optimization, modification and consistent treatment of ...
September 13th, 2010· Upd: table editing features ( Table Editor )
· Upd: Update and Revision more editing combination treatment
· Upd: Data script property pages ( Data Definition Language (DDL) )
· Add: Add SQL Azure table build script
· Upd: Update Access / SQLCe table create scripts that can completely correct treatment, is no longer just for reference grammar
· Upd: Update build script SQLite table format display processing
· Upd: to make the database information shows
· Upd: (Access / Firebird / MySQL / SQLite / SQLCe / SQL Azure / SQL Server) data table column data type (DataType) more complete display, and edit the display table with information consistent with the standard
· Upd: (Access) update the table column data type (DataType) as the standard SQL data types
· Fix: (OleDB / ODBC) to amend non-open connection through the MRU, connection status, SQL syntax highlighting and other information and dealing with issues not updated
· Fix: (Firebird) amendment to support the field / index delete processing
· Upd: Database [connection and open] the same debug treatment, to provide a consistent way to respond to a more complete error message
· Fix: contains many updates, optimization, modification and consistent treatment of ..., etc.
September 6th, 2010Add: (SQL Azure) Added table editing features ( Table Editor ):
· Now supports SQL Azure / SQL Server 2005/2008
Upd: to strengthen the database message is displayed:
· Add: (SQL Azure) 1. Data sheet to increase Constraints (Default Value) set the message display, 2. Increase the Procedure's Parameters information, 3. To increase the content of Procedure visit (3900)
· Fix: (PostgreSQL) 1. To amend the problem does not appear Indexes, 2. Amend View Index DDL Schema is not specified the problem, 3. Revised Procedures content here lost the role of the (3900)
· Upd: (PostgreSQL) update View View DDL display processing means (3900)
· Fix: (SQL Azure) to amend and update the connection handle (3900)
· Upd: (MySQL) (v3) updated components MySql.Data.dll 6.3.4 (2010/08/31) (3900)
· Upd: SQL command processing by adding the connection status detection and automatic recovery processing in order to prevent interruption of exceptions cause the connection problems (3900)
· Fix: minor correction or error icon does not show the problem (3900)
August 29th, 2010· Add: (Access / Firebird / SQLite) to increase Foreign Key information field, the current database has been [fully] support the Primary Key / Foreign Key Information Display (3893)
· Add: (ODBC / OleDB) to increase the field Primary Key / Foreign Key information shows that when the connection will be displayed when the database support, otherwise not (3893)
· Add: (All) increase the Keys collection of information tables, the current database has been [fully] support the Keys collection of information display (3893)
· Add: (Firebird / PostgreSQL) database collection of information to increase Procedures and content browsing (3893)
· Upd: (PostgreSQL) display mode rewrite, and other databases to display a more consistent (3893)
Upd: improving the information base processing tree node:
· Upd: enhancing delete processing: 1. To support more deletion processing includes (Table / View / Procedure / Column / Key / Index / Constraint), 2. Increase the shortcut keys Shortcut key: Delete (3893)
· Upd: Update scripts to establish (Generate scripts) handle: NULL data type and quotation marks problem (3893)
· Upd: (MySQL) (v2) updated components MySql.Data.dll 6.2.4 (2010/08/26) (3893)
· Fix: Office updated edition more than hundreds, optimization, modification and consistent treatment of ..., etc. (3893)
August 16th, 2010· Add: (SQL Server 2005/2008) new table editing features ( Table Editor ) (3880)
· Add: (SQL Server) to increase Column Constraints (Default Value) tree message display (3880)
· Add: grid display results ( Results to Grid ): add row number display (Row Number) (3880)
· Add: grid display results ( Results to Grid ): New Move to column function (Goto Row) (3880)
· Add: Added keyboard shortcuts: Ctrl + N (New Query Window), Ctrl + O (Open SQL script) (3880)
· Upd: Optimal tree node database field to start processing speed (3880)
· Upd: (Firebird) updated manually when the Firebird Server (bat) installation issues related to treatment (3880)
· Upd: (ODBC) connection to different sources of support may increase the differences in various exception handling (3880)
· Fix: (ODBC) to amend the amendment by MRU led to the use peripherals ID / PWD had no effect (save) the problem (3880)
· Fix: contains various small fixes, updates and optimization (3880)
August 7th, 2010· Increase the servo-side database connection is set up processing (Server) MySQL / SQL Server / PostgreSQL (3858/3871)
· Fix: (MySQL) to amend the implementation of SQL command in the event an exception, and the current database connection database of non-default situation arising (3871)
· Fix: Updated edition range of large and numerous, also contains many small fixes, updates and optimization will not enumerate (3871)
August 6th, 2010· Upd: support for a more complete connection property ( Connection Properties ): servo-level database (Server) support the [individual] Connection property is set, mobile database (Portable) support [general] connection property is set (3865)
· Fix: amendments (3865) for the first time no default settings or settings not work under SQL Mode connection problems (3869.1)
· Upd: (Oracle) to manage the Instant Client directory connection settings, simplify Oracle Connection handle: installed just three steps: Download -> Unzip-> Set location (3,869.1)
· Upd: (Oracle) 1. Adding Stored Procedures display processing (including the contents of view), 2. to amend the first connection is Tables / Views display processing (3869.1)
· Add: (ODBC / OleDB) increased Quoted strings to ensure that we deal with exceptional character, automatically connect to the database itself from the default (3869)
· Fix: (Access / Excel / dBase) to amend the omission of the last version of the issues addressed Quoted strings (3869)
· Upd: (PostgreSQL) correction [column shows] and [script set up] is not specified Schema question (3870)
· Upd: (PostgreSQL) update references show only complete Data Types to Database Types (3869)
· Fix: (dBase) database updates and amendments to refresh processing (3869)
· Upd: Update Open Table approach, the original select * to select xxx, xxx, ... a full field display for easy re-editing (3869)
· Upd: Update scripts to establish (Generate scripts), distinguish between different databases: value / string / boolean type handling, etc. (3869)
· Upd: updates form (Boolean) output and export processing (original True / False to SQL common 1 / 0 is displayed and output processing (3869)
· Upd: Add or edit the default label if not anything, and when other operations such as: Open Table, Generate scripts ... etc. Will be a direct replacement (3869)
· Upd: updated when the Text Editor / Text Result font (Font) and size (Size) to update the display immediately after reset (3869)
· Upd: 1. Update all language file information, 2. Improve the MRU treatment, when the database will be automatically removed with the removal Profile (3865). 3. Amendment (3865) MRU display problems (3865.1)
· Add: Added Thai language interface language Thai language (contributed by Thammapat.c) (3858)
· Upd: SQL Editor Syntax to open in full support of the current database syntax (Data Types / Reserved Words), not only support a single or common to database syntax
· But to load the complete database to open their respective related syntax, so you can making editing more intuitive understanding of the different types of data (3858)
· Add: Added script generates INSERT ( INSERT statement Generate scripts ): Support New Query Editor Window / File / Clipboard other output processing (3858)
· Add: Added file export format INSERT statement scripts (*. sql), currently supports include (csv / xml / txt / xls / sql) (red for the new export format) (3858)
· Upd: updated new database functions (Create Database): Apart from the original (Portable) Access 2000/Access 2007-2010/Firebird/SQL Server CE / SQLite, the
· Increase the servo-side database connection is set up processing (Server) MySQL / SQL Server / Oracle / PostgreSQL (3858)
· Upd: updated file export format, the information content of NULL, the export to NULL for the string after the replacement the same blank (3858)
· Fix: amendments (3858) Morphology of non-string data can not be NULL text output problems (3859)
· Add: create table script (Script Table as) menu features: In addition to export to New Query Editor Window outside an additional File / Clipboard and other output functions (3858)
· Upd: updated database Reserved Words references, cited information from a more complete MetaData (3858)
· Fix: amendments to Code Examples : 1. Save the file name display problem (3858), 2. file renamed to re-open the issue (3865)
· Upd: Update Open Table handling: when repeating the same TableName and implementation of SQL statement here does not change, will automatically implement (Execute) treatment (3858)
· Upd: Optimization of data grid show the results processing speed (3858)
· Upd: (PostgreSQL) updated components Npgsql.dll 2.0.10 (2010/08/01) (3869)
· Upd: (MySQL) update MySQL 5.1.49 (2010/07/09) (3858)
· Upd: (v3) (MySQL) updated components MySql.Data.dll 6.3.3 (2010/07/25) (3865)
July 16th, 2010· Add: New Database. NET v3 based on . NET Framework 3.5sp1 (3848)
· (V2) remain unchanged Database. NET v2 based on . NET Framework 2.0sp2
· Add: (v3) Added support for SQL Server CE v4 (4.0.8402.1) (2010/06/24) (3848)
· (V2) remain unchanged SQL Server CE v3.5sp2 (3.5.8080) (2010/02/12)
· Upd: (v2) component replacement MySql.Data.dll 6.2.3 (2010/04/10), support for MySQL 4.1/5.0/5.1/5.4 (3848)
· (V3) remain unchanged MySql.Data.dll 6.3.2 (2010/05/19), support the MySQL 5.0/5.1/5.4
· Misc: v2 mainly to maintain the existing database to support, v3, is targeted to support the most current database, the two can co-exist to cater for the use of different environments (3848)
· Upd: grid display results ( Results to Grid ): Update a column width of the automatic update processing (3848)
· Upd: (ODBC) support for username and password input processing (3848)
· Fix: (ODBC) to amend Schema of the problem may cause the majority of the database may not open connection status (3848)
· Fix: amend the proposed new code is not immediately after the sample file open questions (3848)
· Upd: full-screen switch (FullScreen): 1. To amend and improve the display, 2. Increase the shortcut key F11 (3824), 3. Full-screen window with the maximum separation (3848)
· Fix: 1. Amendment Minimized to Tray lost their problems, 2. Other minor amendments include updating and optimization of multiple (3848)
July 3rd, 2010· Add: Added SQL Reference tab: include ( Data Types / Functions / Reserved Words ) and other related reference materials (3824)
· When opening the database, it will automatically load [their] database-related references can be inserted through the right menu (or double) / copy text
· Add: SQL Editor tab ( TabPage ): 1. join the fast close button, 2. the main menu, quickly switch to increase, 3. Right menu item to increase all closed, 4. Main Menu increase in all closed items
· Add: (ODBC) joined the User DSN / System DSN connection handling (currently including: User DSN / System DSN / File DSN ) (red is new)
· Upd: full-screen switch (FullScreen): 1. To amend and improve the display, 2. Increase the shortcut key F11
· Upd: program close automatically empty the Sandbox in the temporary file that contains the old version of the residues of temporary to clear
· Upd: (MySQL) update MySQL 5.1.48 (2010/06/02)
· Fix: (SQL Server) SQL Server 2000 under the temporary removal of the index display, to avoid the exception
· Fix: 1. Amendment Minimized to Tray lost their problems, 2. Other minor amendments include updating and optimization of multiple
May 21st, 2010· Upd: Update [other connection parameter] Set Additional connection string parameters, automatically (MySQL / SQLite) [list type] in the constant name (3793)
· Upd: (MySQL / PostgreSQL / Oracle / SQL Server / SQL Azure) to manage the connection ([other connection parameter] Set Additional connection string parameters) shortcut keys (3793)
· Upd: (Access / Excel / dBase) and other database does not support annotation syntax (Comment Syntax), when the SQL Command execution will [automatically] remove the comment after the execution (with the previous version) (3792)
· Upd: (MySQL) to solve MySql.Data.dll own flaws, when debugging with [some] of the command syntax errors, leading to DBReader not shut down the problem to continue to use (3792)
· Upd: (PostgreSQL) update the latest version of the components and programs PostgreSQL 8.4.4 (2010/05/17)
May 8th, 2010· Upd: implementation of the SQL Command to retain annotation processing (do not do filtering), such as: the establishment of the stored procedure can be preserved for reference (3779)
· Upd: updates boxes show the results ( Results to Grid ): [contains all the information] form the NULL NULL are displayed when processing (such as byte () is null) (3779)
· Add: added license information to switch, to provide donors switch display ( License Type ) (3779)
· Upd: improving the user experience: 1. [Connection Manager] operation processing (3756), 2. Refresh the tree node will maintain its original location and start / Collapse State (3779)
· Upd: (All DBs) update the data type column shows: 1. Char =- 1 (max) (3779)
· Upd: (Access) to a more streamlined approach to rewrite the database [build / compression / password] and other treatment (3779)
· Fix: (Access) to amend the password database with no update after loading [title] message can not perform compression related issues (3779)
· Fix: (Access / Excel / dBASE / FB) amended by the MRU to open a database that does not exist when [working out] status of the problem is not restored (3779)
· Upd: (SQL Server CE) data type column updated show: 1. Numeric (Precision / Scale), 2. Binday / varbinday =- 1 (max / Scale) (3779)
· Upd: (SQL Server / SQL Azure) update the column data type shows: 1. Decimal (Precision / Scale), 2. Time/Datetime2/DateTimeOffset (Scale) , 3. Computed 4. binday / varbinday =- 1 ( max / Scale) (3779)
· Upd: (SQL Server / SQL Azure) update component Microsoft SQL Server 2008 R2 Management Objects 10.50.1600.1 (2010/04/07) (3779)
· Fix: other minor fixes and contains multiple Optimization Update Processing (3779)
April 22nd, 2010· Upd: (SQLite) updated components System.Data.SQLite.DLL 1.0.66.0 (SQLite 3.6.23.1) (2010/04/18) (3763)
· Upd: (PostgreSQL) updated components Npgsql.dll 2.0.9 (2010/04/13) (3763)
· Add: Added export the file format Excel Workbook (*. xls), currently supports include (csv / xml / txt / xls) (red for the new export format) (3756)
· Upd: improving the user experience: [Connection Manager] operation processing (3756)
· Upd: Text Result of Grid height will be set with the font size automatically change (3734)
· Upd: (SQL Server) using SQL Server authentication when the remote connection method, DDL / SP / Backup / Restore ... and other related support to handle (3756)
· Upd: (SQL Server) update component Microsoft SQL Server 2008 R2 Management Objects 10.50.1447 (2010/02/14) (3756)
· Upd: (SQL Server CE) Update component System.Data.SqlServerCe.dll 3.5.8080 (3.5sp2) (2010/02/12) (3756)
· Upd: (MySQL / SQL Server / PostgreSQL) restore the database to automatically refresh the database list (3756)
· Fix: other minor fixes and contains multiple Optimization Update Processing (3756)
· Misc: Compatible with Microsoft. NET Framework 4.0 RTM / Compile with Microsoft Visual Studio 2010 RTM (2010/04/13)
April 14th, 2010· Add: Added export the file format Excel Workbook (*. xls), currently supports include (csv / xml / txt / xls) (red for the new export format)
· Upd: improving the user experience: [Connection Manager] operation processing
· Upd: Text Result of Grid height will be set with the font size automatically change
· Upd: (SQL Server) using SQL Server authentication when the remote connection methods, DDL / SP / Backup / Restore ... and other related support to handle
· Upd: (SQL Server) update component Microsoft SQL Server 2008 R2 Management Objects 10.50.1447
· Upd: (SQL Server CE) Update component System.Data.SqlServerCe.dll 3.5.8080 (3.5sp2)
· Upd: (MySQL / SQL Server / PostgreSQL) restore the database to automatically refresh the database list
· Fix: other minor fixes and contains multiple Optimization Update Processing
· Misc: Compatible with Microsoft. NET Framework 4.0 RTM / Compile with Microsoft Visual Studio 2010 RTM
March 11th, 2010· Fix: GO batch processing mode
· Add: increase in Text Editor / Text Result font (Font) and size (Size) settings
· Upd: (MySQL) updated components MySql.Data.dll 6.3.1
February 15th, 2010· Add: Added additional connection string settings Additional connection string parameters: the database can be different to increase their own proprietary connection definition (3698)
· Add: (SQLCe) Added connection settings Max Database size, default lock Escalation (3698)
· Add: Added Vietnamese interface language Vietnamese language (contributed by Tran Huu Qui) (3687)
· Add: text-display the results (Results to Text) Add a custom split character (Delimiter) set (3687)
· Support File Export (Export as csv / xml / txt) custom character segmentation processing (3692)
· Upd: (MySQL / MSSQL / PostgreSQL / Oracle) database to switch the list to sort (Sort) Processing (3687)
· Upd: (MySQL / MSSQL / PostgreSQL / Oracle) database (SQL command) to establish (CREATE) / delete (DROP) to automatically refresh the database list (3687)
· Upd: (MSSQL) database commands (SQL command) switch (USE) to automatically refresh the database list (3687)
· Upd: (PostgreSQL) to increase Windows security log mode (3687)
· Upd: (MySQL) when the machine is not installed MySQL will also support database backup and restore functionality (second update) (3687)
· Upd: (MySQL / MSSQL / PostgreSQL / Oracle) update and revision treatment of Connection Management (3666)
· Upd: online reference Related links (References) various updates and new (3692)
· Fix: amendments to cut off the connection to connect menu after the original letter could not restore the status question (3665)
· Fix: include other minor fixes and updates in various optimization processing (3687)
January 14th, 2010· Upd: (MySQL) when the machine is not installed MySQL will also support backup and restore database functions (3665)
· Upd: (MySQL / MSSQL / PostgreSQL / Oracle) update and revision treatment of Connection Management (3666)
· Fix: amendments to cut off the connection to connect menu after the original letter could not restore the status question (3665)
December 29th, 2009· Add: Added support for SQL Azure cloud database management functions (3605)
· Add: clipboard paste (Paste), support for HTML Format format, may retain their original formatting the content display (3624)
· Add: Added German interface language German language (contributed by Waler, Stefan) (3649)
· Upd: update to start treatment, when the [UAC Open] with [non-administrator rights] will automatically be shut down under the [Library Services Management Service Manager] features to avoid security prompts when you start asking (3624)
· Upd: Update will retain QueryTabs disconnected without removal (3605)
· Fix: amendments to the implementation of SQL command when the cursor stays in the results display page, the cursor sometimes result in the state can not be restored to normal issues (3649)
· Fix: amendments to the implementation of the process of inclusion into the database SQL commands if there was an exception, DbReader caused by the closure can not continue to operate without problems (3613)
· Add: (Firebird) to increase support for Firebird Embedded Server portable version of the database management (Options-> SuperServer / Embedded) (3632)
· Upd: (SQL Server) increase the Schema support (3605)
· Fix: (SQL Server) using SQL Server authentication to connect the amendment approach, possible? Not handle properties in the DDL script and open the browser features such as SP (3605)
· Upd: (MySQL) updated components MySql.Data.dll 6.2.2 (2009/12/17)
· Upd: (PostgreSQL) update PostgreSQL 8.4.2 (2009/12/10)
· Fix: (Excel) the amendment does not increase Quoted String can not be implemented Open Table function question (3605)
· Upd: (Odbc / OleDB) increase the Data Source Name file (*. dsn), Datalink file (*. udl) files Drag and Drop (DragDrop) method to open (along with other file type of database) (3605)
· Fix: include other minor fixes and updates in various optimization processing (3605)
December 4th, 2009· Upd: update to start treatment, when the [UAC Open] with [non-administrator rights] will automatically be shut down under the [Library Services Management Service Manager] features to avoid security prompts when you start asking
· Add: clipboard paste (Paste), support for HTML Format format, may retain their original formatting the content display
November 22nd, 2009· To amend the status bar under the different database [effect of] processing, Update SQL command messages to respond to treatment
· Fix: amendments to the implementation of the process of inclusion into the database SQL commands if there was an exception, DbReader caused by the closure can not continue to operate without problems
November 4th, 2009· Upd: join the InnerException error message is displayed, such as processing StoreProcedure will be able to show more detailed error messages
· Upd: (MySQL) modify the connection string use procedure bodies = false; allow user variables = true; facilitate the implementation of a custom stored procedure variables Processing
October 9th, 2009· Add: Add the Romanian interface language Romanian language
· Upd: revised and updated: 1. A new status icon updates the database after the problem, 2. To start as an administrator (UAC), to support service management database to facilitate web site features such as browsing ...
· Fix: other minor fixes and updates
September 14th, 2009· Add: Added ODBC File DSN (Data Source Name) to connect processing in support of a broader more information on database connectivity Processing
· Upd: the implementation of the non-SQL SELECT command, and without any information to respond to the record will no longer display an empty page
· Upd: updated Aero is turned on, Windows will automatically turn off Shadows to avoid duplication of function display
· Upd: Update Open Table Processing: Independent Query Editor also shows SQL commands, and allows duplication to open the same Table
· Upd: Update icon (48x48/32x32/16x16 Icon), shown in a more beautiful environment Vista/W2K8/Win7
· Upd: Update SQL Examples show interface, menu processing function
· Upd: Updated syntax highlighting: 1. Join the 'character Block block processing, 2. Add a few SqlType Keywords
· Upd: (SQLCe) When you open the upgrade from older versions and the [Canadian password] is the database (
August 18th, 2009· Upd:update icon (48x48/32x32/16x16 Icon), in Vista/W2K8/Win7 show more attractive environment (3517)
· Upd:(SQLite) to update components System.Data.SQLite.DLL 1.0.65.0 (2009/07/26)
· Fix:(OLE DB) non-UDL file to open when Unsupported UDL file lock after the release of the problem is not (3517)
July 17th, 2009· Add: Added Polish language Polish language interface (contributed by Jarosław Głowacki) (3443)
· Add: 新增簡體中文介面語言Chinese Simplified language (3443) - Add: Added Simplified Chinese language interface Chinese Simplified language (3443)
· Upd: 更完整地支持與顯示Quoted strings 處理(3435) - Upd: a more complete support for Quoted strings and display processing (3435)
· Upd: 回復雙擊可開啟範例文件功能(3435) - Upd: Double-click can restore function to open an example file (3435)
· Upd: 更新客製化語言編輯功能( Custom Language Editor ): 增加[語言翻譯與詞彙]查詢連結(3463) - Upd: Update customized language editing features (Custom Language Editor): increase in [language translation and vocabulary] query links (3463)
· Upd: 關閉資料庫或連線後清空與釋放所有Query 與Result 資料(3472) - Upd: Close connection after a database or clear with the release of all Query and Result Data (3472)
· Fix: 修正Multiple Query Tab 切換不同資料庫的問題(3472) - Fix: Switch to amend Multiple Query Tab different database (3472)
· Fix: 修正若在未開啟或連線資料庫時, 無法開啟連線右鍵選單的問題(3443) - Fix: If the amendment did not open or the database connection, the connection can not open the question of the right-click menu (3443)
· Fix: 修正資料結構與範例管理右鍵選單在無指定節點時無法正常開啟的問題(3443) - Fix: amendments to the information management structure and an example of the right-click menu in the absence of the specified node can not open the question of the normal (3443)
· Fix: 修正UAC 開啟時導致無法開啟超連結(瀏覽器)的問題(3457) - Fix: amendments UAC is turned on can not open hyperlinks lead (browser) question (3457)
· Fix: 修正(資料匯出/範例另存/資料庫備份/SQL編輯另存)檔案名稱例外處理(3482) - Fix: amendments (Data Export / Save As examples / database backup / SQL Edit Save) the file name of an exception (3482)
· Fix: 1.其他小幅修正與更新, 2.修正120DPI 下顯示處理(3482) - Fix: 1. Other small fixes and updates, 2. 120DPI amended to deal with the next show (3482)
· Upd: (PostgreSQL) 加入Quoted strings 處理(3435) - Upd: (PostgreSQL) to deal with adding Quoted strings (3435)
· Upd: (PostgreSQL) 更新元件Npgsql.dll 2.0.6 (2009/07/11) - Upd: (PostgreSQL) to update components Npgsql.dll 2.0.6 (2009/07/11)
· Misc: (PostgreSQL) Compatible with PostgreSQL 8.4.0 (2009/07/01) - Misc: (PostgreSQL) Compatible with PostgreSQL 8.4.0 (2009/07/01)
· Upd: (Oracle) 重新改寫Oracle 顯示與處理方式: 1.增加Schema 的支持, 2.新增WinAuth 連線方式, 3.新增AskTom資源連結(3475) - Upd: (Oracle) rewritten to deal with Oracle to show the way: 1. Increase the Schema support, 2. Add WinAuth Connection, 3. Added AskTom resources link (3475)
· Fix: (Oracle) 1.修正Oracle 連線後出現ORA-0091: invalid character 的錯誤, 2.修正與更新連線的問題(3472) - Fix: (Oracle) 1. Amended after Oracle connection ORA-0091: invalid character error, 2. To amend and update the issue of the connection (3472)
· Upd: (Firebird) 更新元件FirebirdSql.Data.FirebirdClient.dll 2.5.0 (2009/05/20)(3435) - Upd: (Firebird) to update components FirebirdSql.Data.FirebirdClient.dll 2.5.0 (2009/05/20) (3435)
· Upd: (SQLite) 更新元件System.Data.SQLite.DLL 1.0.64.0 (2009/07/09) - Upd: (SQLite) to update components System.Data.SQLite.DLL 1.0.64.0 (2009/07/09)
· Upd: (MySQL) 更新元件MySql.Data.dll 6.0.4 (2009/06/09) - Upd: (MySQL) to update components MySql.Data.dll 6.0.4 (2009/06/09)
· Misc: Compatible with Windows Server 2008 Service Pack 2 and Windows Vista Service Pack 2 (2009/05/25) - Misc: Compatible with Windows Server 2008 Service Pack 2 and Windows Vista Service Pack 2 (2009/05/25)
· Misc: Compatible with Microsoft .NET Framework 4.0 beta 1 (2009/05/13) Misc: Compatible with Microsoft. NET Framework 4.0 beta 1 (2009/05/13)
June 19th, 2009· Add: Added Polish language Polish language interface (contributed by Jarosław Głowacki) (3443)
· Add: Added Simplified Chinese language interface Chinese Simplified language (3443)
· Upd: a more complete support for Quoted strings and display processing (3435)
· Upd: Double-click can restore function to open an example file (3435)
· Upd: (Firebird) to update components FirebirdSql.Data.FirebirdClient.dll 2.5.0 (2009/05/20) (3435)
· Upd: (PostgreSQL) to deal with adding Quoted strings (3435)
· Upd: (PostgreSQL) to update components Npgsql.dll 2.0.5 (2009/05/06) (3435)
· Fix: (Oracle) to connect the issue of amendments to Oracle (3435)
· Fix: If the amendment did not open or the database connection, the connection can not open the question of the right-click menu (3443)
· Fix: amendments to the information management structure and an example of the right-click menu in the absence of the specified node can not open the question of the normal (3443)
· Fix: amendments UAC is turned on can not open hyperlinks lead (browser) question (3457)
· Misc: Compatible with Windows Server 2008 Service Pack 2 and Windows Vista Service Pack 2 (2009/05/25)
· Misc: Compatible with Microsoft. NET Framework 4.0 beta 1 (2009/05/13)
June 4th, 2009· Add: Added Polish language Polish language interface (contributed by Jaroslaw Glowacki) (3443)
· Upd: a more complete support for Quoted strings and display processing (3435)
· Upd: Double-click can restore function to open an example file (3435)
· Upd: (Firebird) to update components FirebirdSql.Data.FirebirdClient.dll 2.5.0 (2009/05/20) (3435)
· Upd: (PostgreSQL) to join Quoted strings to deal with (3435)
· Upd: (PostgreSQL) to update components Npgsql.dll 2.0.5 (2009/05/06) (3435) - Upd: (PostgreSQL) to update components Npgsql.dll 2.0.5 (2009/05/06) (3435)
· Fix: (Oracle) to amend the issue of Oracle Connection (3435)
· Fix: If the amendment did not open or the database connection, the connection can not open the question of the right-click menu (3443)
· Misc: Compatible with Windows Server 2008 Service Pack 2 and Windows Vista Service Pack 2 (2009/05/25)
· Misc: Compatible with Microsoft. NET Framework 4.0 beta 1 (2009/05/13)
May 29th, 2009· Upd: a more complete support for Quoted strings and display processing (3435)
· Upd: Double-click can restore function to open an example file (3435)
· Upd: (Firebird) to update components FirebirdSql.Data.FirebirdClient.dll 2.5.0 (2009/05/20) (3435)
· Upd: (PostgreSQL) to deal with adding Quoted strings (3435)
· Upd: (PostgreSQL) to update components Npgsql.dll 2.0.5 (2009/05/06) (3435)
· Fix: (Oracle) to amend the problem can not connect Oracle (3435)
· Misc: Compatible with Windows Server 2008 Service Pack 2 and Windows Vista Service Pack 2 (2009/05/25)
· Misc: Compatible with Microsoft. NET Framework 4.0 beta 1 (2009/05/13)
May 14th, 2009· Add: impact of an increase after the implementation of SQL few shows (Records Affected) (3390)
· Add: new dBASE IV (*. dbf) database processing (3385)
· Add: Add custom language editing features (Custom Language Editor): You can more easily add different languages or modify the default language, you can share your language file (3360)
· Add: SQL editing features (SQL Editor) Add comment (Comment) and cancellation of Notes (Uncomment) function (3366)
· Add: Added Italian interface language Italian language (contributed by Stefano Gallina) (3384)
· Upd: multi-tab function query (Multiple Query Tab): 1. To support the switch to deal with different databases, 2. To amend the title name is displayed (3360)
· Upd: updates the list of the right-click menu: 1. Added quick menu specified export format, 2. To improve the information in the non-open hours to remove the original focus of the problem (3360)
· Upd: Recently, fast connection menu (Recent Connections): 1. Add shortcuts to deal with (Shortcut key: 0 ~ 9) (3366), 2. Increase Tooltips display the full path (3385)
· Upd: 1. Update multiple interfaces, 2. The right-click menu by adding Refresh (Database / Table / View) treatment (3366)
· Upd: Update website resource reference (SQL Server / SQLCe / MySQL) (3390)
· Upd: updated results showed that approach, while improving efficiency and reducing the SQL implementation of temporary memory (3390)
· Fix: change 2.6.3353 amended the original information leading to DataGridView Export (Export Data-> CSV / XML / TXT) lost the role of the (3360)
· Fix: 1. Other small fixes and updates, 2. SQL Editor can not be used to amend the mouse double-click the selected text in question (3408)
· Add: (SQL Server) 1. Join the show to deal with Stored Procedures (3384), 2. Update to show ROUTINE_TYPE = 'PROCEDURE' (3399)
· Upd: (SQL Server) to update the fields displayed DataType (SysDataType, length) (3384)
· Upd: (SQL Server) to update Microsoft SQL Server 2008 Management Objects (SP1)-related components (3385), compatible with SQL Server 2008 SP1 / Express SP1 (2009/04/07)
· Fix: (SQL Server) as amended is not installed in SQL Server environment to implement, resulting in the implementation of components related to the lack of SMO to backup / restore / DDL show features not dealt with (3384)
· Add: (MySQL) joined the show to deal with Stored Procedures (3399)
· Upd: (MySQL) to update components MySql.Data.dll 6.0.3 (2009/04/23) (3408)
· Fix: (PostgreSQL) amended if the designated non-default account will not be able to connect the issue of normal (3382)
· Misc: (PostgreSQL) Compatible with PostgreSQL 8.3.7 (2009/03/16)
· Fix: (Excel) to amend the Open Table the issue can not be implemented (3390)
· Upd: (SQLite) to update components System.Data.SQLite.DLL 1.0.61.0 (2009/04/28) (3408)
· Fix: (Access / Excel / dBASE / OleDB) to amend the implementation of SQL command to repeat the question twice (3412)
· Upd: (Access / Firebird / SQLite / SQLCe) when a database is open, it will automatically shut down to re-open the new database (3366)
· Fix: (PostgreSQL / MySQL / SQL Server / Oracle) to amend the first time included in the "repeat" refresh database, the speed of the impact of open questions (3399)
April 24th, 2009· Add: to increase the impact of the implementation of a number of shows after SQL (Records Affected) (3390)
· Add: new dBASE IV (*. dbf) database processing (3385)
· Add: Add custom language editing features (Custom Language Editor): You can more easily add different languages or modify the default language, you can share your language file (3360)
· Add: Add custom language editing features (Custom Language Editor): You can more easily add different languages or modify the default language, you can share your language file (3360)
· Add: Add custom language editing features (Custom Language Editor): You can more easily add different languages or modify the default language, you can share your language file (3360)
· Upd: multi-tab function query (Multiple Query Tab): 1. To support the switch to deal with different databases, 2. To amend the title name is displayed (3360)
· Upd: updates the list of the right-click menu: 1. Added quick menu specified export format, 2. To improve the information in the non-open hours to remove the original focus of the problem (3360)
· Upd: quick connect menu recently (Recent Connections): 1. Add shortcuts to deal with (Shortcut key: 0 ~ 9) (3366), 2. Increase Tooltips display the full path (3385)
· Upd: 1. Update multiple interfaces, 2. The right-click menu by adding Refresh (Database / Table / View) treatment (3366)
· Fix: change 2.6.3353 amended the original information leading to DataGridView Export (Export Data-> CSV / XML / TXT) lost the role of the (3360)
· Upd: Update website resource reference (SQL Server / SQLCe / MySQL) (3390)
· Add: (SQL Server) to join Stored Procedures display processing (3384)
· Upd: updated to show ROUTINE_TYPE = 'PROCEDURE' (3399)
· Upd: (SQL Server) to update the fields displayed DataType (SysDataType, length) (3384)
· Upd: (SQL Server) to update Microsoft SQL Server 2008 Management Objects (SP1)-related components (3385)
· Fix: (SQL Server) as amended is not installed in SQL Server environment to implement, resulting in the implementation of components related to the lack of SMO to backup / restore / DDL show features not dealt with (3384)
· Misc: (SQL Server) Compatible with SQL Server 2008 SP1 / SQL Server 2008 Express SP1 (2009/04/07)
· Add: (MySQL) joined the show to deal with Stored Procedures (3399)
· Upd: (MySQL) to update components MySql.Data.dll 6.0.2 (2009/04/06) (3390)
· Upd: (MySQL) to update components MySql.Data.dll 6.0.2 (2009/04/06) (3390)
· Misc: (PostgreSQL) Compatible with PostgreSQL 8.3.7 (2009/03/16)
· Fix: (Excel) to amend the Open Table the issue can not be implemented (3390)
· Upd: (Access / Firebird / SQLite / SQLCe) when a database is open, it will automatically shut down to re-open the new database (3366)
· Fix: (PostgreSQL / MySQL / SQL Server / Oracle) to amend the first time included in the "repeat" refresh database, the speed of the impact of open questions (3399)
· Upd: 1. Other small fixes and updates, 2. Updated results showed that approach, while improving efficiency and reducing the SQL implementation of temporary memory (3390)
April 8th, 2009· Add: Add custom language editing features (Custom Language Editor): You can more easily add different languages or modify the default language, you can share your language file
· Add: SQL editing features (SQL Editor) Add comment (Comment) and cancellation of Notes (Uncomment) function
· Add: Added Italian language Italian language interface (Thanks to Stefano Gallina)
· Upd: query many features tab (Multiple Query Tab): 1. To support the switch handle different database, 2. To amend the title name is displayed
· Upd: updated information on the list deal with the right-click menu: 1. Add Express menu specified export format, 2. To improve the open in the non-information when the original focus of the question to remove
· Upd: quick connect menu recently (Recent Connections): Added shortcuts treatment (Shortcut key: 0 ~ 9)
· Upd: 1. Update multiple interfaces, 2. Add right-click menu Refresh (Database / Table / View) treatment
· Fix: amendments to the original cause 2.6.3353 change information DataGridView Export (Export Data-> CSV / XML / TXT) lost their role in the problem
· Add: (SQL Server) add Stored Procedures showed that treatment
· Upd: (SQL Server) to update the fields displayed DataType (SysDataType, length)
· Fix: (SQL Server) as amended is not installed in SQL Server environment to implement, resulting in the implementation of components related to the lack of SMO to backup / restore / DDL display function can not deal with the problem of normal
· Upd: (Access / Firebird / SQLite / SQLCe) set up the database when the status is open, it will automatically turn off to re-open the new database
· Upd: (MySQL) to update components MySql.Data.dll 6.0.1
· Fix: (PostgreSQL) amended if the designated non-default account will not be able to connect the issue of normal
· Upd: (PostgreSQL) Compatible with PostgreSQL 8.3.7
March 21st, 2009· Add: Added customization language editing features (Custom Language Editor): You can more easily add different languages or modify the default language, you can share your language file
· Add: SQL editing features (SQL Editor) Added settings comment (Comment) and cancellation of Notes (Uncomment) function
· Upd: multi-tab query function (Multiple Query Tab): 1. Supported switch handle different database, 2. To amend the title name is displayed
· Upd: updates the list deal with the right-click menu: 1. Add Express menu specified export format, 2. To improve the open in the non-information removed when the original focus question
· Upd: recent connection shortcut menu (Recent Connections): Added shortcuts treatment (Shortcut key: 0 ~ 9)
· Upd: 1. Update multiple interfaces, 2. The right-click menu add Refresh (Database / Table / View) treatment
· Fix: Change DataGridView amended 2.6.3353 information leading to the original Export (Export Data-> CSV / XML / TXT) lost the role of problem
· Upd: (Access / Firebird / SQLite / SQLCe) when set up the database in open state, will automatically turn off to re-open the new database
· Upd: (PostgreSQL) Compatible with PostgreSQL 8.3.7 (2009/03/16)
June 2nd, 2008· Add: Increases the formula code automatic production (Code Generation): MySQL/SQL Server/PostgreSQL/Oracle
· Add: The formula code automatic production increases View to process
· Add: Increases PostgreSQL formula code automatically produces
· Add: Increases Oracle formula code automatically produces
· Add: Increases the information bank correlation news demonstration (Database Information)
· Upd: Renews the PostgreSQL information bank to demonstrate that, lifts the material table according to the SCHEMA automatic example (with pgAdmin III)
· Upd: Renews Service Manager: 1. supports the different origin management, 2. the improvement far-end service examination processes
· Upd: Improvement segment management preservation way
· Upd: Renewal part System.Data.SQLite.DLL 1.0.49.0 (2.008/05/28 billion)
· Fix: Revises PostgreSQL not to bring Schema question
May 7th, 2008· Add: Increases Access 2007 information bank automatic establishment (Create DB) function
· Add: Increases the Access 2,007 information banks password protection (Protect DB) function
· Add: Increases Access the 2007/PostgreSQL information bank automatic compression (Shrink DB) function
· Add: PostgreSQL/MySQL segment processing joins Port to establish
· Fix: The revision (PostgreSQL) the material shows when CHARACTER_MAXIMUM_LENGTH Is DBNull has exception
April 4th, 2008· Upd: Renewal model management (SQL Example Manager): 1. Joins the right key to choose the list to open the model option, 2. Single-clicks opens the model to change double-clicks
· Upd: The tree shape pitch point joins the material table quantity to demonstrate
· Upd: Renewal part FirebirdSql.Data.FirebirdClient.dll 2.5.0.0 alpha2 (2.008/03/06 billion)
· Upd: Renewal part MySql.Data.dll 5.2.1.0 (2.008/02/25 billion)
· Fix: After revises v1.7 to cause the material to collect (Export Data-> CSV/XML/TXT) non- function question
· Misc: Compatible with Windows Server 2008 accommodating newest work system
· Misc: Compatible with Windows Vista the SP1 accommodating newest work system service wraps
February 2nd, 2008· Add: Joins a raid of inquiry (SQL Query Batch) the result showed processes
· Add: Joins the GO essential character, supports raid of demand processing
· Fix: Repairs the right fence position to contain the Bool type, the series printing function produces exception question
January 25th, 2008· Add: Increases the host to choose the list (Mainmenu) to support, and increases many functions
· Add: Supports Oracle Database
· Add: Supports Microsoft Office Excel 97-2003 Database (* xsl)
· Add: Supports Microsoft Office Excel 2,007 Database (* xslx)
· Add: Joins the Char fence position length to demonstrate
· Fix: Revises 1.5.2940 (Oracle to eliminate wrong news not to cause MySQL/SQL Server/PostgreSQL to be unable segment question)
January 19th, 2008· Add: Supports Oracle Database
· Fix: Revises Char fence position length demonstration question
January 5th, 2008· Add: Increases the material output (Export Data): Support form CSV/XML/TXT three kind of document formats
· Add: Joins INFORMATION_SCHEMA.VIEWS to support
· Upd: The information bank service management (Service Manager), joins Startup the Type news to demonstrate
· Upd: 1. Modifies many place UI, 2. Automatically renovates non- records SQL to order
· Upd: Renewal part System.Data.SQLite.DLL 1.0.48.0 (2.007/12/28 billion)
December 27th, 2007· Add: Increases the information bank service management (Service Manager), may start any origin the information bank service to start with stops function
· Add: The tree shape pitch point fence position joins Primary Key/Foreign the Key demonstration (PK/FK)
· Upd: The promotion information bank writes down opens processing speed
· Upd: Renewal part System.Data.SQLite.DLL 1.0.47.2
· Upd: Renewal part MySql.Data.dll 5.1.4.0
December 3rd, 2007· Add: The tree shape pitch point joins Data Type and Is the Nullable fence position news demonstrates
· Add: (PostgreSQL) improves segment processing and automatically opens service processing (8.2.x)
· Add: (SQL Server) the segment management joins automatically enumerates in the region network all to be possible to use it to carry out individual
· Upd: Improvement segment management (Connection Profile): Analyzes the different information bank management to establish
· Upd: The tree shape pitch point fence position name according to the information bank in the fence position arrangement demonstrates
· Upd: Promotion tree shape information bank pitch point demonstration processing speed
· Upd: 1. Revises the first installment to suppose the question in advance which the typeface is unable correctly to process, 2. renews under Vista TreeView to control demonstration optimization processing - Misc: Compiled with VS2008, Compatible with NET 3.5/3.0sp1/2.0sp1//-->
· Upd: Renewal part System.Data.SqlServerCe.dll 3.5.5386 (2.007/10/02 billion)
Find us on Google+
