Not an actual application, just something that's come up every once and a while and I've used a temp file to flag those processed and re-selected.
I guess the only pure way is on a dormant system. Thanks for all the replies. MarkJohnson ----- Original Message ----- From: "Ralph Burton" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Wednesday, October 12, 2005 1:48 PM Subject: Re: [U2] Basic vs Execute Select > From what I understand, you need to make sure new records are processed... then create > a second file where the keys are written at the same time the original record is written. > > Then set up a continous loop to read through the file, > removing the keys when they are processed. > Use the sleep command to slow down your loop. > You could set a flag in a table that the program could read to end the loop... etc. > > It would be easier if there was more info about the actual application... > > > Ralph Burton <[EMAIL PROTECTED]> wrote: > I would use a straight Select in basic program and not use an Execute or Perform. > > OPEN "FILES" TO F.FILES ELSE ... > > SELECT F.FILES > > > > Mark Johnson wrote: > You're kidding. I requested 'counted for', not counted. > > The earlier SELECT thread brought up the concept of records added during the > processing. Thus, how could you insure that all records were processed, even > those latecomers. > > Mark Johnson > ----- Original Message ----- > From: "Ralph Burton" > To: > Sent: Tuesday, October 11, 2005 1:32 PM > Subject: Re: [U2] Basic vs Execute Select > > > > EXECUTE "COUNT FILENAME" > > > > > > Mark Johnson wrote: > > A recent thread debated the speed of these 2 SELECT methods. > > > > My question is what would be the preferred way to insure that all records > may > > be counted for on an active system instead of a dormant system. > > > > Thanks in advance. > > Mark Johnson > > ------- > > u2-users mailing list > > [email protected] > > To unsubscribe please visit http://listserver.u2ug.org/ > > > > > > --------------------------------- > > Yahoo! Music Unlimited - Access over 1 million songs. Try it free. > > ------- > > u2-users mailing list > > [email protected] > > To unsubscribe please visit http://listserver.u2ug.org/ > ------- > u2-users mailing list > [email protected] > To unsubscribe please visit http://listserver.u2ug.org/ > > > --------------------------------- > Yahoo! Music Unlimited - Access over 1 million songs. Try it free. > ------- > u2-users mailing list > [email protected] > To unsubscribe please visit http://listserver.u2ug.org/ > > > --------------------------------- > Yahoo! Music Unlimited - Access over 1 million songs. Try it free. > ------- > u2-users mailing list > [email protected] > To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
