Well, I will admit that I have rarely used the SELECT filevar TO LIST syntax so I can not pull out a specific example.
However, I have seen several occurrences where SELECT filevar missed records and when the syntax was changed to EXECUTE "SELECT filename" it worked perfectly. This has occurred on both Universe and UniData. Rich Taylor | Senior Programmer/Analyst| VERTIS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F 410.528.0319 [EMAIL PROTECTED] | http://www.vertisinc.com Vertis is the premier provider of targeted advertising, media, and marketing services that drive consumers to marketers more effectively. "The more they complicate the plumbing the easier it is to stop up the drain" > From: [EMAIL PROTECTED] [mailto:owner-u2- > [EMAIL PROTECTED] writes: > > << There can be a major problem with the second syntax depending on what > you > are doing to the file. The SELECT filevar syntax does not create a > select > list even in memory. It traverses each group in order as you perform the > readnext command keeping a pointer to where it left off. >> > > It's my belief that both methods work the same way in this regard. > Did you test to see that it actually traverses the entire file once to > build > LIST ? > I'm not sure that's the case, but I might be wrong. > Will Johnson > ------- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/