I often set up a temporary table (used with LOCATE) if the data is incredibly static in this method:
CHOICES="A.B.C.D.E.F.1.2.3.4.19.20.W.X.Y.Z" CONVERT "." TO @AM IN CHOICES Viola, instant dynamic array. Looks a whole lot more readable than CHOICES="A":@AM:"B":@AM etc. Especially if the delimiter is consistent. Mark Johnson BTW, there's something a little fishy with this SELECT.LIST example. There is a space following the commas that would make all of the second mv's <space>TELEPHONE and <space>ADDRESS etc. ----- Original Message ----- From: "Colin Jennings" <[EMAIL PROTECTED]> To: <u2-users@listserver.u2ug.org> Sent: Saturday, March 17, 2007 8:10 AM Subject: Re: [U2] SELECT.LIST, DCOUNT and @VM > As long as you're only after a 'what' and not a 'why' I can. > > The variable SELECT.LIST will have three attributes, all multi-valued, as > follows: > > <1> NAME]TELEPHONE]ADDRESS > <2> NAME]TELEPHONE]CITY > <3> NAME]TELEPHONE]OFFICE > > The variable SELECT.CNT will equal 3, the number of multi-values in the > first attribute. > > Don't know why without looking at the rest of the code, but some people > prefer to build a comma-separated list and then change the commas to system > delimiters rather than delimit with @VM in the first place. Not wrong, but > perhaps a bit unnecessary. Does make the code easier to read I suppose. > > Col. > > ----- Original Message ----- > From: "Sanjeebkumar Sarangi" <[EMAIL PROTECTED]> > To: <u2-users@listserver.u2ug.org> > Sent: Saturday, March 17, 2007 12:46 PM > Subject: [Norton AntiSpam] [U2] SELECT.LIST, DCOUNT and @VM > > > > Hi, > > > > Can someone explain me the given block of code below please? > > > > SELECT.LIST = ' ' > > SELECT.LIST<1> = 'NAME, TELEPHONE, ADDRESS' > > SELECT.LIST<2> = 'NAME, TELEPHONE, CITY' > > SELECT.LIST<3> = 'NAME, TELEPHONE, OFFICE' > > CONVERT ',' TO @VM IN SELECT.LIST > > SELECT.CNT = DCOUNT( SELECT.LIST<1>, @VM ) > > > > Thanks > > =====-----=====-----===== > > Notice: The information contained in this e-mail > > message and/or attachments to it may contain > > confidential or privileged information. If you are > > not the intended recipient, any dissemination, use, > > review, distribution, printing or copying of the > > information contained in this e-mail message > > and/or attachments to it are strictly prohibited. If > > you have received this communication in error, > > please notify us by reply e-mail or telephone and > > immediately and permanently delete the message > > and any attachments. Thank you > > ------- > > u2-users mailing list > > u2-users@listserver.u2ug.org > > To unsubscribe please visit http://listserver.u2ug.org/ > ------- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/