469,272 Members | 1,438 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,272 developers. It's quick & easy.

missing SET keyword

12
hi friends i am trying to upadate oracle table value by using inner join method

and the ASP code is as follows

Expand|Select|Wrap|Line Numbers
  1.  
  2. sqlupdate = "UPDATE Tbl_RequestInfo INNER JOIN Tbl_RequestSched ON Tbl_RequestInfo.ReqID = Tbl_RequestSched.RschedReqid SET " &_
  3.     "Tbl_RequestSched.RschedStatus =" & STR_Quote2(ReplaceQuote(newstatus)) &_
  4.     ", Tbl_RequestSched.RschedUpdatedby =" & STR_Quote2(ReplaceQuote(session("username"))) &_
  5.     ", Tbl_RequestSched.RschedUpdatedlast =" & curdate &_
  6.     ", Tbl_RequestInfo.ReqStatus =" & STR_Quote2(ReplaceQuote(newstatus)) &_
  7.     ", Tbl_RequestInfo.ReqRemarks =" & STR_Quote2(ReplaceQuote(textremarks)) &_
  8.     '", ReqUpdatedLastby=" & STR_Quote2(ReplaceQuote(session("username"))) &_
  9.     ", ReqUpdatedLast=" & curdate &_
  10.     " WHERE (((Tbl_RequestInfo.ReqID)=" & ReplaceQuote(textrequestID) & ") " &_
  11.     "AND ((Tbl_RequestInfo.ReqServicetypeid)=" & ReplaceQuote(textservicetype) & ") " &_
  12.     "AND ((Tbl_RequestInfo.ReqFuncloc)=" & STR_Quote2(ReplaceQuote(textfuncloc)) & "))"
  13.  
and i get the error message is as follws

missing SET keyword
if u have any sln, then plz
Apr 15 '08 #1
2 1769
shweta123
692 Expert 512MB
Hi,

I think you are getting this because , you can not use Update with multiple tables join. You have to use Triggers or some other way for that.
Apr 16 '08 #2
jhardman
3,406 Expert 2GB
Hi,

I think you are getting this because , you can not use Update with multiple tables join. You have to use Triggers or some other way for that.
Yeah, or use a stored procedure.

Jared
Apr 16 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

7 posts views Thread by Corepaul | last post: by
5 posts views Thread by Mark Broadbent | last post: by
11 posts views Thread by vijaynats | last post: by
69 posts views Thread by markarichman | last post: by
77 posts views Thread by Ville Vainio | last post: by
17 posts views Thread by Christoph Zwerschke | last post: by
1 post views Thread by CARIGAR | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.