TableAdapter query signature hides the params of an "insert with select" sql query RRS feed

  • Question

  • Hi, 

    I have a TableAdapter with an sql query which copy a table record with one column changed, and it goes like this:

    INSERT INTO Users (userID, userName, userAddress, userPhone)

       SELECT :newUserID, userName, userAddress, userPhone

       FROM     Users

       WHERE  userID = :sourceUserID

    The only problem is the the params ":newUserID" and ":sourceUserID" doesn't appear in the query signature (the query appears with no params at all).


    What is the reason for that, am I doing anything wrong ?

    Thanks, Alon.



    Sunday, June 20, 2010 8:07 AM