Can a record be SELECTed twice in sort/selection processing?

[John Esak]

It wouldn't matter if SELECT is put on a table twice ... Or run into 30
times... It only SELECTS the record one time, period.

John
 

> -----Original Message-----
> From: Richard Kreiss [mailto:rkreiss at verizon.net] 
> Sent: Friday, June 18, 2010 11:35 AM
> To: 'Boaz Bezborodko'; john at valar.com
> Cc: filepro-list at lists.celestial.com
> Subject: RE: Can a record be SELECTed twice in sort/selection 
> processing?
> 
> 
> 
> > -----Original Message-----
> > From: filepro-list-bounces+rkreiss=verizon.net at lists.celestial.com
> [mailto:filepro-list-
> > bounces+rkreiss=verizon.net at lists.celestial.com] On Behalf Of Boaz
> Bezborodko
> > Sent: Friday, June 18, 2010 11:07 AM
> > To: john at valar.com
> > Cc: filepro-list at lists.celestial.com
> > Subject: Re: Can a record be SELECTed twice in 
> sort/selection processing?
> > 
> > "Can not" or "should not"?
> > 
> > (I'm reworking the program so as to avoid it, but I am now 
> curious...If
> > you forced a sort/select program to walk through the 
> records twice (say
> > with a lookup to whatever order it goes in to start from 
> the beginning)
> > and SELECT the same record twice, will it show up twice to 
> the output
> > processing table.  (And, no, Ken, I didn't try it yet.:-)
> > 
> > Boaz
> 
> If one is using associated fields, a record can be selected 
> any number of
> times.
> 
> As we have not seen the code, is it possible that there is a 
> loop causing
> <select> to be run twice on some records?
> 
> 
> Richard Kreiss
> GCC Consulting
> rkreiss at gccconsulting.net
>   
> 
> 
> 
> 
> 
> 
> > 
> > John Esak wrote:
> > > No a record can not be selected twice in sort selection. 
> Period. Don't
> even
> > > try... :-)
> > >
> > > John
> > >
> > >
> > >> -----Original Message-----
> > >> From: filepro-list-bounces+john=valar.com at lists.celestial.com
> > >> [mailto:filepro-list-bounces+john=valar.com at lists.celestial.co
> > >>
> > > m] On Behalf Of Boaz Bezborodko
> > >
> > >> Sent: Friday, June 18, 2010 10:01 AM
> > >> To: filepro-list at lists.celestial.com
> > >> Subject: Can a record be SELECTed twice in 
> sort/selection processing?
> > >>
> > >> If a sort/select program somehow sees and selects a record
> > >> twice during
> > >> it's processing, does that mean that the record will now
> > >> appear twice to
> > >> the output processing?
> > >>
> > >> I think this happened in one of my programs, but I'm not sure
> > >> if that's
> > >> what I'm looking for or not.  An answer to this will help me
> > >> nail down
> > >> the source of the problem.
> > >>
> > >> Thanks,
> > >>
> > >> Boaz
> > >> _______________________________________________
> > >> Filepro-list mailing list
> > >> Filepro-list at lists.celestial.com
> > >> http://mailman.celestial.com/mailman/listinfo/filepro-list
> > >>
> > >>
> > >
> > >
> > -------------- next part --------------
> > An HTML attachment was scrubbed...
> > URL: http://mailman.celestial.com/pipermail/filepro-
> > list/attachments/20100618/29683a4b/attachment.html
> > _______________________________________________
> > Filepro-list mailing list
> > Filepro-list at lists.celestial.com
> > http://mailman.celestial.com/mailman/listinfo/filepro-list
> 
>