2006년 10월 25일.....릴리즈 되었군요...(중단된 줄 알았습니다.ㅋㅋ)
http://sourceforge.net/project/showfiles.php?group_id=35994&package_id=28219
에서 다운로드 가능 합니다.
BDS 2006(D10)에서 패키지 컴파일을 바로 하면 오류가 나옵니다.
2005(D9)를 참고 하여 약간의 삽질 후에 사용 해본 결과...아직은 장담을 못하지만...
SQL Server 2000/2005에 있는 데이터를 불러와 수정 해본 결과 현재 까지는 잘 되네요.
한글도 잘 되는 것 같기도 하고....
암튼 초보라 잘 모르겠구요. 고수가 사용 해 보고 어떠한 조언이 조만간 나오면 그 내용을
참고 하는게 더 좋을듯 합니다. 저는 소개 차원에서만.ㅎㅎ
필요한 사람에게는 유용한 정보가 되셨길...
----------------------------------------
1.1. Features added
LinkedFieldNames vs. IndexFieldnames (
http://zeos.firmos.at/viewtopic.php?t=796)
New Dataset features : BeforeApplyUpdates (event), AfterApplyUpdates (event), SortType (property), EmptyDataSet (procedure)
Added separate drivers for embedded Firebird server (
http://zeos.firmos.at/viewtopic.php?t=630)
Delphi 2006 packages added
Mysql5 Support added
PostgreSQL 8.x Support added
SQLite 3.x Support added
Added Sybase Adapitive Serve Anywhere (ASA) Support for Versions 7, 8 and 9.
MySQL Ping Commando added
Insert "const" for ref-counted parameter (
http://zeos.firmos.at/viewtopic.php?t=519)
MySQL Embedded Server Arguments (
http://zeos.firmos.at/viewtopic.php?t=777)
separated Firebird from interbase/strict dll loading for Firebird
TZConnection: property 'Version', showing the current version
Support for fkInternalCalcFields in datasets
Added property DesignConnection: If DesignConnection is true connected is not set to true during runtime and must be set explicitly
Enabled all connection options for mysql. Now one can add the desired options by adding them to the connections property strings.
Rewrite of ZPlainMysqlXX files to add embedded server support for versions 4.0,4.1,5 of mysql
Added new library functions to plain mysql drivers (4.1)
Added new library functions to plain mysql drivers (3.23 and 3.20)
Errorhandling for Postgres now retruns resultcodes from server
Two Phase Commit for PostgreSQL
Added parameter capability to TZSQLProcessor so you now can use paraneters inside your SQL scipts like you do in "normal" queries.
Added const "ZEOS_VERSION" to ZClasses and added property "Version" to TZConnection.
Added support of fkInternalCalcFields for ZEOS datasets.
Added property "DesignConnection" to turn off active design time connections during runtime, automatically.
Added PropertyEditor for TField-properties in several components.
Added default values to the following properties:
TZAbstractRODataset.RequestLive: False
TZAbstractRODataset.ParamCheck: True
TZAbstractRODataset.ShowRecordTypes: [usUnmodified, usModified, usInserted]
TZAbstractRODataset.IsUniDirectional: False
TZAbstractRODataset.Options: [doCalcDefaults]
TZAbstractRODataset.ReadOnly: True
TZAbstractDataset.UpdateMode: umUpdateChanged
TZAbstractDataset.WhereMode: wmWhereKeyOnly
TZAbstractDataset.CachedUpdates: False
TZConnection.SQLHourGlass: False
TZQuery.ReadOnly: False
TZTable.ReadOnly: False
TZSqlMetadata.Scope: 0
TZSqlMetadata.Nullable: False
TZSqlMetadata.Unique: False
TZSqlMetadata.Approximate: False
Changed default values for following properties:
TZConnection.ReadOnly: False
Changed following default initializations:
- TZAbstractDataset.RequestLive := True;
TZConnection.ReadOnly := False;
Changed following property names:
TZQuery.RequestLive --> TZQuery.ReadOnly
Added parameter capability to TZSQLProcessor like in TZQuery.
---------------------------------------------------------------
1.2. Patches applied
Const and optimization (
http://zeos.firmos.at/viewtopic.php?t=551)
MissingConsts, Inlining, SilentException (
http://zeos.firmos.at/viewtopic.php?t=566)
Packages for delphi 6 (
http://zeos.firmos.at/viewtopic.php?t=577)
PostgreSQL EncodeString() (
http://zeos.firmos.at/viewtopic.php?t=589)
Date, Time and Float on Lazarus (
http://zeos.firmos.at/viewtopic.php?t=598)
Updates for ZMessages (translations)
Const modifier added to function definitions where possible to improve speed (
http://zeos.firmos.atviewtopic.php?t=519)
------------------------------------------------------
1.3. Bugs fixed
ZDbcConnection.pas contains wrong line breaks (
http://zeos.firmos.at/viewtopic.php?t=553)
Other files with LF instead of CRLF (
http://zeos.firmos.at/viewtopic.php?t=554)
svn rev. 59 (Linux filenames problem) (
http://zeos.firmos.at/viewtopic.php?t=593)
error type date in lazarus (
http://zeos.firmos.at/viewtopic.php?t=574)
MySQL v.5.0 .3+ and Decimals (
http://zeos.firmos.at/viewtopic.php?t=605)
ZSqlUpdate append error (
http://zeos.firmos.at/viewtopic.php?t=677)
Error opening Query (
http://zeos.firmos.at/viewtopic.php?t=628)
Compiling in Borland C++ Builder 6 (
http://zeos.firmos.at/viewtopic.php?t=694)
compiling for delphi5/6 (
http://zeos.firmos.at/viewtopic.php?t=802)
Memory leak MSSQL2000 TZQuery.ExecSQL (
http://zeos.firmos.at/viewtopic.php?t=788)
ZEOS_TESTING_REV_113 Sybase-Bug (
http://zeos.firmos.at/viewtopic.php?t=822)
Removed Rangecheck Directive (all files) (FPC 2.0.2 is buggy)
Updated lazarus package for correct compilation. (Missing packages, corrupt package file,...)
Some more Lazarus package modifications
Memory leak bug fixed (
http://zeos.firmos.at/viewtopic.php?t=461)
Delimiter problem in ZSQLProcessor fixed (
http://zeos.firmos.at/viewtopic.php?t=527)
Fixed Delphi 5 install problems (
http://zeos.firmos.at/viewtopic.php?t=335)
Added {$LIBSUFFIX 'X0'} to projectfiles of D7 and D2006 (
http://zeos.firmos.at/viewtopic.php?t=561)
Removed ASA driver from Lazarus packages because not compilable in Lazarus.
Bug in GetIndexInfo (
http://zeos.firmos.at/viewtopic.php?t=196)
Added GetClientVersion and GetServerVersion to Connection/Driver interfaces
Integrated contribution from Terence : Added more specific metadata clearcache possibilities.
Delphi 7 : Split up Component Package into Component and ComponentDesign (
http://zeos.firmos.at/viewtopic.php?t=726)
Delphi 7 : Added compiler directives to avoid inclusion of not wanted database drivers. (
http://zeos.firmos.at/viewtopic.php?t=746)
InternalPost (Procedure) (
http://zeos.firmos.at/viewtopic.php?t=781)
Updatesql component (OnUpdate event)
Mssql Select * error (
http://zeos.firmos.at/viewtopic.php?t=788)
Added Lazarus fixes : ASA support did not compile well.
Firebird: Memory leak bug fixed (
http://zeos.firmos.at/viewtopic.php?t=461)
Corrections for non-strict dllloading
Bytea/blob - PostgreSQL - UNICODE/UTF8 (
http://zeos.firmos.at/viewtopic.php?t=683)
Integrated patch from Fduenas concerning
http://zeos.firmos.at/viewtopic.php?t=677
Mysql MetaData Patch to support temporary tables
Corrected the temporary tables patch. Now it tries to get information on a 'non-existing' table, just in case it is a temporarary one. If it is temporary the table is added to the cache If it's not, the resulting error is suppressed but the table will stay unknown.
Various modifications/extentions to Mysql DBC and Plain driver units - Written by fduenas and mdaems
Removed calls to Mysql datastructure where possible (Only necessary for mysql3.20) - written by mdaems
Bad tiReadCommited corrected (
http://zeos.firmos.at/viewtopic.php?t=570)
Widestring Fields are always returning Null if one tries to access property Value.
Firebird 1.5: field named "STATUS_REG" that doesn't show in TZDataSet.
FPC/Lazarus: Connecting to a Firebird Database will cause a Range Check Error.
Zeos appears to be bringing back Postgresql money type as ftfloat instead of ftcurrency.
Row inserting is impossible with simple queries when TZQuery.ReadOnly property set to false and no TZQuery.UpdateObject defined.
In the metadata, all user tables were being reported as type VIEW.
Problem in ZSysUtils.BytesToVar().
Problem with TZAbstractDataset.InternalPost.
When using GetPChar() Result of GetPChar() points to unallocated memory.
ZeosDBO (Ado) update problem with TZUpdateSQL
Username property not refreshed if changed in login box
Problem with TZTable refresh method
IProviderSupport - PSUpdateRecord
Firebird 1.5 Read Only Database on CD
ZQuery's FieldsEditor brings diff. types for the same field
Login Dialog unstable appearance
Wrong results for lookup fields
open cursors in Oracle
Change data when Dataset.State = dsBrowse
Exception when deleting record with ClientDataSet
Strange behaviour Zeos - DBLookUpComboBox
CreateStatement and Properties
WideString Updates
MySQL:zeos doesnt assign default '0000-00-00' to Date Fields
TZAbstractRODataset.RereadRows;
CaseSensitive locate on WideString fields
Filter issues
AV error when opening a DML with a TZQuery using doSmartOpen
Incorrect TZPostgreSQLNotify definition
Access violation on large string fields.
MySQL Date/Time bug + Fix
Firebird 1.5: unsupported datatype
Startup failing if compiled with "Full Boolean Evaluation"
SetFieldData for ftString don't refresh
ADO TDateTime parameter wrong type
TZTable's TabeleName Property - not list with ADO protocol