My guess is you're using a IB6, dialect 3 database, right? Dialect 3 is case
sensitive. If you've created your table with case (in this case, lowercase),
you have to address it as such: select * from "his"

The quotes force IB to use the case you're using. If you do: select * from
his - it will automatically think no case is used and convert to uppercase.

I would search for a setting in QuickDesk that removes the case if you don't
want it (allways uppercase or so) ... If you cannot find one, use InterBase
Workbench, it has such an option :)

--
Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com

Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."

""Leeway"" <lee@...> wrote in message
news:9jhjeh+ivtd@......

> In a database I have several tables.
> But if I try a select on one specific table I got the 'table unknown'
> error.
> In Quickdesk I see the table and can do everything with it.
> The only difference I can see with the other tables is that the name
> of this table is in lowercase.
> The name is 'his' in state of 'HIS'
> I searched everywhere but could not find a command to change the name
> of a table.
> So my three questions :
>
> 1) is IBO case sensitive for tablenames ?
>
> 2) how can I change the name of a table ?
>
> 3) if IBO is not case sensitive what could then the reason be for
> this 'table unknown' error ?
>
> Lee
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>