This discussion is archived
1 Reply Latest reply: Dec 14, 2012 12:36 AM by Christian.Shay - Oracle RSS

Vs 2010 Query Builder

944846 Newbie
Currently Being Moderated
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 Pro
    Currently Being Moderated
    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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points