Firebird 2.1 Field START

rbuser

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

nicocizik

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

rbuser

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

rbuser

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

nicocizik

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