George,
Does the file have an index on the id?
If so, try adding the "NO.INDEX" keyword.
I've something similar @ UV10.2.10:
------
>SELECT PARTS SAMPLE 2
26417 record(s) selected to SELECT list #0.
-----
>SELECT PARTS SAMPLE 2 NO.INDEX
2 record(s) selected to SELECT list #0.
-----
>DELETE.INDEX PARTS PART_ID
Removing index file PART_ID.
>SELECT PARTS SAMPLE 2
2 record(s) selected to SELECT list #0.
-----
So I’m guessing that the UniVerse engineers have a glitch and didn’t
consider that someone might index the id.
This makes sense why SELECT PARTS SAMPLE 2 works if you already have an
active select list: the index isn’t used if a select list is active.
On 5/24/2013 8:52 AM, George Gallen wrote:
OK.
Any Ideas? I have a Type 30 file that if I use the SAMPLE modifier in the
SELECT still returns the entire file,
However, if I use the SAMPLE modifier in a LIST command on that same file, it
only returns the sample amount.
Now, it gets stranger, If I do a SELECT with the SAMPLE modifier, it returns
the whole file as an active list, and if I
Do another SELECT with the SAMPLE modifier on that active list, it only returns
the the sample amount.
So what, the file is just toying with me? I guess if I really want that sample,
I have to ask twice?
SELECT FILENAME SAMPLE 10
929347 record(s) selected to SELECT list #0.
SELECT FILENAME SAMPLE 10
10 record(s) selected to SELECT list #0.
This seems to be the only file that is behaving this way. There are no
dictionary items in the file that would
Interfere with the UV selection.
My next step will be to create a new file, and copy over the contents, just in
case there is something that
Is corrupted in the file.
This is on UV 10.0.2 / RH Linux
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users
