Dataset Designer Generated Code Syntax Error. Bug? RRS feed

  • Question

  • Hi.

    I'm using VS2008 and SQL CE 3.5, building a smart client app.  When I add a table adapter with this code:

    UPDATE feeders
    SET planningAreaID = @areaID
    WHERE feeders.transformerID IN
    (SELECT     Transformers.ID
    FROM         Transformers INNER JOIN
                          Substations ON Transformers.SubstationID = Substations.ID
    WHERE substations.districtID = @districtID)

    the designer writes a bunch of syntax errors to the generated code.  If I run the code directly on the DB it works fine.  Also, if I use only one or the other parameter it works fine - when I add both parameters I consistently get 7 lines of syntax error code in the designer.

    Does anyone have any suggestions or feedback?  Thanks.

    • Moved by Edwer Fang Tuesday, June 1, 2010 7:54 AM (From:Visual Studio Database Development Tools (Formerly "Database Edition Forum"))
    Thursday, May 27, 2010 9:42 PM

All replies