This content has been marked as final. Show 1 reply
user6231851 wrote:What's the error you are getting?
i'm using oracle 126.96.36.199 32 bit with vs2010 sp1.
I'm developing a windows application and i create a dataset file in order to map my db on it.
I want to add a custom select to a table adapter a i notice a problem.
My query is: SELECT simulatori.SEQ1.nextval FROM dual
simulatori is an oracle db and seq1 is a sequence.
If seq1 has a public synonym the query works, instead, if i want to specified the user also Query Builder quotes the simulatori user and the query doesn't work.
Edited by: user6231851 on 5-dic-2012 11.26
Not sure what you mean by "quotes the simulatori user". If you mean that it adds quotations in the query, then make sure that you are providing all upper case, eg "SIMULATORI". Otherwise, the quotes may trigger case sensitivity. That's just a guess. I will need more information.