Looks like you need REUSE(@ID) in your subr HTH, *=aee=*
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Hruby, Paul Sent: Tuesday, September 21, 2004 11:04 To: '[EMAIL PROTECTED]' Subject: [U2] [UD] - I-Desc IF, THEN, ELSE or SUBR -IFS Greetings, I'm not quite sure what I'm doing wrong, but here is a background of what I'd like to accomplish. Hopefully, I have provided the right/enough information. Also, I receive the list in digest mode, so any dialog would be delayed. FileOne has a Muli-value Attribute<1> that contains a list of items. FILEONE ID= 12345 KEYTWO= 001^002^003 FileTwo's ID is comprised of FileOne's ID and FileOne Attribute<1> (KEYTWO)example: FILETWO ID= 12345*001 ID= 12345*002 ID= 12345*003 What I'm trying to do is build an I-Desc that will allow me to list out FileOne and with FileTwo's ID. Example: LIST FILEONE FILETWO.KEY FILEONE FILETWO.KEY 12345 12345*001 12345*002 12345*003 Here is what I've tried so far. I-Desc FILETWO.KEY 001: I 002: IF KEYTWO EQ "" THEN "" ELSE @ID:"*":KEYTWO 006: M Results of LIST FILEONE FILETWO.KEY @ID FILETWO.KEY 12345 12345*001 002 003 Using SUBR FILETWO.KEY 001: I 002: SUBR("-IFS",KEYTWO="","",@ID:"*":KEYTWO) 006: M Results of LIST FILEONE FILETWO.KEY using SUBR -IFS @ID FILETWO.KEY 12345 12345*001 002 003 >From what I see, using either IF THEN ELSE or SUBR -IFS, the outcome is the same. Can someone point me in a different direction? I thought the -IFS routine would give me the results I desired above. Thanks in advance Paul P. Hruby Police Database Coordinator Scottsdale Police Dept. [EMAIL PROTECTED] *** Information sent from & received by this email address may be considered public information *** ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
