2. ASPRunnerPro General questions
  3. [SOLVED]  Difficulties with editing multiple records using insert
This topic is locked
[SOLVED]

 Difficulties with editing multiple records using insert

6/10/2010 9:22:02 AM
ASPRunnerPro General questions
M
 mfred author

This relates to an earlier post but I'm not sure whether replies or new posts get quicker replies. I'm on a but of a schedule so I am trying both.
I am trying to use the button function to update selected records. I am using the code below. However, it seems to get stuck "Sending request to server...".
for each val in keys

strUpdate = "update MailQuery1 set Status='Delivered' where ID=" & val("ID")

CustomQuery(strUpdate)

next
Sergey Kornilov admin 6/10/2010

Post your application to Demo Account and open a ticket at http://support.xlinesoft.com sending your Demo Account URL. 'Demo Account' button can be found on the last screen in the program.
M
 		mfred author 6/11/2010

Here is the code that works:
For n = 0 To keys.Count-1

strUpdate = "update MailQuery1 set Status='Delivered' where ID=" & keys(n)("ID")

CustomQuery(strUpdate)

next
I've tested it and it works fine.
Thanks Sergey