Steven:
I wanted to know the how/why you use THIS delimited string? (va).
Ron
Ron Rose wrote:
> How do you use this delimited string?
>
> Ron
>
> Steven Hoggan wrote:
>
> > Razzak,
> >
> > Thanks for the quick reply, but unfortunately it highlighted the fact that
> > my original query was poorly constructed.
> >
> > What I would like to achive is the creation of a variable that contains all
> > of the entries meeting the defined criteria using something like the
> > following command
> >
> > SET VAR va = #values for select employee_name from employees where
> > employee_name contains 'steve'
> >
> > This would give me a variable like the one below
> >
> > va = 'Steven Hoggan, Steve Robson, Mike Stevenson, Angela Stevens'
> >
> > Hope this makes it clearer and apologies for the poorly phrased question
> > first time around
> >
> > Steven
> >
> > > ----------
> > > From: A. Razzak Memon[SMTP:[EMAIL PROTECTED]]
> > > Reply To: [EMAIL PROTECTED]
> > > Sent: 15 June 2001 15:45
> > > To: [EMAIL PROTECTED]
> > > Subject: Re: Bypassing CHOOSE in CHOOSE command - Razzak's Reply
> > >
> > >
> > > Steven,
> > >
> > > Remember, NOTHING is impossible! Perfect timing though.
> > >
> > > Using The Glorious R:BASE 2000 (ver 6.5++) for Windows
> > > or The R:edoubtable R:BASE 2000 (ver 6.5++) for DOS,
> > > you can use the new #LIST option to achieve the goal!
> > >
> > > For more details with examples, please check out:
> > >
> > > http://www.RSyntax.com
> > >
> > > Under Syntax Reference, click on #LIST for detailed
> > > examples.
> > >
> > > Using those examples, you could also use the CHKBOX
> > > option to limit the maximum number of options.
> > >
> > > Enjoy and make sure to have fun!
> > >
> > > Very Best Regards,
> > >
> > > Razzak.
> > >
> > > At 03:13 PM 6/15/2001 +0100, Steven Hoggan wrote:
> > >
> > > >... Anyone know if something like the following is possible?
> > > >
> > > >SET VAR va = #VALUES FOR (column_name) FROM (table_name) +
> > > > WHERE ........................
> > > >
> > > >If Rbase can generate a CHOOSE list for me, and can then place the lot
> > > into
> > > >a single variable should I press Shift and F6, then maybe a wee bit of
> > > >tinkering with the command could generate the list automatically using
> > > >something like the syntax above.
> > > >
> > > >I'd appreciate any feedback as to whether or not this would be a
> > > worthwhile
> > > >request, and also if anyone has a method they currently use to achieve
> > > the
> > > >same end result. I know I can use a cursor-based loop to extract the
> > > values
> > > >and then concatenate them into the one, but I'd hope for this to be
> > > >achievable in a single command.
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > Confidentiality Notice
> > ----------------------
> >
> > This message and any attachments is confidential and may contain privileged
> > information. It is intended only for the identified recipient. Anyone else
> > must not copy, use, store or disseminate it. If you are not the intended
> > recipient, please email it back to the sender and then delete it from your
> > mail system. Thank You. Fitzpatricks.
> >
> > Tel: +44 (0)141 306 9000
> > Fax: +44 (0)141 306 9090
> > Web: www.fitzpatricks.co.uk
