unable to delete from SQLCE 2005

• dohomebiz

  SSC Enthusiast

  Points: 119

  More actions

  March 6, 2010 at 7:24 am

  #212137

  I am trying to delete record form SQL CE 2005 in my program, I am writing the following statement

  sSQL = "Delete * from detail where order_no = '" & OrderNumber & "' and Item_no = '" & sDSItemNo & "'"

  cmd.CommandText = sSQL

  cmd.ExecuteNonQuery()

  and I get the folllowing error:

  There was an error parsing the query. [ Token line number = 1,Token line offset = 8,Token in error = * ]

  Then I ran the query from within the SQL Server Mgmt Studio

  Delete * from detail where order_no = '0104524' and item_no = 'BT REPL 2%'

  and got the same error as follows

  Major Error 0x80040E14, Minor Error 25501

  > Delete * from detail where order_no = '0104524' and item_no = 'BT REPL 2%'

  There was an error parsing the query. [ Token line number = 1,Token line offset = 8,Token in error = * ]

• Neal Sivley

  SSCommitted

  Points: 1766

  More actions

  March 10, 2010 at 1:34 pm

  #1131641

  Try This

  sSQL = "Delete detail where order_no = '" & OrderNumber & "' and Item_no = '" & sDSItemNo & "'"

  cmd.CommandText = sSQL

  Thanks,

  Neal