case sensitive firebird db fields

rbuser

Hi,
The problem is that unless a field contains a space, the sql that is
generated by Reportbuilder does not have quotes around it. This is a problem
because my Firebird db is case sensitive. I have field names like 'Name'.
Without a quote around it, IBO will convert the field to NAME which the
firebird db rejects ... please help ... this is a complete 'show stopper'
for me and I have to deliver my product by the end of next week !!

Regards

Paul Newman

digitalmetaphors

Try setting the CaseSensitive property on the Designer.Datasettings to true.

With Kbmtable and its DADE plugin out of the equation, can you use straight
IBO directly with the daIBO plugin to create a query dataview?


Cheers,

Jim Bennett
Digital Metaphors

rbuser

Hi Jim,
I couldn't install the IBOBJECTS dade but I have managed to hack the RB code
in a couple of places to get this scenario working .... Basicly you guys are
not putting quotes around things unless they have non alphanumermic
characters in them. If the field name is case sensitive (such as in FB
dialect 3) the field names are interpreted as upper case and a exception is
thrown.

Kind Regards

Paul Newman

digitalmetaphors

What changes did you make to our source to fix the problem? Did you have to
change any reserved words to get it to work? See
RBuilder\Source\daSQLReservedWords.pas.

Sorry, you said IBO in your first post, so I thought you had a setup like
this:
MyFireBirdDB -> IBO -> KbmMemTable -> KbmDADE -> Report

Is SQL2 set as the datatype on the TppDesigner.DataSettings property?

We've tested Interbase for DADE and Dialect 3 without problems. We have not
tested with Firebird and Dialect 3. We have successfully tested these on a
dialect 3 Interbase 6.03 database using the full end user solution for
reporting, including the data dictionary and report explorer:
IBX 6.03
IBO 4.2.H.a

Can you reproduce the problem using the Interbase end user demo in the
RBuilder\Demos\End User Databases folder? Please send a zipped example to
support@digital-metaphors.com and we can research what may be causing the
problem.

Cheers,

Jim Bennett
Digital Metaphors