Ok.
I have file1 - people that has @ID of PID
I have file2 - registration that has @ID of PID+EID+RID (EID = event id,
RID = registration id)
I want to select people who are not in the registration file with an EID of 1.
With an SQL statement - I could join the two, then do the select or use
Do it in more than one command?
SELECT REGISTRATION WITH EID = '1' SAVING UNIQUE PID
NSELECT PEOPLE
Or am I missing something?
John
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: Wednesday,
That was my first try, but the NSELECT only checks PEOPLE for those that are in
the list returned by the first
That are not in PEOPLE, it doesn't check for those in PEOPLE that are not in
the list returned.
George
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
I'm OK with using SQL - just wondering how you could use UV native.
select distinct PEOPLE.PID from PEOPLE inner join REGISTRATION
on (PEOPLE.PID = REGISTRATION.PID) where EID '1';
I will admit, UV could use a join clause.
George
-Original Message-
From:
This gets a little trickier, but how about:
1) SELECT PEOPLE TO 1.
2) SELECT REGISTRATION WITH EID = '1' SAVING UNIQUE PID.
3) SELECT PEOPLE TO 2.
4) MERGE.LIST 1 DIFF 2 TO 3.
5) SAVE.LIST XXX FROM 3.
This does assume that steps 1 and 2 actually return at least 1 key.
MERGE.LIST is an amazingly
Yea, MERGE.LIST does work, but sometimes I have issues with it using it in an
EXECUTE from BASIC.
George
Actually, you could leave off the TO 3, and the FROM 3 and it would still work.
The only disadvantage, is MERGE.LIST ALWAYS does a distinct, and you can't use
it to merge on
More than
On 17/10/12 14:59, George Gallen wrote:
Ok.
I have file1 - people that has @ID of PID
I have file2 - registration that has @ID of PID+EID+RID (EID = event id,
RID = registration id)
I want to select people who are not in the registration file with an EID of
1.
With an SQL
How would I get the contents of the Index?
George
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists
Sent: Wednesday, October 17, 2012 11:38 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Selection
Meant to have left outer join, not inner join.
BUT.I hit a snag.
If someone has entries in REGISTRATION with EID = '1' and an EID = '2' - they
still get selected,
since the it passes The '1' test, but the outer join also pulls in the EID =
'2'. So I'm going to have
To do a loop through,
It looks like you have hit the point where code is needed because the SELECT
just cannot handle all the conditions cleanly.
My rule of thumb is: if I am going to need ANY code, do the whole thing in a
program. Experience has taught me that at some point, someone will want to
tweak things, and
George:
How about something like:
3 Dev (0)- LSELECT ?
This will create a list of {FileName} keys for records whose
field definition value appears in a defined list.
Syntax:
LSELECT File_Name WITH Dict_Name IN LIST1 TO LIST2 [VERBOSE| -V]
Example: SELECT CUSTOMERS SAMPLE 500
SAVE.LIST
Looks like either UV doesn't have LSELECT, or UV 10.0.2 does not.
George
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett
Sent: Wednesday, October 17, 2012 1:16 PM
To: U2 Users List
Subject: Re: [U2]
This is actually some code I put together from a Rock tech note. It's
come in handy at various times. :-)
I'd be happy to share the code with you; I use UD but I suspect it
wouldn't be too hard to get it running on UV.
Bill
Untitled Page
Why not post it to the PickWiki
That way we can all use it.
-Original Message-
From: Bill Haskett wphask...@advantos.net
To: U2 Users List u2-users@listserver.u2ug.org
Sent: Wed, Oct 17, 2012 10:35 am
Subject: Re: [U2] Selection Suggestions for using UV instead of SQL
This is
select registration with EID = '1' saving unique PID to 1
select people to 2
merge.list 2 diff 1
Larry Hiscock
Western Computer Services
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen
Sent:
And to do this from UniBasic:
CMD =
CMD-1 = PA
CMD-1 = SELECT REGISTRATION WITH EID = '1' SAVING UNIQUE PID TO 1
CMD-1 = IF @SYSTEM.RETURN.CODE 1 THEN GO THE.END
CMD-1 = SELECT PEOPLE TO 2
CMD-1 = IF @SYSTEM.RETURN.CODE 1 THEN GO THE.END
CMD-1 = MERGE.LIST 2 DIFF 1
CMD-1 = THE.END:
EXECUTE CMD
Hmm it never occurred to me that you can BASIC EXECUTE a paragraph which
doesn't actually exist in the VOC but is just created on-the-fly like this. I
wonder if I should try this on Universe 11.
-Original Message-
From: David A. Green dgr...@dagconsulting.com
To: 'U2 Users
That's a neat trick, I always assumed that you would have to write the
paragraph out to the VOC and then execute it. I like this! Thanks.
-Dianne
On 10/17/2012 2:45 PM, David A. Green wrote:
And to do this from UniBasic:
CMD =
CMD-1 = PA
CMD-1 = SELECT REGISTRATION WITH EID = '1' SAVING
I like it!
Once improvement: if the 2nd select fails, you should clear select list #1.
Something like this:
CMD =
CMD-1 = PA
CMD-1 = SELECT REGISTRATION WITH EID = '1' SAVING UNIQUE PID TO 1
CMD-1 = IF @SYSTEM.RETURN.CODE 1 THEN GO THE.END
CMD-1 = SELECT PEOPLE TO 2
CMD-1 = IF
You don't need the PA in field one when you execute the stack. You can
create a multi-field record and execute it and UniVerse treats it as a
paragraph.
Tom
RATEX Business Solutions
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
http://jobs.geekzone.co.nz/Jobs/View/24957
I had to look up BAU. I have never heard of that acronym.
I'm *guessing* from this
http://en.wikipedia.org/wiki/Bau
of those choices I suppose it must be the normal execution of standard
functional operations within an organisation ?
So are they
I have a verb I wrote, which select all files in an account, including those
which are just pointers to OS level directories, and for each run it runs the
BASIC STATUS command to retrieve the INODE (and other things).
The process aborts part way through with no message, it just kicks my session
There was a known issue whereby doing a STATUS call on a file that no longer
has a valid owner will cause an access violation.
As you are iterating over every file, this seems like a plausible cause.
Tom's Hardware seems to have some help in finding files with invalid owners:
When you say was, is there a patch?
-Original Message-
From: Daniel McGrath dmcgr...@rocketsoftware.com
To: U2 Users List u2-users@listserver.u2ug.org
Sent: Wed, Oct 17, 2012 1:38 pm
Subject: Re: [U2] [UV] Universe 11 on Windows; BASIC STATUS command aborting
process
There was
UV 10.2.13
On my Linux system writing items with an id that contains an asterisk (*)
on a Type 19 file causes the id to be converted.
Example: If BP.LIB is a type 19 file and I save an item named aaa*10
the Linux file name written is A0JL64~D
I am familiar with the fact that Universe on windows
It appears there may be a fix coming out in 11.1.10 later this year.
Take my words with a grain of salt however, as I don't primarily deal with the
current UniVerse releases.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On
Well you got it in one Dan.
Some person (not me) removed a user from the user's table, who had
ownership of several files.
Most of them were old temp junk so I just deleted them.
But one was an actively used file, so I was able to reset the owner of that
file to be myself, and my
No problem. Glad to have help.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Wednesday, October 17, 2012 3:00 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] [UV] Universe 11 on Windows; BASIC
Hi all the u2oers,
Is anyone out there using uvreplicate on any platform will be appreciated for
background information, but specifically AIX/Unix? I personally do not think
this will be different between the operating platforms.
I have a few questions before I start looking into testing this
29 matches
Mail list logo