Query problem on table named 'resource'

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

phoenix_me - 26 Sep 2007 12:45 GMT

I can't execute query which is 100% right. It is accepted in different
programs but not in excel (Microsoft Query)
The Query is:

select * from PUB.Resource

I think that the problem is because table name is Resource, and this
is reserved word either in SQL '92 or Progress Database. Any hint how
to get data from this table? Any special signs as [ ], ( ), " ", ' ', ?

Reply to this Message

phoenix_me - 26 Sep 2007 16:04 GMT

> I can't execute query which is 100% right. It is accepted in different
> programs but not in excel (Microsoft Query)
[quoted text clipped - 5 lines]
> is reserved word either in SQL '92 or Progress Database. Any hint how
> to get data from this table? Any special signs as [ ], ( ), " ", ' ', ?

I found answer myself. It's need to use aliases together with "".
So query should look like:

select * from PUB."Resource" as my_alias

Reply to this Message