Thread: updating table
View Single Post
  #3 (permalink)  
Old September 29th, 2004, 12:35 PM
iniro iniro is offline
Authorized User
 
Join Date: Jun 2004
Location: , , .
Posts: 34
Thanks: 0
Thanked 0 Times in 0 Posts
Default

well if i was you i would have used update query to do the job. i find it easier to work with.

Code:
pb_SQL="update web_1 set web_pb ="' & session("Valid") & "',web_pdate='" & date & "',webr_stage=""Claimed"" where web_num='" & session("web_num") & "'"
pb_RS.open pb_sql,objConn
i think this should work

Reply With Quote