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
