Unified Interbase V1.0 RC3 (2003-06-14) UPDATED

 

UIB is a set of components to use Interbase, FireBird and YAFFIL.

These components were born from the need to use Interbase, FireBird or Yaffil indifferently as fast as possible in a Multithreading environment, a Server for example.

UIB include a Borland Compliant conversion API for Interbase, FireBird and YAFFIL.

UIB Include a Client Server ORB (Object Request Broquer) working with Indy.

UIB include 5 components at this time:

  • TJvUIBDatabase.
  • TJvUIBTransaction.
  • TJvUIBQuery.
  • TJvUIBBackup.
  • TJvUIBRestore.

 These components are "Thread-Safe" with any version of Interbase, FireBird and Yaffil and are working with Delphi, BCB & Kylix.

History

2003-06-14
  • A bug corrected with string param.
2003-06-12
  • Corrected: AsVariant with boolean data types.
  • Missed methods added (AddCurrency, AddBoolean).
  • Added: Execute method on TJvUIBQuery (see data pump example).
  • Transaction can lock more than one table (ex: LockRead := 'Table1;Table2 ...').
  • New Compiler Options:
    - FB103: Firebird 1.03.
    - UIBLANG_EN: UIB messages in English (Default).
    - UIBLANG_FR: UIB messages in French.
    - UIBNOCOMPONENT: Use class instead of components.

    Contact me to add your language.

    		•
    2003-06-08
  • Added Currency Data Type.
  • Added Boolean Data Type.
  • Added UseCursor: boolean property on TJvUIBQuery (see cursor example).
  • Added OnError: TEndTransMode property on TJvUIBQuery to define what to do on transaction when error occur (see cursor example).
  • AddBlob renamed with ParamAddBlob.
  • Added ParamReadBlob.
  • Added ParamSetBlob.
  • First Release Candidate: V1.0 RC1
    		•
    2003-05-31
  • A bug corrected when adding a blob parametter from a stream (too many data are saved).
    		•
    2003-05-29
  • Minor design update.
    		•
    2003-05-14
  • Bug corrected when adding an empty string parametter to Query.
    		•
    2003-05-07
  • Threaded Query sample modified.
  • Disconnecting Database now close transactions properly when needed.
    		•
    2003-05-03
  • Minor bug corrected on TJvUIBQuery.ExecSQL.
    		•
    2003-04-25
  • UIB working with Kylix 3.
  • New compiler option: "FBEMBED" to use FireBird 1.5 Embed. ("FB15" must be defined).
  • Database Handle property, set this property with the handle of another IB Database Component to migrate to UIB easier.
    		•
    2003-04-20
  • New compiler option: "UIBTHREADSAFE", desactivate multithreading to retrieve records faster. (single thread applications only)
  • New TJvUIBQuery property: "BufferChunks" to allocate memory faster when "CachedFetch" property is set to True.
    • 2003-04-16
  • Minor update to retrieve faster (27.5%) a field by his name.
    • 2003-04-15
  • BCB6 compatibility improved.
  • A bug with VARCHAR Type corrected.
    • 2003-04-12
  • align="left">Read Blob as Variant.
  • A minor bug corrected on a Blob function.
    • 2003-04-11
  • Automation sample to use with Excel, VBScript ...
    		•
    2003-04-10
  • Now work with BCB6
  • New components: TJvUIBBackup & TJvUIBRestore.
    • 2003-03-29
  • UIB now work with Delphi 5.
    		•
    2003-03-26
  • UIB now work with YAFFIL.
    		•
    2003-03-18
  • Now blobs can be fetched in a TSQLResult (See FetchBlob Property).
    		•
    2003-03-16
  • UIB now include an ORB working wtih Indy (See Client/Server sample).
    		•
    2003-03-12
  • Synchronisation corrected with multi-database connections.
    		•
    2003-03-11
  • UIB Will be included to JVCL 3.0, Components are now compliant to JVCL Specifications.
  • QuickScript property on TJvUIBQuery.
    • 2003-03-07
  • Read/Write Blob.
  • Fields by name.

    • Why to use UIB ?

    • You need a fast access to database.
    • You need a threaded access to database.
    • You want to use indifferently Interbase, FireBird or Yaffil.

    Which version of Database are supported ?

    • Interbase 6.00, 6.01, 6.02, 6.5, 7.0.
    • Firebird 1.02, 1.03, 1.5.
    • Yaffil 1.0.xxx

    Which version of Delphi & BCB & Kylix are supported ?

    • Delphi 5
    • Delphi 6 & PE
    • Delphi 7
    • BCB 6
    • Kylix 3
    • Other versions are not tested.

    Compiler options:

    Edit "JvUIB.inc" and activate what you need.

    (UIB work in compatibility mode (IB6) if any option is defined.)

    • "FB102" (FireBird 1.02)
    • "FB103" (FireBird 1.03)
    • "FB15" (FireBird 1.5)
    • "FBEMBED" Firebird Embed(FB15 must be defined).
    • "IB65" (Interbase 6.5)
    • "IB7" (Interbase 7)
    • "YF867" (YAFFIL 1 build 867)
    • "INTERBASE_DYNAMIC_LINK" (Load GDS32 Dynamically) (DEFAULT)
    • UIBTHREADSAFE (DEFAULT)
    • UIBLANG_EN : messages in English (DEFAULT).
    • UIBLANG_FR : messages in French.
    • UIBNOCOMPONENT