Problem in deleting record

Results 1 to 3 of 3

Thread: Problem in deleting record

  1. #1
    Join Date
    Dec 1969

    Default Problem in deleting record

    I have no problem in using SQL "insert" and "update" statement.<BR>But when i come to "Delete", it shows Error Message as below:<BR>Error Type:<BR>Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)<BR>[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near &#039;*&#039;.<BR><BR>Below is my SQL statement:<BR><BR>sqlDelete = "Delete * from userdetail where userID = &#039;"&uid&"&#039;"<BR>set rsdel = ObjConn.Execute(sqlDelete)<BR><BR>Do you see any error in my code? Please help.. THank you.

  2. #2
    Steve Cimino Guest

    Default RE: Problem in deleting record

    You can&#039;t use DELETE * in SQL Server... only Access. Just use DELETE FROM userdetail...

  3. #3
    Join Date
    Dec 1969

    Default RE: Problem in deleting record

    sqlDelete = "Delete from userdetail where userID = &#039;" & uid & "&#039;"

Posting Permissions

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