Don't pick on the F correlatives as they were the state of the art back then and got us where we are today.
Klugy? Yes, Effective? Yes. Anyone with an HP Calculator can appreciate the RPN (Reverse Polish Notation) power of that stack-oriented processor, the F Correlative. Am I showing my age? Mark Johnson P.S. I'm consolidating an article on the history of databases and would welcome any pros/cons on the earlier PC-oriented databases including regular Apple computers, all MS databases as well as non-PC databases, like those for mini-computers and mainframes. Thanks. ----- Original Message ----- From: "Bill Haskett" <[EMAIL PROTECTED]> To: <u2-users@listserver.u2ug.org> Sent: Monday, September 25, 2006 9:48 PM Subject: RE: [U2][UD] UniQuery SELECT WITH Limits > Charles: > > And some complain about the obtuse nature of "F" correlatives. :-) > > Bill > > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Stevenson, Charles > Sent: Monday, September 25, 2006 4:22 PM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2][UD] UniQuery SELECT WITH Limits > > Don't know about UD limits. Here's a workaround: > > Write a control record with the 251 different numbers that you are > searching for. > Then > SELECT file WITH EVAL "SUBR( '!EQS', TRANS( controlfile, controlid, > -1, 'X' ), REUSE( field.in.question ))" = "1" > > Something close to that, anyway. > It loops through the entire file once (the expensive part), and does 251 > comparisons for each record (not so sepenseive). > > cds > ------- > 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/
