Ron,
I am simply auto-emailing from within Rbase via Exchange, listing the values
in a table WHERE.......... This is done by copying an appropriately
formatted file to the 'pickup' folder in Exchange Server.
I'm doing nothing with the values but reporting them in an email. There is
no need for anything else, and a simple ascii delimited string would be
fine. I know there are a number of ways around this (a SELECT command with
headings set off being the easiest, etc), and will now proceed to
investigate/implement them.
I just thought that aside from my need, there was perhaps some value in
having the ability to generate an ascii delimited list (such as the CHKBOX
result of a CHOOSE command) from a single *non-interactive* command, and
wanted to fire that notion onto the list.
Anyway, thanks for all replies.
Regards,
Steven
> ----------
> From: Ron Rose[SMTP:[EMAIL PROTECTED]]
> Reply To: [EMAIL PROTECTED]
> Sent: 15 June 2001 20:29
> To: [EMAIL PROTECTED]
> Subject: Re: Bypassing CHOOSE in CHOOSE command - Razzak's Reply
>
> 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
>
>
>
>
>
>
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
