Subject Re: [IBO] IB_Import and reserved words
Author Helen Borrie
At 07:16 PM 9/12/2005 +0000, you wrote:
>Hi there
>I am using IB_Import, but am having trouble as of the columns names are
>reserved words.
>Now, normally I simply quote them and IB-Objects understands them
>fine, but
>with IB_Import
>doesn't seem to work?
>I am including the column names in the first line of the text file to
>import, and
>have tried using quotes there, but still same problem...

Double-quotes have a special (non Fb/IB) significance in text data
files. AFAIK, it should be enough to put quotes around the offending field
name in your FieldList property.

If that still excepts, try removing the header line altogether and defining
your own list of (legal) field names in the FieldList property. They can
be Huey, Dewey and Louie or whatever you like, as long as they are in the
right order.

That said, its impossible to tell from your problem description whether you
are getting trouble because of the source record definition or your
destination table definition. You don't actually say what exception you
are getting, either.

If the latter - that the insert or update statement being constructed by
the component causes an exception - it could be one of the following:

1) Your database is dialect 1. In that case, a quoted identifier won't be

2) The possibility that Delphi has an extra problem with a **column name**
of "DEFAULT" at some level of parsing, since this is also a keyword in
Delphi and Delphi doesn't have any special syntax for making illegal
keyword use legal.