t_objectresource.resource issue

[Marianne]

if I run the query 'select * from t_objectresource' one of the fields I get is 'Resource' (in uppercase for first letter, the rest lowercase)

I want to run a query like this:
SELECT  t_objectresource.Resource,   t_objectresource.PercentComplete, count(*)
FROM t_object, t_objectresource
WHERE t_object.Object_ID=t_objectresource.Object_ID AND t_object.Phase='1.1'
GROUP BY  t_objectresource.Resource,  t_objectresource.PercentComplete

But then I get the error ORA-01747: invalid user.table.column, table.column, or column specification.

I tried name instead of resource but it doesn't work either.  

Thanks for your help!

[Helmut Ortmann]

I tried it with *.eap (JET 4) and SQL Server. It works fine.

Helmut

[qwerty]

Try the SELECTs single to find what's wrong. E.g.

Code: [Select]

SELECT * FROM t_objectresourcethen

Code: [Select]

SELECT  Resource FROM t_objectresourceetc.

to see where it fails.

q.

[hd]

Resource is an Oracle keyword. Wrap it in double quotes...

Code: [Select]

SELECT  "Resource" FROM t_objectresource