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

Firebird 2.1 Field START

edited May 2008 in Datapipelines
I have a Problem with the new Firebird 2.1 DB-Server

I have some tables with Fields Start, with the new Firebird 2.1 Start is a
keyword and has to be written as "START", but the SQL-Designer didn't use
the quotes for this Field!

How can i make this working?

regards
andi

Comments

  • edited May 2008
    Hi Andi,

    ReportBuilder uses the reserved word lists located in the
    daSQLReservedWords.pas file to determine whether a word is reserved or not.
    If you are using Firebird, your database type is daInterbase and the defined
    list is in the daBuildInterBaseReservedWordList routine. Try adding a new
    entry containing the 'START' keyword to this routine and see if that fixes
    the problem.

    It is on our todo list to add a Firebird specific database type for a later
    release of ReportBuilder.

    --
    Regards,

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

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited May 2008
    thank you for the fast response.

    Have i to compile the package after changing the code?
    Is there somewhere a vtch file/exe or description for how i can do this?

    regards
    andi


  • edited May 2008
    I changed the sourcecode, and inserted the path into the library path, and
    now it works.

    But, an existing report i can't change, i has everytime to remove the filed,
    save the report and than insert the field ...
    if i try to remove the field and insert the field in one step, i get the
    error on closing the modal SQL Builder Form.

    An other question is, can i prevent, that the SQL Builder uses an Alias for
    these Fields?

    if i use SELECT PA.START the SQL Builder Generates a SELECT PA."START"
    START_2

    regards
    andi


  • edited May 2008
    Hi Andi,

    Which version of ReportBuilder and Delphi are you using? I'm a bit unclear
    about the error you are receiving. If you trace into the ReportBuilder
    source, where is the error occuring? There is no way to prevent RB from
    giving your field names an alias. This is how ReportBuilder internally
    keeps track of the fields and makes sure each field name is unique. It is
    possible to assign your own alias names using the data dictionary.

    --
    Regards,

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

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
This discussion has been closed.