Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Updating data in progress using ODBC

Status
Not open for further replies.
IsraelBermejo

IsraelBermejo

Programmer
Aug 28, 2015
1
US
hello i am trying to run an update but i keep getting a syntaxt error
ERROR [42000] [DataDirect][ODBC PROGRESS driver][PROGRESS]Syntax error (7587)

here is my update query
UPDATE pub.itemattr SET itemattr.attrvalue = '21' WHERE pub.itemattr.ITEM = 'testitem'

i have no problem runing a select query but the update doesnt seem to work

does anyone have any idea how to get the update to work?

Thanks
 
Status
Not open for further replies.

Similar threads

FloteBoat
  • Locked
  • Question
Progress SQL IDE
Replies
0
Views
211
FloteBoat
FloteBoat
BJZeak
  • Locked
  • Question
Technical Progress I/O Question
Replies
0
Views
197
BJZeak
BJZeak
SteveTheDBA
  • Locked
  • Question
Is a Progress userid required for Cyberquery?
Replies
0
Views
212
SteveTheDBA
SteveTheDBA
bordway
  • Locked
  • Question
Remote ODBC connection to 10.1B that is running on XP test installation
Replies
2
Views
230
bordway
bordway
localjester
  • Locked
  • Question
Searching for data in an extent
Replies
1
Views
112
localjester
localjester

Part and Inventory Search

Sponsor

Back
Top