01 print char(27):char(2):www.ups.com
Works for me ... Windows is smart enough to figure out this is a URL, and will load it
into your default browser
Ditto with
01 print char(27):char(2):mailto:[EMAIL PROTECTED]
To at least start up mail client (we actually use our MailLynx product,
The Char(2) is the STX command. The Accuterm 'readme' didn't mention the
char(27). I did realize that it used the file type of the pcfile to 'open
with'.
I tried the mailto: concept about a year ago and it wasn't complete. I
wanted to include the TO: , SUBJECT: and BODY and heaven forbid, an
Yes!! This is an excellent example that clearly demonstrates how this
works. Being out of uniVerse/Pick for a couple years you tend to forget
how things work. I will file this example for later use. Thanks!!
At 06:51 PM 8/11/2004, you wrote:
There's a very good reason why it works this way.
Have a look at
http://www.asent.com/ProductCart/pc/viewCat_P.asp?idCategory=7
Ron White
- Original Message -
From: Mark Johnson [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, August 11, 2004 8:24 PM
Subject: Re: [U2] Wintegrate
Was on their web site 4 hours ago and it had
One less thing to have to compile.
It's easier to just write a paragraph for simple batching,
rather than write the program, compile it and run it.
Other than the above, there is no reason not to put into
a program.
George
-Original Message-
From: Allen E. Elwood (CA) [mailto:[EMAIL
Hi,
Can anybody help me in retriving the unique(distinct) records from
Universe file
tax in advance
regards
Reddy
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/
Define unique.
Gordon J. Glorfield
Sr. Applications Developer
MAMSI (A UnitedHealth Company)
301-360-8839
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: Thursday, August 12, 2004 10:05 AM
To: [EMAIL PROTECTED]
Hi,
What do you mean by 'unique'?
Can you show us an example of what you want to do.
All records in a universe file have a unique identifier (ID).
Les.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 12 August 2004 15:05
To: [EMAIL PROTECTED]
Subject: [U2]
Do you mean:
SELECT foo WITH foo1 = foo2 SAVING UNIQUE foo3
This gives you a select list of unique foo3 values.
Oh, and no thanks, I have enough tax.
Best,
David Beahm
[EMAIL PROTECTED] wrote:
Hi,
Can anybody help me in retriving the unique(distinct) records from
Universe file
tax in advance
You can setup a DICTIONARY ITEM that concatantes both values
IE.
ED DICT FILE MFGPARTNO
MFGPARTNO
001: I
002: MFG.NO:PART.NO
003:
004: combo
005: 20L
006: S
Assuming they are both single valued fields:
Then
SELECT ORDERS SAVING UNIQUE MFGPARTNO
George
-Original
Hi George,
It's always a good idea when concatenating to be sure that you put in a
character to separate the fields so that later on it's easy to take them
back apart if necessary. Otherwise you won't know where the mfg.no stops
and the part.no starts.
002:MFG.NO:|:PART.NO
Allen E. Elwood
Can this (selecting only those order IDs which have unique combination
of Mfg.No and Part.No) be done without having to create an
intermediate dictionary item?
Savita Chauhan,
Programmer/Analyst
x:1754 Central Texas College.
---
Change is the only
check out EVAL in the documentation
Rich
Chauhan, Savita wrote:
Can this (selecting only those order IDs which have unique combination
of Mfg.No and Part.No) be done without having to create an
intermediate dictionary item?
snip
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please
Savita:
You can create an 'on-the-fly' version rather than having to actually add a
DICT item by using EVAL:
SELECT ORDERS SAVING UNIQUE EVAL MFG.NO : '|' : PART.NO
Harold Oaks
Sr. Analyst/Programmer
Clark County, WA
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
YES.
SELECT FILENAME SAVING UNIQUE EVAL MFGNO:PARTNO
or
SELECT FILENAME SAVING UNIQUE EVAL MFGNO:_:PARTNO
George
-Original Message-
From: Chauhan, Savita [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 12, 2004 1:56 PM
To: [EMAIL PROTECTED]
Subject: RE: [U2] How do we get unique
Unless you have a PARTID file that has it's ID as
the MFGCODE and PARTCODE, then it would work.
If this is an invoice and your trying to pull off all
the parts from the invoice, you will need to modify the
EVAL statement to work with multivalued fields.
SELECT INVOICE SAVING UNIQUE EVAL MFG:PART
SELECT . SAVING UNIQUE EVAL @RECORD5:@VM:@RECORD7
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Chauhan, Savita
Sent: Thursday, August 12, 2004 10:56 AM
To: [EMAIL PROTECTED]
Subject: RE: [U2] How do we get unique records from Universe file(Table)
Are trying to build a key to another file?
-Original Message-
From: Chauhan, Savita [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 12, 2004 11:56 AM
To: [EMAIL PROTECTED]
Subject: RE: [U2] How do we get unique records from Universe file(Table)
Can this (selecting only those order IDs
OR
:SELECT file1 SAVING EVAL ATTRx:'*':ATTRy
-Original Message-
From: Shawn Waldie
Sent: Thursday, August 12, 2004 2:53 PM
To: '[EMAIL PROTECTED]'
Subject: RE: [U2] How do we get unique records from Universe file(Table)
Try
:SELECT file1 SAVING EVAL ATTRx:ATTRy
where ATTRx:ATTRy is
Your syntax does appear correct.
Sometimes U2 does odd things when you put the * in some of the commands,
like the COPY command. Try another character. If that works, then you'll
know that it was the * that messed it up. If you need the * because of the
key you're trying to build, then just go
What are the attribute numbers in the ORDERS file where the MFG.NO and
PART.NO are stored?
Let's say it's 4 and 18, respectively.
: SELECT ORDERS SAVING UNIQUE EVAL @RECORD4:'*':@RECORD18
should do it.
The Illegal attribute name for sort: MFG.NO:'*':PART.NO error message may
be saying that you
That's how to do a unique field, if it's a record which has to be unique,
you can fake it by creating an I-Desc using @RECORD, the do the SELECT
SAVING UNIQUE as mentioned.
Beware, if the records are anything but very small, this is a very bad idea
and you should solve it programmatically.
22 matches
Mail list logo