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

Boaz Bezborodko boaz at mirrotek.com
Fri Jun 18 09:05:46 PDT 2010


I'm not trying to do this, I just know that on at least two occasions a 
record was processed twice and I found a situation where it just might 
have been possible for the record to be selected twice.

I'm not sure that it works like "DELETING a record twice" since I think 
it works more on the basis of building a table of records to run through 
during output processing rather than flagging a record to be processed.

If it builds a table then it might be able to SELECT a record twice and 
have the record placed in the table twice.  Ken probably knows if this 
is possible or not.

Boaz

John Esak wrote:
> No it is completely impossible. Think along the lines of DELETING a 
> record twice.  There is no meaning to it.  I think you might be trying 
> to get at associated field records or something... but they would each 
> select individually... and there is no real need to select a record 
> more than once.  Just process those you think need that as many times 
> as you would have "selected" them. It pretty much would amount to the 
> same thing.
>  
> John
>  
>
>     ------------------------------------------------------------------------
>     *From:* Boaz Bezborodko [mailto:boaz at mirrotek.com]
>     *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
>
>     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/8bdbdac9/attachment.html 


More information about the Filepro-list mailing list