You might consider doing it in a subroutine if you don't have to run it too often and you are selecting a high percentage of the database. Do it with field name = "1" and then have the subroutine do the "withing" and set the return value to 1 so your just test of a 1.
Set up an array in the subroutine to hold the 250 numbers and then just locate in that array. If the numbers truly are random then you could generate the numbers in the subroutine as well or read them from an external source. hth Tom Dodds [EMAIL PROTECTED] 708-234-9608 Office 630-235-2975 Cell -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of jjuser ud2 Sent: Monday, September 25, 2006 12:22 PM To: [email protected] Subject: [U2][UD] UniQuery SELECT WITH Limits Hi hello how are ya :) Limits. The documentation I have for "Using UniQuery" says that you can only have 120 different "with" fields in a SELECT statement. I'm trying to select a series of non-contiguous numbers at random intervals to generate a select list. There are 251 of these numbers. Do I have to split the list into three different groups in order to generate three different lists that I can do a SAVE.LIST on? What's the best way to go about getting these select lists? Thanks! :) ------- 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/
