Home DADE
New Blog Posts: Merging Reports - Part 1 and Part 2

DADE for FIBplus

edited September 2007 in DADE
RB Gurus,

I am trying to make work the FIBplus DADE driver that was downloaded
from the Digital-Metaphors site. It fails when extracting the
Dictionary definitions from the design time dictionary component. This
failure occurs when working against any table within Firebird that
contains a "Date" datatype. The error says something to the effect that
sqSQL01 does not support a "Date" datatype, even though the
TppDesigner.DataSettings.SQLType property is set to "sqSQL2".

Please advise. How do I get the dictionary component to successfully
process tables containing Firebird's "Date" datatype?

Regards,
Monte Carver

Comments

  • edited September 2007
    Hi Monte,

    Which version of ReportBuilder and Delphi are you using?

    We do not have Firebird however I downloaded the FIBPlus plugin and
    successfully tested the included demo with the Employee database included
    with Interbase 7.5. The DataDictionary seemed to handle a test table I
    created with a DATE field without error.

    Be sure your SQLDialect is set to 3.

    --
    Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited September 2007
    Nico Cizik (Digital Metaphors) wrote:


    It was the SQLDialect property... it was set to "1"....Thanks!
This discussion has been closed.