Delete Record.

Results 1 to 4 of 4

Thread: Delete Record.

  1. #1
    Reet Guest

    Default Delete Record.

    I can&#039t delete a record from database by selecting autonumbering ID in the database field. And it always shows the Error:<BR>"Data type mismatch in criteria expression"<BR><BR>This is my SQL statement:<BR>DataCmd.Commandtext = "DELETE * From students Where ItemId = &#039" & "24" & "&#039"<BR><BR>Anything help?<BR>

  2. #2
    Steve F Guest

    Default RE: Delete Record.

    remove the qoutea around the number..<BR><BR>"DELETE * From students Where ItemId = 24"<BR><BR>

  3. #3
    Steve F Guest

    Default RE: Delete Record.

    remove the qoutea around the number..<BR><BR>"DELETE * From students Where ItemId = 24"<BR><BR>

  4. #4
    Jaska Guest

    Default RE: Delete Record.

    Incorrect syntax.<BR>Try:<BR>"DELETE From students Where ItemId =24" (without asterisk)


Posting Permissions

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