[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Help-glpk] [Fwd: How to read a multiset from a table]
From: |
Andrew Makhorin |
Subject: |
[Help-glpk] [Fwd: How to read a multiset from a table] |
Date: |
Fri, 24 Mar 2017 14:34:11 +0300 |
-------- 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!
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Help-glpk] [Fwd: How to read a multiset from a table],
Andrew Makhorin <=