Forum Discussion
vbace2
14 years agoOccasional Contributor
Just to add an update to this...
I tried creating a store and selecting a table/view. When I do that, I get an error that says dbuser.mytable (or myview) is undefined. The reason is that mytable (and myview) do not live under the dbuser schema. It is automatically trying to add that to the table name. Also, if I use the custom query and I just select a table name or user name in the SQL designer, I get a message that says it is unable to find the table. Again, I am thinking it is trying to add the user that I am logged into as the schema/owner of the table. If I just type out my SQL, it works for me.
Thanks
I tried creating a store and selecting a table/view. When I do that, I get an error that says dbuser.mytable (or myview) is undefined. The reason is that mytable (and myview) do not live under the dbuser schema. It is automatically trying to add that to the table name. Also, if I use the custom query and I just select a table name or user name in the SQL designer, I get a message that says it is unable to find the table. Again, I am thinking it is trying to add the user that I am logged into as the schema/owner of the table. If I just type out my SQL, it works for me.
Thanks
Related Content
- 9 months agoLuukdb
- 4 years agoDavid91
- 5 years agoKrishna_Kumar