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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Help with Update Query

Status
Not open for further replies.
byrne1

byrne1

Programmer
Aug 7, 2001
415
0
0
US
I am running PSQL v8.6 and I am trying to update values in one database based on the results of a SQL statement. My SQL is shown below but when I try to run it I get an "syntax error" message (indicates the error is between the last two parenthesis).

Can someone please help me on this one?

update item set webxmitflag='Y', webitemflag='Y' where (SELECT eventln.itemnum,webitemflag FROM "EVENTLN","item" where eventmode='R' and item.itemnum=eventln.itemnum
and (webitemflag<>'Y' and webitemflag<>'I'))
 
Status
Not open for further replies.

Similar threads

Tabled
  • Locked
  • Question
Periodically run an SQL update statement 1
Replies
9
Views
126
mirtheil
mirtheil
Ambientguitar
  • Locked
  • Question
Need help opening a Pervasive Database or BTR files
Replies
3
Views
93
mirtheil
mirtheil
soocallmebrady
  • Locked
  • Question
Pervasive SQL Update with Joins - Error: Unknown table or correlation name
Replies
0
Views
62
soocallmebrady
soocallmebrady
mSportsman
  • Locked
  • Question
C# Pervasive Data Provider Update command causing Syntax error, but not on development machine.
Replies
5
Views
66
mirtheil
mirtheil
EasyBoy2
  • Locked
  • Question
Slow pervasive query
Replies
0
Views
24
EasyBoy2
EasyBoy2

Part and Inventory Search

Sponsor

Back
Top