Version: 1.03 last updated 15 Sep 1998 Platform: Delphi 3.0 & ODBC 3.0 Sources: not avaliable Autor: Konstantin E-mail: ksav@chat.ru or ksav@russia.crosswinds.net WWW: http://www.chat.ru/~ksav/ Description: This is ODBC data aware components It includes TmDataBase, TmQuery components. Disclaimer ---------- WARNING! THE CODE IS PROVIDED AS IS WITH NO GUARANTEES OF ANY KIND! USE THIS AT YOUR OWN RISK - YOU ARE THE ONLY PERSON RESPONSIBLE FOR ANY DAMAGE THIS CODE MAY CAUSE - YOU HAVE BEEN WARNED! license ------- This components is freeware for non-commercial use. If some of these components is used to develop software for commercial gain, then these components must be registered with me for the appropriate fee. Registration entitles you to future versions, and my support. For additional information about registration please mail me to ksav@chat.ru Copyright --------- Author: Savelyev Konstantin (ksav@chat.ru), Russia. Support ------- - ODBC 3.0 - editing query via a) internal update,insert,delete (not every drivers support it) b) use SQL statements ( like TUpdateSQL ) - Blob fields and parameters - ForwardOnly cursors (only with ODBC cursor library) NOT supported: - LookUp fields (because it slow with queries) - Transactions (you can use SQL statements) - cached updates TESTING ------- This components tested with Oracle, Informix, MySQL, Interbase, MS Access drivers. Notes ----- 1. For users, who use MySQL server: only first 3 simvols of String field are displayed. This bug of ODBC driver. If you set CursorType=ctDynamicCursor, then error has not occured. But it is necessary to make it before each opening of the cursor. Also use Odbc Cursor Library( set TmDatabase.OdbcCursors:=ocUse_ODBC ). 2. If you want to use custom 'Login Dialog', you need set TmDataBase.DriverCompletion=sdNoPrompt and use TmDataBase.OnConnect event, where you need set TmDataBase.Params property in the follow format: UID= PWD= 3. For users, who using Interbase,MySQL,MS SQL servers: set TmDatabase.OdbcCursors:=ocUse_ODBC History ------- ....... 22/08/98 - error with empty dataset fixed 24/08/98 - demo program added 28/08/98 - error with using ModifySQL fixed 08/09/98 - exceptions moved into file mExcept.pas and new Exception message dialog was added 10/09/98 - property TmDataBase.Connected moved to public area 15/09/98 - support blob parameters in mQuery