learn!
>
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED]
> Sent: Tuesday, April 12, 2005 10:05
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] Complicated Select
>
>
> Maybe it's just me, but I read y
John,
Does the RECORD_A field in FILE_A contain item-id's from FILE_B?
A "foreign key" into FILE_B in SQL parlance?
I'm on UV, so sorry if this doesn't work for UD
SELECT FILE_A WITH NOT EACH RECORD_A "AA""BB""CC" AND WITH A_IN_B
Where the Dictionary item A_IN_B woul
Generally, we use a program to generate a single statement; however if
you may be able to use sql on the file with the UNNEST command to do
this in a single statement. This will mean you will have make sure your
file and dicts are SQL/ODBC naming compliant.
There is a fair amount of documentation
lto:[EMAIL PROTECTED] On Behalf Of Allen E. Elwood
Sent: Tuesday, April 12, 2005 2:02 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Complicated Select
No, it's not just you. I read it three times and still am amazed that the
syntax was even allowed. I have never seen anyone use more tha
ECTED]
[mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED]
Sent: Tuesday, April 12, 2005 10:05
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Complicated Select
Maybe it's just me, but I read your email multiple times and don't really
know what you are asking.
Are you saying you
I don't get it either. The example looks like a mix of sql & mv select
syntaxes (syntaci?)
If you can clarify, I'll bet the answer is yes, there is a good way to
do it with UniQuery.
-Original Message-
From: [EMAIL PROTECTED]
Maybe it's just me, but I read your email multiple times and d
Maybe it's just me, but I read your email multiple times and don't really
know what you are asking.
Are you saying you have two files FILE_A and FILE_B and a select list of
IDs you wish to omit?
In other words, select all records in FILE_A that have the same item ID in
FILE_B and then MERGE-LI
To fast to send
You also get a potentially very long list of values not present in
FILE_B so You'd want to have HUSH ON OFF around the second select.
--
Maybe ( at the cost of an extra sort - it's the .EXP that we want )
SELECT FILE_A BY.EXP RECORD_A SAVING RECORD_A
SELECT FILE_B WITH NO @I
Maybe ( at the cost of an extra sort - it's the .EXP that we want )
SELECT FILE_A BY.EXP RECORD_A SAVING RECORD_A
SELECT FILE_B WITH NO @ID = "AA" "BB" "CC" SELECT.ONLY
or have I misunderstood the query or used somethg uv-specific?
-- mats
Aherne, John wrote:
Hi all,
I want to do a comp
Not that I'm aware of, at least not without resorting to some BASIC.
Would be cool though.
-Kevin
[EMAIL PROTECTED]
http://www.PrecisOnline.com
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Aherne, John
Sent: Monday, April 11, 2005 5:05 PM
To: u2-users
10 matches
Mail list logo