Originally posted by: Userhtwg

H Guys,

I have another Problem. Maybe someone could help me please.

I try to solve some optimization Problems with ILOG Script and a database connection MS Access 2016.

But I cannot initialize a set direct from the database in the main part (main-function).  My Idea is: I iterate over the set only

to get the length of the set to evaluate the number of optimization tasks because I don't won't to specific the length before. .

Could some give me some hints to run the example or help me with some modelling suggestions?

Thanks very much,

Kamil

Hi,

I do not know what you want to do but let me remind you that you can change the DBRead string as said at

https://www.ibm.com/developerworks/community/forums/html/topic?id=e3987f3a-9c07-4a0a-b281-720cbec45080&ps=100

regards

Originally posted by: Userhtwg

Hi Alex,

thanks for the last answer.  My Problem is partly solved. This means

I can load the parameter from the database and initialize an array. But I cannot use the array in the main-Method. How I can handle this part?

My Idea is that I must execute the preprocess method before I use the model in the main-Method.

But how can I solve the problem?

Thanks,

Kamil

Hi,

to use the array in the main do you know that you should use the model object ?

Let me give a tiny example:

int a[i in 1..2]=i;
 
 main
 {
 thisOplModel.generate();
 writeln(thisOplModel.a);
 }

regards

Originally posted by: Userhtwg

Hi Alex,

Thanks for the replay. I solved the problem partly again. Now I have only one problem with parameter type.

Especially I got an error if the solver try to read the parameter form the database(TestModelDatenbankReadScript).

The parameter type float will be not supported by the database.

I use MS Access 2016 with a 64-Cplex Opl on my Win 7 OS.

I also attached the files.

Could anyone give me some hints?

Thanks,

Kamil