What's new in LazSqlX 5.1.2.1591 Beta
Mar 12, 2015
- A bugfix when generating sqlquery
New in LazSqlX 5.1.2.1590 Beta (Mar 11, 2015)
- MsSql: Stable dblib put back to package because the current one has problems with varbinary fields
- DatabaseCloner: Improvements in CopyData (tested from Mssql to MySql,Firebird,Sqlite)
- Other bugfixes
New in LazSqlX 5.1.1.1589 Beta (Mar 11, 2015)
- Show another progressbar for rows when copying data (DatabaseCloner)
- Bugfixes
New in LazSqlX 5.1.1.1586 Beta (Mar 6, 2015)
- New: Holding Ctrl and clicking on a word in queryeditor: if it’s a tablename or a procedurename will open table deisnger or execute procedure dialog
- Fix: Caret position info
- Fix: committing transaction when sql query didn’t return a resultset
- Fix: Procedure names added back to Autocomplete list
- Fix: Now you can connect to MySql with Sqldb too. It was limited to Zeos only
New in LazSqlX 5.1.0.1577 Beta (Mar 3, 2015)
- SQLite improvements:
- Sqlite foreign key extraction from ddl [AsSqliteMetadata]
- Better field type mapping when cloning to Sqlite from other database types [sqlite]
- New data types added for Sqlite3: varchar,datetime[sqlite]
- Fix field length [AsSqliteMetadata]
- DatabaseCloner:
- Improvements in cloning to Sqlite (creates constraints,better data type mappings)
- Added option to create or not the foreign key constraints
- Added option to copy data (experimental)
- Note: except for Sqlite, constraints will be created after copying data. When you have constraints in your source db when cloning to sqlite, expect failure in copy data.
- Firebird:
- Firebird embedded libraries included
- GUI:
- TableList in UI changed to Treeview with expandable table items
- Changed some colors
- Icon(s) changed
- and bugfixes
New in LazSqlX 5.0.0.1570 Beta (Feb 23, 2015)
- PostgreSQL support
- Bugfixes
New in LazSqlX 4.7.2.1535 Beta (Feb 14, 2015)
- New:
- Help added (basic descriptions of features), accessible through MainMenu->Help
- Row/Col cursor position of active tab displayed in the statusbar
- FormatQuery added (very basic)
- NewConnection for each opened tab (so execution threads won’t interfere with other tabs’ connections)
- Execution time info and record count in statusBar is updated according to tab’s last execution time, when tab is changed
- Ability to stop execution of active tab’s query
- TableDesigner shows if a column is autonumber/identity
- Fixes:
- Commiting updates when data was being edited through table->RightClick->”Open” into new tab
- Autocomplete items (reading table aliases in query editor) when loading session and generating query
- Database Cloner re-enabled (some testing done with mssql’s AdventureWorks sampel db, converting it between different database types)
New in LazSqlX 4.7.1.1531 Beta (Feb 2, 2015)
- Fix AsDbForm: AsDbSpinEdit didn’t work with negative values and with mssql decimal types
New in LazSqlX 4.7.0.1530 Beta (Jan 30, 2015)
- Fixed column length not showing in table designer
- Fixed memory leaks
- In AsDbForm added new db-aware control (numeric up down) for numbers
New in LazSqlX 4.6.3.1526 Beta (Dec 10, 2014)
New in LazSqlX 4.6.3.1525 Beta (Dec 2, 2014)
- When connecting to Oracle the default selected dbEngine is Zeos because sqldb has some problems with blob fields.
New in LazSqlX 4.6.3.1524 Beta (Nov 28, 2014)
- Fix: Copy Selected Rows as SQL Insert Script (on context menu of queryTab grid) caused application to crash
New in LazSqlX 4.6.3.1523 Beta (Nov 28, 2014)
- Fix: DataImporter was broken after refactorings
- Fix: Preview Image fields on DblClick on queryTab result grid didn’t work
- Fix: there was a memory leak in FileTypeDetector (used fro Blob field filetype detection and preview)
New in LazSqlX 4.6.3.1522 Beta (Nov 27, 2014)
New in LazSqlX 4.6.3.1520 Beta (Nov 25, 2014)
- A memory leak fix
- Fix for SQLDB’s TMSSQLConnection “Error 20019 : Attempt to initiate a new Adaptive Server operation with results pending” (happened
- sometimes)
New in LazSqlX 4.6.3.1519 Beta (Nov 24, 2014)
- Bugfixes: After running a query multiple times repeatedly,it threw an unhandled exception previous
New in LazSqlX 4.6.3.1518 Beta (Nov 24, 2014)
- BugFix ConnectionForm: When server couln't be found, unhandled exception occured in listing databases
- Printing query result now displays from tablename as report title when possible instead of tab caption
New in LazSqlX 4.6.3.1515 Beta (Nov 21, 2014)
- Refactorings, one connection used everywhere
- Performance Tuning
- Bugfixes
New in LazSqlX 4.6.2.1494 Beta (Nov 20, 2014)
- Added Load/Save Session (Query History)
- Saves queries of tabs when disconnecting from server or closing LazSqlX and reloads them on connect
- Added Clean Session History on main menu under File
New in LazSqlX 4.6.1.1489 Beta (Nov 19, 2014)
- Fix QueryDesigner: drag&drop from field of one table to a field in another table was causing app to hang
- Fix Find&Replace Dialogs were accessible even after disconnect thus ‘causing access violation when used because of no activetab was available
New in LazSqlX 4.6.0.1483 Beta (Nov 13, 2014)
- Query result printing ability
- AsDbForm printing (with the ability to show/hide grid columns as you want them to appear in lazReport)
- FindReplace dialog
- MainMenu Search item added for Find&Replace dialogs
- RunProcedure dialog now returns text and excecution goes through active tab
- Trigger info can now be viewed in DesignTable
New in LazSqlX 4.5.0.1436 Beta (Oct 31, 2014)
- New: Open table as Form (more user friendly data editing )
- Bugfixes
New in LazSqlX 4.4.0.1427 Beta (Oct 25, 2014)
- Improvements/fixes:
- fixed some memory leaks
- cosmetic/layout
- File import auto mapping of field names; less memory use for large file import
New in LazSqlX 4.3.2.1401 Beta (Oct 10, 2014)
- When selecting firebird database type on connectionForm, it didn’t allow to specify host name and port number (fix)
- Other bugfixes
New in LazSqlX 4.3.1.1381 Beta (Sep 18, 2014)
- create /drop table fix (operations according to selected dbengine)
New in LazSqlX 4.3.1.1369 Beta (Sep 18, 2014)
- bugfixes
- connect/disconnect improvement
New in LazSqlX 4.3.1.1367 Beta (Sep 18, 2014)
- Some bugfixes and improvements
- MsSql icon changed
New in LazSqlX 4.3.1 Beta (Sep 18, 2014)
- Optionally connect to databases using two different database engines (sqldb or zeos). They don’t always behave the same so you choose the other one if you have problems with the first one. In other words, one that meets your needs better.
- Fix: data exporters where accidentally disabled
New in LazSqlX 4.3.0.1352 Beta (Sep 15, 2014)
- More stability improvements
New in LazSqlX 4.2.3 Beta (Sep 15, 2014)
- DataImport tool improved
- autocomplete improved (using same connection for fieldnames)
- zip archive added (in case setup.exe fails)
New in LazSqlX 4.2.2.1340 Beta (Sep 9, 2014)
- Query Execution with Firebird runs with SQLDB (new)
- Bugfix: Autocomplete wouldn’t invoke when pressing “.” after tablename or aliasname.
New in LazSqlX 4.2.1 Beta (Sep 9, 2014)
- Internal:
- Query Execution runs with SQLDB for MsSql,Oracle and Sqlite (except for Firebird and MySql). Expected result: Much more stability and improvement.
- Sqlite returns descriptive execution erros now
- Guid fields are displayed correctly in a DbGrid when connected to MsSql,Oracle (using sqldb)
- some improvements and bugfixes in select query generation
- some improvements in autocompletion
- Query Execution now works as a thread
- GUI:
- UI Tweaks
- TMemo field displays as text on DBGrid
- Grid PopUpMenu: SelectAll DBGridRows
- LoadingIndicator when queries are being executed
- Syntax Check (experimental, it works for simple syntaxes, otherwise returns some syntax error, though there may not be any)
New in LazSqlX 4.1.5.1301 Beta (Aug 29, 2014)
- QuickSearch improvements (on tables and procedures)
- Connection for MsSQL fix (if db name contained special chars)
New in LazSqlX 4.0.2.1270 Beta (Oct 19, 2013)
- Data Importer (import data from delimited text file)
- Script Create Table
- Bug fixes
New in LazSqlX 4.0.1.1232 Beta (Oct 2, 2013)
- Allow zooming of text in editor while scrolling mouse wheel while ctrl is pressed
- Fix GenerateProcedure for SelectItem
- Fix procedure list in FireBird
- Fix Running Procedure with GUI Helper for MySql,Firebird,MsSql (right-click procedure name and then “Run”)
- Known issues:
- Procedures in Oracle cannot be executed
New in LazSqlX 4.0.0.1219 Beta (Oct 2, 2013)
- Added Firebird database support;
- Bug Fixes
New in LazSqlX 3.17.3.1209 Beta (Sep 26, 2013)
- Added Recent Connections Feature (up to 10 last connections used listed)
- Added Advanced properties for Connection (in connection dialog)
New in LazSqlX 3.17.2.1197 Beta (Sep 26, 2013)
- Added a feature called Database Cloner (*partially tested for all directions except others to oracle)
- Ora libs shipped with setup are now of instantclient-basiclite-nt-12.1.0.1.0, which explains the doubled size of the setupFixes: last connection saved to temp (to avoid special permissions for running)
- Running under special permission removed
- Fixed a bug where fields containing spaces caused an exception to occur when viewing table informations and/or adding table in query designer
- Fixed a bug where Run Procedure with GUI helper in procedureList wouldn’t execute for Oracle, raising an exception.
New in LazSqlX 3.16.1.1145 Beta (Sep 19, 2013)
- Fixed a bug for MsSql mode, when "Open TableData" wouldnâ??t allow editing data in the grid
- Fixed a bug where copy rows didnâ??t copy data properly if they contained GUID
- fields (MsSql)
New in LazSqlX 3.15.1.1134 Beta (Sep 12, 2013)
- Fixed a bug where if selecting more than 4 rows in a grid, Copy As Sql Insert Script didn’t work