I tried this, but in the database all the identifiers are in lowercase.
the problem does not occur when I open the table but just when the
lookupcombobox is present.
The application functioned before when I used the IBObjects evaluation.

----- Original Message -----
From: Helen Borrie <helebor@...>
To: <IBObjects@yahoogroups.com>
Sent: Friday, September 14, 2001 9:36 AM
Subject: Re: [IBO] TIBO and dialect 3


> At 08:37 AM 14-09-01 -0300, you wrote:
> >Hi people!
> >Sorry my poor english.
> >
> >I have a problem using TIBOTable and interbase in dialect 3.
> >If I use a lookupcombobox apears an error: fieldname xxxx not found.
> >This does not occur if in dialect 1.
>
> Diego,
>
> In Dialect 3, all identifiers (table names, column names, generator names,
etc.) that have been defined with double-quote delimiters are
case-sensitive. So, if you made a table
>
> CREATE TABLE "ATable" (
> "Acol1" integer not null,
> "ACOL2" varchar(10)
> );
>
> Then
> ..ATable.FieldByName('ACOL1').AsInteger
>
> or
>
> ..ATable.FieldByName('ACol2').AsString
>
> both will return this error. Correct the case of the identifier and you
will be OK.
>
> <rant>
> IMO, it's a REALLY good idea to avoid a database manager program that
forces quoted identifiers into your DDL. You DON'T NEED quoted identifiers
except on objects whose names either (1) include blank spaces or (2) use
reserved words.
> </rant>
>
> Cheers,
> Helen
>
> All for Open and Open for All
> InterBase Developer Initiative · http://www.interbase2000.org
> _______________________________________________________
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>