Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Posts
    2

    Unanswered: Update in SqlServerCE 2.0

    Hello,
    I'have this SyBase and SQL Server example update query:

    UPDATE Table1 SET
    Table1.Col1 = Table2.Col1 + Table2.Col2
    Table1.Col2 = -1
    FROM Table2
    WHERE Table1.Id = Table2.Id

    If i try to execute this query under SqlServerCE 2.0 i get this error message:
    Native Error25501)
    Description: There was an error parsing the query.

    How can i write this query for running it under SqlServerCE 2.0?

    Many Thanks in advance!!!
    Mauro

  2. #2
    Join Date
    Jan 2004
    Posts
    2
    Sorry...i've found the solution of the problem.

    Simply, in this version (SqlServerCE 2.0) the FROM clause used in UPDATE query isn't supported.

    Hi!

    Mauro

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •