AZZA-KHAMEES
asked on
Microsoft OLE DB Provider for SQL Server error '80040e14' Incorrect syntax near the keyword 'User'
Hi experts
i am trying to add a new record in the table but i am getting a strange error
my code is
i dont know from where 'User' come ?
please help
i am trying to add a new record in the table but i am getting a strange error
Microsoft OLE DB Provider for SQL Server error '80040e14' Incorrect syntax near the keyword 'User'.
my code is
set chqOrs = Server.CreateObject("Adodb.Recordset")
sql="Select * from personal"
chqOrs.Open sql,oConn,1,3
chqOrs.AddNew
chqOrs("cprno")="00000005"
chqOrs.Update
i dont know from where 'User' come ?
please help
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
The problem is with sql statements,try another way for exp:
use full path of your table
like,
sql="Select * from dbo.personal"
or
sql="Select * from [user].[dbo].personal" as per your database
use full path of your table
like,
sql="Select * from dbo.personal"
or
sql="Select * from [user].[dbo].personal" as per your database
Sorry for the delays. Hopefully the network group will get to it today. I am also meeting with Mgrs. today to discuss the issue. I will let you know the outcome.
I guess that you have a column named User which is a reserved SQL word.
As you first run a Select * you will get the column names without square brackets which is normally the eay to escape reserved column names.
Please try to replace the SELECT * with
SELECT [Col1], [User],[Col3], ...
If you just need to add the record and just set one field value, this one column should be enough.
HTH
Rainer