Re: [U2] trimming a list (a test of your ability)

2012-07-11 Thread Rootman, Steven
Thanks Dennis, What happens if FM.ARRAY is empty? Would it not be better to: MORE = LEN(FM.ARRAY) LOOP UNTIL NOT(MORE) And then like you said. Thanks. dennis bartlett to force unique list (with REMOVE you don't have to know how many attributes are in FM.ARRAY) UNIQ.LIST = '' LOOP

Re: [U2] trimming a list (a test of your ability)

2012-07-11 Thread dennis bartlett
to strip _trailing_ field markers KEY.LIST := '~~' ; * some arb char set that wont be evident in the data LOOP CHANGE(KEY.LIST, @FM:'~~', '~~') UNTIL KEY.LIST[LEN(KEY.LIST)-2,1] NE @FM REPEAT CHANGE(KEY.LIST, '~~', "") to force unique list (with REMOV

Re: [U2] Select Statement Invalid

2012-07-11 Thread BobW
If he changed "SELECT" to "select", would that get him the results he wants? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wally Terhune Sent: Wednesday, July 11, 2012 5:10 PM To: U2 Users List Subject: Re: [U2] Sel

Re: [U2] trimming a list (a test of your ability)

2012-07-11 Thread Kate Stanton
I am getting sucked in! NLST = "" ;* For new list MAXI = DCOUNT(KEY.LIST<1>,@vM) ;* Count items FOR INO =1 TO MAXI ;* Each key in list KEY.ID = KEY.LIST<1,INO>;* A key ID LOC

Re: [U2] Select Statement Invalid

2012-07-11 Thread Eric Neu
This works 001: PQ 002: HSELECT WIPMTLRQ WITH @ID = 003: H "240573]" 004: H "292508]" 005: H "235115]" 006: H "203346]" 007: H "219843]" 008: H "170808]" 009: H "203304]"

Re: [U2] Select Statement Invalid

2012-07-11 Thread Steve Long
Just curious, have you tried the select statement at TCL? Sent from my iPhone On Jul 11, 2012, at 2:16 PM, "David Jordan" wrote: > Have you tried putting spaces between the IDs you are selecting. > > David > > > ___ > U2-Users mailing list > U2-Us

Re: [U2] Select Statement Invalid

2012-07-11 Thread David Jordan
Have you tried putting spaces between the IDs you are selecting. David ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Select Statement Invalid

2012-07-11 Thread Wally Terhune
Paragraphs run in U mode. Change it to a proc or change the syntax Wally Terhune Technical Support Engineer Rocket Software 4600 South Ulster Street, Suite 1100 **Denver, CO 80237 **USA t: +1 720 475 8055 **e: wterh...@rocketsoftware.com **w: rocketsoftware.com/u2 -Original Message- F

[U2] trimming a list (a test of your ability)

2012-07-11 Thread Wjhonson
1295 FOR DISPLAY.LOOP = 1 TO KEY.COUNT 1296 UTILITY.ID = KEY.LIST<1,DISPLAY.LOOP> 1297 GOSUB GET.UTILITY.RECORD 1298 IF INDEX(UTILITY.NAME,LAST.NAME,1) = 0 THEN 1299KEY.LIST = DELETE(KEY.LIST,1,DISPLAY.LOOP,0) 1300DISPLAY

Re: [U2] Select Statement Invalid

2012-07-11 Thread Wjhonson
I would try putting this select into a BASIC EXECUTE and see if the same thing happens -Original Message- From: Robert Houben To: U2 Users List Sent: Wed, Jul 11, 2012 4:51 pm Subject: Re: [U2] Select Statement Invalid Not sure, but is it treating "x""y" as 'x"y'? I know in some p

Re: [U2] Select Statement Invalid

2012-07-11 Thread Robert Houben
Not sure, but is it treating "x""y" as 'x"y'? I know in some parsers, if you want to embed a double quote inside of double quotes you just put two side by side. Most PICK systems don't do that, but within a paragraph the rules may be different. Try putting spaces between the values. -Ori

[U2] Select Statement Invalid

2012-07-11 Thread Al DeWitt
Unidata 7.1.20, pick flavor I have this quick paragraph to select records based on partial keys: 001: PA 002: SELECT WIPMTLRQ WITH @ID = "299486]""302667]""318583]""337991]""374396]""376742]""382767]""385661]" "398932]""415256]""445409]""453821]" "454353]""478175]""478845]""502457]" Botto