Missing semicolon?

Results 1 to 2 of 2

Thread: Missing semicolon?

  1. #1
    Alex T Guest

    Default Missing semicolon?

    Hi...I have an SQL statement that, when written to the screen, produces the following error:<BR><BR>INSERT INTO tblSupportRequests(ClientID, RequestType, DateTimeOpened, Status, Details) VALUES (2,&#039;Delete Email Account&#039;,&#039;2/15/01 5:21:00 AM&#039;,&#039;1&#039;,&#039;Delete email@email.com&#039;) WHERE RecordID IN(87)<BR><BR>Microsoft OLE DB Provider for ODBC Drivers error &#039;80040e14&#039; <BR><BR>[Microsoft][ODBC Microsoft Access Driver] Missing semicolon (;) at end of SQL statement. <BR><BR>Basically, my code deletes an email address from a table in the DB and then adds a message to another table to let the admin know to delete the account. Any thoughts on the missing semicolon error?

  2. #2
    Join Date
    Dec 1969

    Default just do what the error says...

    put a semicolon at the end of the sql statement!! for some reason it wants it, i&#039;ve seen it done a few times, so right after the (87) just put a lil ; there and you&#039;ll be all set...errors tell you a lot more than they seem, don&#039;t they??

Posting Permissions

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