RE: [U2] Wintegrate

2004-08-12 Thread Ross Ferris
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,

Re: [U2] Wintegrate

2004-08-12 Thread Mark Johnson
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

RE: [U2] MCU's an input within a PAragraph?

2004-08-12 Thread Glenn Herbert
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.

Re: [U2] Wintegrate

2004-08-12 Thread Ron White
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

RE: [U2] MCU's an input within a PAragraph?

2004-08-12 Thread George Gallen
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

[U2] How do we get unique records from Universe file(Table)

2004-08-12 Thread BReddy
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/

RE: [U2] How do we get unique records from Universe file(Table)

2004-08-12 Thread Gordon Glorfield
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]

RE: [U2] How do we get unique records from Universe file(Table)

2004-08-12 Thread Les Hewkin
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]

Re: [U2] How do we get unique records from Universe file(Table)

2004-08-12 Thread David Beahm
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

RE: [U2] How do we get unique records from Universe file(Table)

2004-08-12 Thread George Gallen
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

RE: [U2] How do we get unique records from Universe file(Table)

2004-08-12 Thread Allen E. Elwood \(CA\)
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

RE: [U2] How do we get unique records from Universe file(Table)

2004-08-12 Thread Chauhan, Savita
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

Re: [U2] How do we get unique records from Universe file(Table)

2004-08-12 Thread Richard A. Wilson
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

RE: [U2] How do we get unique records from Universe file(Table)

2004-08-12 Thread Harold . Oaks
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]

RE: [U2] How do we get unique records from Universe file(Table)

2004-08-12 Thread George Gallen
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

RE: [U2] How do we get unique records from Universe file(Table)

2004-08-12 Thread George Gallen
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

RE: [U2] How do we get unique records from Universe file(Table)

2004-08-12 Thread Bob
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)

RE: [U2] How do we get unique records from Universe file(Table)

2004-08-12 Thread Shawn Waldie
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

FW: [U2] How do we get unique records from Universe file(Table)

2004-08-12 Thread Shawn Waldie
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

RE: [U2] How do we get unique records from Universe file(Table)

2004-08-12 Thread Allen E. Elwood \(CA\)
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

RE: [U2] How do we get unique records from Universe file(Table)

2004-08-12 Thread Pingilley, Ron
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

RE: [U2] How do we get unique records from Universe file(Table)

2004-08-12 Thread Doyen Klein
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.