could be the name of your field...I think key may be a reserved word. Try
puting square brackets around the word 'key' like so: WHERE [key] = 1
------------------------------------------------------------------
Andrew Ewings
Project Manager
Thoughtbubble Ltd
------------------------------------------------------------------
-----Original Message-----
From: Aidan Whitehall [mailto:[EMAIL PROTECTED]]
Sent: 10 October 2000 16:51
To: CF-Talk
Subject: Access to SQL Server
We've upsized a database from Access to SQL Server and are going through the
applications that use it, looking for errors.
This one has cropped up...
[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the
keyword 'Key'.
Data Source = "MMnsTrans01"
SQL = "UPDATE Counter SET UID = (UID+1) WHERE Key = 1"
There is on record in Counter with
Key UID
1 10435
Does anyone know the correct syntax for SQL Server or do you have to do the
select first, then add one and do the update separately?
Thanks
--
Aidan Whitehall <[EMAIL PROTECTED]>
Netshopper UK Ltd
Advanced Web Solutions & Services
http://www.netshopperuk.com/
Telephone +44 (01744) 648650
Fax +44 (01744) 648651
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
