[Dbexpressplus-user] dbExpress Plus Ver 1.10 Beta 1 Released

[Thomas M. <tm...@bs...>]

dbExpress Plus is an extension of the dbExpress component suite shipped 
with Borland products (Delphi, Kylix, and C++ Builder). The "Plus" suite 
includes: TSQLConnectionPlus, TSQLScript, TSQLMetaData, TSQLDataPump, 
TSQLMultiDbQuery, and others. We are looking for someone to help
with a Kylix version of this suite.

http://sourceforge.net/projects/dbexpressplus

Want to help? Contact Thomas Miller at tm...@bs....

Other resources:

http://sourceforge.net/projects/dbexpressplus
news://newsgroups.borland.com/borland.public.delphi.database.dbexpress

Known Issues:
*VERY IMPORTANT* - If you have been using TSQLConnectionPlus attached
to a TSQLMonitor, you must first remove TSQLMonitor from any and all
forms before updating to dbExpress V1.0 or above.

TSQLConnectionPlus - The coFloatIntegersToFmtBCD does not work and there 
is a bug. The issue lies with meta data retrieval. Most meta data flags 
are returned as INT32 data types. When these are changed to FmtBCD, 
errors occur. We will try to find a way to distinguish meta data fetches 
vs user data fetches to remove the problem.

Beta 1 is nearly feature complete. The one feature still being worked on 
is custom locale separators for TSQLDataPump. Most users will not run 
into any problems and don’t need this feature. RC1 should have this 
implemented.


dbExpress Plus Version 1.10 Beta 1

============================================================

Problem:
Design Issue - There is not enough separation between classes. Add a new 
"custom" layer to all components.

Note:
Custom layer is in dbExprPlusCustom and includes a bit of Borland source 
code. Users must contact one of the administrators to get the source for 
this file. We are trying to get permission from Borland to redistribute 
the file source openly.

Contributor(s):
Thomas Miller
============================================================

Problem:
No support for TSimpleDataSet.

Note:
New control added: TSQLSimpleDataSet.

Contributor(s):
Stefan Diestelmann

============================================================

Problem:
TSimpleDataSet has certain limitations in its design. A new componet, 
TSQLCompleteDS was added.

Note:

Contributor(s):
Armando Dettmer
============================================================

Problem:
Bug - In DBNavPlus, if ApplyUpdates failed, the button would still be 
disabled even though there are changes pending.

Note:
Code added
if TClientDataSet(aMasterDataSet).ChangeCount = 0 then
Buttons[nbApplyUpdates].Enabled := False;
Contributor(s):
Georg Rehfeld
============================================================

Problem:
Design Issue - TSQLConnection Plus code has been moved to 
dbExprPlusCustom and dbExprPlus units.

Note:
TSQLConnectionPlus.pas unit will be removed in dbExpress Plus v1.2.

Contributor(s):
Thomas Miller
============================================================

Problem:
Design Issue - SQLMetaData's code needed scrubbing and fine tuned.

Note:
There are several experimental functions and procedures that are left in 
place and will be finalized in v1.2

Contributor(s):
Armando Dettmer

============================================================

Problem:
Bug - EOF is reported on open of TClientDataSet and does not calculate 
the first field. Core dbExpress updated to me more sensitive to EOF and 
now calculates first field.

Note:
Problem reported as QC #1328

Contributor(s):
Bob Swart, Armando Dettmer

============================================================

Problem:
Design Issue - Record count only worked on simple SQL statements. 
Algorithm updated to work on SQL statements with multiple tables and 
Where, Group, and Order By clauses.

Note:

Contributor(s):
Armando Dettmer

============================================================

Problem:
New feature - Macro Support

Note:
Surfaced in TSQLQuery, TSQLMulitDbQuery, and TSQLScript

Contributor(s):
Bogdan, Armando Dettmer
============================================================

Problem:
Design Issue - TSQLDataPump redesigned and organized to use code more 
efficiently.

Note:
About 80% of the code has been changed

Contributor(s):
Armando Dettmer, Thomas Miller
============================================================

Problem:
Bug - TSQLDataPump would fail on large Ascii Imports.

Note:
Originally the algorithm imported field by field, and would eventually 
get out of sync. The new algorithm does import on a record by record 
basis, which keeps the import in
sync for very large files.

Contributor(s):
Armando Dettmer, Thomas Miller
============================================================

Problem:
Bug - CSV was not properly supported.

Note:
The only "Feature" of CSV not supported is double quotes within a 
string. Line Feed and Carriage Returns are supported within a field.

Contributor(s):
Thomas Miller
============================================================

Problem:
New Feature - You can now export data as SQL Insert Statements.

Note:

Contributor(s):
Thomas Miller
============================================================

Problem:
New Feature - New BeforePump, BeforeRecordPrepare, BeforeRecordPump, 
AfterRecordPump, and AfterPump events added.

Note:
Before Field pump was deprecated.
Contributor(s):
Thomas Miller
============================================================

Problem:
New Feature - New TSQLBufferFileStream, and TSQLBufferStr classes 
implemented for buffering Ascii Import file stream.

Note:

Contributor(s):
Thomas Miller
============================================================

Problem:
New Feature - TSQLDataPump now recognizes foreign decimal separators.

Note:
Still being implemented

Contributor(s):
Armando Dettmer , Thomas Miller



-- 
Thomas Miller
Delphi Client/Server Certified Developer
BSS Accounting & Distribution Software
BSS Enterprise Accounting FrameWork

http://www.bss-software.com
http://sourceforge.net/projects/dbexpressplus

-- 
Thomas Miller
Delphi Client/Server Certified Developer
BSS Accounting & Distribution Software
BSS Enterprise Accounting FrameWork

http://www.bss-software.com
http://sourceforge.net/projects/dbexpressplus