Hi all

I have a small problem - we are currently using IB server version 6
but I decided to test out Firebird recently and discovered that the
word "BREAK" is a keyword on that engine and will cause problems.
Unfortunately we have a table with a field named BREAK which works on
Borland's engine, but not Firebird.

To prepare a query with this word in the SELECT clause I need to
double-quote it, eg
SELECT FIELD1, FIELD2, ... "BREAK", FIELDN, ....

and attempting to post the record will fail because of the internals
of IBO will use the SQLName property to generate it's DSQL, which
does not have the double quotes on it.

So all I want to know is there a quick way to get this working. Maybe
there is a string property in IB_Connection I can use
(ColumnAttributes?) to override individual field names? Something
like:
MYTABLE.BREAK=MYTABLE."BREAK"

Some more keywords may start appearing in the future so I'd rather
have this kind of easy override mechanism rather than renaming
database fields (and updating all the source code).


Btw I am using Dialect 3.

Thanks in advance,

Paul.