1 Reply Latest reply: Dec 14, 2012 2:36 AM by Christian.Shay -Oracle RSS

    Vs 2010 Query Builder

    944846
      Hi guys,

      i'm using oracle 11.2.0.3 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.
      Why?

      Edited by: user6231851 on 5-dic-2012 11.26
        • 1. Re: Vs 2010 Query Builder
          Christian.Shay -Oracle
          user6231851 wrote:
          Hi guys,

          i'm using oracle 11.2.0.3 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.
          Why?

          Edited by: user6231851 on 5-dic-2012 11.26
          What's the error you are getting?

          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.