Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2004
    Posts
    77

    Unanswered: Delete to (error message)

    <!--#include file="connect.asp"-->
    <%
    sql="delete top 3*from BA order by id asc"
    conn.execute(sql)
    response.write "OK"
    %>
    I got error message
    Microsoft JET Database Engine error '80040e14'
    Syntax error in DELETE statement.

  2. #2
    Join Date
    Jan 2004
    Location
    Aberdeen, Scotland
    Posts
    1,067
    you should Change your SQL Statement to

    DELETE BA
    FROM (SELECT TOP 3 * FROM BA ORDER BY id ASC) as T1
    WHERE ba.id = T1.id

Posting Permissions

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