UPDATE query gives Incorrect Syntax error
- From: Chris Kennedy <chrisk@xxxxxxxxxxxxxxxxx>
- Date: Mon, 25 Aug 2008 23:43:06 -0700 (PDT)
Hi all
I'm running SQL Server 2005 Express Edition.
One database
One table called Sites
Fields as follows:
id (bigint, Identity, Primary Key)
SiteName (varchar(50), allows nulls)
Generation (float)
LastUpdated (varchar(50), allows nulls)
At present there are only three records in this table.
My VB application connects via ODBC (using Named Pipes) no problems.
SELECT queries run as expected and return appropriate records.
When I run an UPDATE query like this one:
UPDATE Sites SET (Generation = 44) WHERE (SiteName = 'Test')
I get the following error:
-2147217900 [Microsoft][ODBC SQL Server Driver][SQL
Server]Incorrect syntax near '26'.
Now the funny thing is that the field LastUpdated did contain
'26/08/2008' but I have changed the field value and still get the same
error message.
Restarting SQL Server does not fix the problem nor does rebooting the
machine.
The query works perfectly from inside the Management Studio but not
via ODBC.
The ODBC connection is fine so I don't think this is a security/
permissions problem.
I'd appreciate some advice.
Chris
.
- Follow-Ups:
- Re: UPDATE query gives Incorrect Syntax error
- From: Erland Sommarskog
- Re: UPDATE query gives Incorrect Syntax error
- Prev by Date: Re: large data : how do you store multidimensional data ?
- Next by Date: Re: UPDATE query gives Incorrect Syntax error
- Previous by thread: large data : how do you store multidimensional data ?
- Next by thread: Re: UPDATE query gives Incorrect Syntax error
- Index(es):
Relevant Pages
|
