473,387 Members | 1,420 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

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 1868
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

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

Similar topics

2
by: dimension | last post by:
Hi, in visual studio 2005 beta, when i type "using System.Web." no code complete helper pops up. Similarly, when typing "using System.Net." i do not see an HttpWebRequest in the list that pops...
7
by: Corepaul | last post by:
Missing Help Files When I enter "recordset" as the keyword and search the Visual Basic Help index, I get many topics of interest in the resulting list. But there isn't any information available...
5
by: Mark Broadbent | last post by:
Oh yes its that chestnut again! Ive gone over the following (http://www.yoda.arachsys.com/csharp/faq/ -thanks Jon!) again regarding this subject and performed a few of my own tests. I have two...
11
by: vijaynats | last post by:
Why isn't there a 'throws' keyword in C# like java - i would like to declare a function and say - public int addup(int a, int b) throws ArithmeticExceptio, DivideByZeroException { ... ... }
69
by: markarichman | last post by:
Why is Firefox complaining with this error: ------------------------------------------------------------ missing ) after argument list setTimeout('breakOut',5000);...
77
by: Ville Vainio | last post by:
I tried to clear a list today (which I do rather rarely, considering that just doing l = works most of the time) and was shocked, SHOCKED to notice that there is no clear() method. Dicts have it,...
2
by: sfrvn | last post by:
I am embarrassed to say I cannot make this work. Recently upgraded to Access 2003, but do not know if that part of problem (AKA 'syntax change'). Would someone be kind enough to lead me by the...
20
by: mc | last post by:
I may be opening a can of worms and don't want to start a religious war, but... What features of Java do Java programmers miss when working in C#? Other than, of course, great portability. C#...
17
by: Christoph Zwerschke | last post by:
I'm just reading PEP 3107 (function annotations) and wonder why exceptions are not mentioned there. I think it would be helpful if one could specify which exceptions can be raised by a function,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.