[Help-glpk] [Fwd: How to read a multiset from a table]

[Andrew Makhorin]

-------- Forwarded Message --------
From: Golubeva Elizaveta <address@hidden>
To: address@hidden <address@hidden>
Subject: How to read a multiset from a table
Date: Fri, 24 Mar 2017 07:58:19 +0000

Good morning!

Is it possible to read the multiset “chains_dp_fn_sc” from the table
“set_chains_dp_fn_sc”?

I know it is possible to assign values to a multiset in such a way:

set chains_dp_fn_sc[1,1,2] :=

6.0

7.0

8.0

;

But when I try to read it from  the table a get an error:
“chains_dp_fn_sc must be a simple set”.

 

#model

 

set chains_dp_fn_sc{

                               delivery_point_ids,

                               fuel_name_ids,

                    sales_channel_ids} default {};

 

 

table set_chains_dp_fn_sc IN 'ODBC'

'DSN=SERVICENOW; UID=sop_user; address@hidden;'

'SELECT value FROM set_chains_dp_fn_sc'

'WHERE delivery_point_id=1 AND fuel_name_id=1 AND sales_channel_id=2' :

chains_dp_fn_sc[1,1,2] <- [value];

 

 

Best regards!