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.
