Hi,
this is my first post, so I'm hoping I have all the right info for you.
My problem relates to crystal reports and writing a command which includes a new table. I've created this table on our oracle database and have given it the same select rights for the right user as all the other tables. When I create a crystal report and select this new table, data is pulled back. but when I try and select the table within a sql command, there's an error -
ORA-00941: table or view does not exist.
It's a simple 'select * from', nothing fancy, but I cannot fathom out why I can see it if I select the table directly but cannot get it to work via a command connection.
any help would be appreciated
this is my first post, so I'm hoping I have all the right info for you.
My problem relates to crystal reports and writing a command which includes a new table. I've created this table on our oracle database and have given it the same select rights for the right user as all the other tables. When I create a crystal report and select this new table, data is pulled back. but when I try and select the table within a sql command, there's an error -
ORA-00941: table or view does not exist.
It's a simple 'select * from', nothing fancy, but I cannot fathom out why I can see it if I select the table directly but cannot get it to work via a command connection.
any help would be appreciated