Hi Steven,
If you do not want to use the chkbox function then I think your only option
would be to declare a cursor on the table with your where clause and then
append each name to a variable as you step through the table. There is no
way to pull multiple values into a variable unless you go through the choose
with chkbox option or a cursor.
set v vnewvalue text
set v va text
drop cursor curs1
declare cursor curs1 for select column_name from table_name +
where......
open cursor curs1
fetch curs1 into vnewvalue indi vi
while sqlcode <> 100 then
set var va = (.va + .vnewvalue)
fetch curs1 into vnewvalue indi vi
endwhile
drop cursor curs1
Best regards,
Mike Young
On Fri, 15 Jun 2001 15:13:37 +0100, Steven Hoggan wrote:
>Hi all,
>
>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.
>
>Thanks for any and all replies
>
>Steven
>
>
>
>
>
>
>
>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
