Page Index Toggle Pages: 1 [2]  Send Topic Send Topic Print Print
Hot Topic (More than 10 Replies) "Running" Programming through Mass Update (Read 2798 times)
SpencerWulwick
Senior Member
Members
*****
Offline



Posts: 677
Location: Wilton Manors, Florida
Joined: Jan 16th, 2005
Re: "Running" Programming through Mass Update
Reply #15 - May 14th, 2005 at 5:30am
Print Post Print Post  
Ray -

I could swear that I posted a reply to your last message, but since I don't see it, let me try again.

I understand and appreciate your explanation of the programming, with the exception of  "vTimes <10".  Unfortunately, I just don't get it. 

Could you please elaborate on that one point? 

Thanks!
  

- Spencer

    ** Practice random kindness & senseless acts of beauty!
Back to top
IP Logged
 
The Cow
YaBB Administrator
*****
Offline



Posts: 2530
Joined: Nov 22nd, 2002
Re: "Running" Programming through Mass Update
Reply #16 - May 14th, 2005 at 1:46pm
Print Post Print Post  
Ray is looping and loitering to give the engine time to retrieve the records in the result set. The vTimes variable is used to make sure that the loop does not run forever if there are no records. By checking that vTimes < 10, Ray makes sure that there will be only ten attempts to get the record count, amounting to waiting for ten seconds (because of the "loiter" statement). Of course, if it gets a result earlier it does not wait.

In english the logic states:
"continue trying while you have no result and you have tried less than ten times."
  

Mark Lasersohn&&Programmer&&Lantica Software, LLC
Back to top
IP Logged
 
SpencerWulwick
Senior Member
Members
*****
Offline



Posts: 677
Location: Wilton Manors, Florida
Joined: Jan 16th, 2005
Re: "Running" Programming through Mass Update
Reply #17 - May 14th, 2005 at 2:32pm
Print Post Print Post  
Mark -

Now how did you know what Ray was thinking?   lol   Just kidding, of course.

Thank you very much.  It now makes perfect sense and I will know how to apply it.

  

- Spencer

    ** Practice random kindness & senseless acts of beauty!
Back to top
IP Logged
 
Page Index Toggle Pages: 1 [2] 
Send Topic Send Topic Print Print