> 1) is IBO case sensitive for tablenames ?

Only if using an IB6 dialect 3 database and then only if the name is
enclosed in double quotes - it works the same as writing IB6 dialect 3
code.

If the actual name (in IB6 metadata) is:
TABLENAME

then you can use:
TableName, TABLeNaME, TABLENAME or "TABLENAME"

but NOT:
"TableName"


If the actual name (in IB6 metadata) is:
TableName

then this implies you created it like...
CREATE TABLE "TableName" (<etc>);

so you must use (in IBO and IB6 code):
"TableName"

to reference that table.


In both IB6 dialect 3 and IBO you must always specify the double
quotes around the name in your code so that they will be treated with
case sensitivity, otherwise they will be converted to uppercase.
Internally - in the metadata tables - the table name is stored without
the double quotes. Which is important to know if you retrieve such
names directly from the metadata.

> 2) how can I change the name of a table ?

Create a new table with the correct name, transfer all the data
across, change all the dependancies and drop the old table. AFAIK
there is no other option.

> 3) if IBO is not case sensitive what could then the reason
> be for this 'table unknown' error ?

If the above does not explain the situation then we need to know more
about what you are doing.


Geoff Worboys
Telesis Computing