access thread: Insert Statement with Access 2000
Message #1 by "niraj sharma" <nsharma@y...> on Fri, 30 Mar 2001 14:45:33
|
|
My SQL statement below is giving me a problem:
strSQL = "Insert into members (" & strNames & ") VALUES (" & strValues
& ") where id = '" & ProspectID & "'"
The error it is returning:
Insert into members
(greet,fname,lname,email,phone,city,state,website,industry,stages,interests
,comments,MemberType,DateJoined,ipaddress) VALUES
('Mr.','Prospect2','asd','ads','ad','sd','sd','sd','sd','Preseed','Business
Modeling','sdsd','Entrepreneur','3/30/01 8:27:46 AM','66.26.88.21') where
id = ''
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Missing semicolon (;) at end of
SQL statement.
?
Message #2 by "John Ruff" <John_Ruff@m...> on Fri, 30 Mar 2001 06:40:30 -0800
|
|
Add a semicolon at the end of the strSQL statement.
...& ProspectID & ";"
John Ruff - The Eternal Optimist :)
-----Original Message-----
From: niraj sharma [mailto:nsharma@y...]
Sent: Friday, March 30, 2001 2:46 PM
To: Access
Subject: [access] Insert Statement with Access 2000
My SQL statement below is giving me a problem:
strSQL = "Insert into members (" & strNames & ") VALUES (" & strValues
& ") where id = '" & ProspectID & "'"
The error it is returning:
Insert into members
(greet,fname,lname,email,phone,city,state,website,industry,stages,interests
,comments,MemberType,DateJoined,ipaddress) VALUES
('Mr.','Prospect2','asd','ads','ad','sd','sd','sd','sd','Preseed','Business
Modeling','sdsd','Entrepreneur','3/30/01 8:27:46 AM','66.26.88.21') where
id = ''
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Missing semicolon (;) at end of
SQL statement.
?
|
View Cart
