#1  
Old 20th December 2018, 03:23 AM
dannycabreradacl dannycabreradacl is offline
 
Join Date: Dec 2018
Posts: 2
Default Simple Update statement

I am trying to do a simple update statement:


UPDATE Company SET xAccountStatus = 2, Notes = "Account is over their limit Contact Accounting" WHERE CompanyCounter = 36737

('HY000', '[HY000] The query returned an error (ODBC State: HY000)\r\rError:\rNexusDB: <unnamed TnxODBCQuery instance>: Query execution failed: \r\nError in statement: Unable to resolve the identifier "Account is over their limit Contact Accounting" at line 1, pos 48\r\n\r\n [$3CA0/15520]
  #2  
Old 20th December 2018, 10:10 AM
Eivind Eivind is offline
Administrator
 
Join Date: Mar 2008
Posts: 203
Default

Quote:
Originally Posted by dannycabreradacl View Post
I am trying to do a simple update statement:


UPDATE Company SET xAccountStatus = 2, Notes = "Account is over their limit Contact Accounting" WHERE CompanyCounter = 36737

('HY000', '[HY000] The query returned an error (ODBC State: HY000)\r\rError:\rNexusDB: <unnamed TnxODBCQuery instance>: Query execution failed: \r\nError in statement: Unable to resolve the identifier "Account is over their limit Contact Accounting" at line 1, pos 48\r\n\r\n [$3CA0/15520]
Try using single quotes instead of double?


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Simple statement leads to runtime error gsachs nexusdb.public.support.sql 3 20th January 2011 11:33 AM
Multi-Column update statement DanCroghan nexusdb.public.support.sql 0 7th December 2010 09:30 AM
Simple SQL statement Bo Nielsen nexusdb.public.support.sql 16 8th December 2005 09:29 PM
Problem with UPDATE statement Don Miller nexusdb.public.support.sql 1 16th November 2005 03:34 AM
Update Sql statement Ron Dolce nexusdb.public.support.sql 7 10th March 2004 08:20 PM


All times are GMT +11. The time now is 08:14 AM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.