Forum Discussion
Error 11 when writing results to a database.
I am trying to insert results into a sqlite database using the following: SQLexecute("
INSERT INTO res_rm_markets_oper
(case_id, market, strat_node, oper_scenario, oper_period, bid_up, bid_down...
The indexing sets of the two arrays that are used in the SQL statement are not entirely the same: when processing the following definition:
array(rm in RM_MARKETS, sn in ST_N, osc in SN_OP_SCENS(sn), op in O_PERS(osc))
the compiler will generate new sets for each of the 2 last indices, resulting in something like:
array(RM_MARKETS, ST_N, set of integer, set of integer)
such that they are not identical for the two arrays (even if in the end they have the same content).
A way of avoiding the issue could be to use globally defined sets for these indices and rely on a condition to select the requested values:
array(rm in RM_MARKETS, sn in ST_N, osc in I, op in J | i in SN_OP_SCENS(sn) and op in O_PERS(osc))
with I and J being the actual indexing sets of the target arrays (rm_bid_up and rm_bid_down). If they are not explicitly defined elsewhere in your model, they could be calculated as
I:= union(sn in ST_N) SN_OP_SCENS(sn)
J:= union(osc in I) O_PERS(osc)
