A couple of thoughts. If you do
SELECT FILENAME WITH FIELD = "123""456""479"
does that count as multiple WITHs?
You could setup a dict item that looks at a certain position in the field
then select on that.
D3 UD/U2
FIELD.NAME FIELD.NAME
1 A 1 I
2 0 2 @ID[3,1]
3 3
4 4
5 5 1L
6 6 S
7
8 T3,1
R
1
SELECT FILENAME WITH FIELD.NAME = "1"
Will get all the items that have a 1 in the 3rd position of the ID
----- Original Message -----
From: "jjuser ud2" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Monday, September 25, 2006 3:21 PM
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?
>
> When I execute the LIMIT command in UniData, it tells me:
>
> U_MAXFNAME: File name limit = 198.
> U_NAMESZ: Record id(key) size = 126.
> U_SELEMAX: Number of select list = 10.
> U_MAXDATA: Number of DATA statement = 500.
> U_HEADSZ: HEADER/FOOTER length = 2120.
> U_MAXHASHTYPES: Number of hash functions = 3.
> U_MAXSORT: Number of sort fields(BY...) in LIST = 20.
> U_MAXWITH: WITH stack size = 256.
> U_MAXWHEN: WHEN stack size = 60.
> U_MAXCAL: Number of SUM+AVG+PCT+CAL in LIST = 54.
> U_MAXBREAK: Number of BREAK.ON+BREAK.SUP in LIST = 15.
> U_MAXLIST: Number of attribute names in LIST = 999.
> U_LINESZ: Page width in printing = 272.
> U_PARASIZE: Paragraph name and its parameter size = 256.
> U_LPCMD: System spooler name = NT Spooler.
> U_MAXPROMPT: Number of prompts allowed in paragraph = 60.
> U_FSIZE: Dictionary field name size = 31.
> U_MAXVALUE: Number of values WHEN can handle = 10240.
> U_MAXBYEXPVAL: Number of values BY.EXP can handle = 10240.
> U_SENTLEN: Maximum sentence length = 9247.
> U_PROCBUFSZ: Proc buffer size = 4095.
> U_NIDES: Maximum number of virtual fields in query= 256.
>
> 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/
