Load a list from a select statement to variable

[#1]

Hi.

I need to load a list to a var from a select.

For example:

Select distinct client_code

From sales

Output: 1,3,4,5

I need the var to have:

vClients = 1,3,4,5;

Thank You.

[Anonymous]

Gil

Use the Concat() function,  see the Qv Desktop Help for its syntax.

Best Regards,     Bill

[Peter_Cammaert · Accepted solution]

This is one way to do it in your script. Note: Concat() is an aggregation function that cannot be used in a simple variable assignment.

See attachment.

Best,

Peter