Re: [Help-glpk] ODBC output

[glpk xypron]

Hello,

please, specify the version of GLPK you are using:

Execute cmd.exe.
Navigate to the Gusek installation directory.
Execute glpsol.exe --version

Could you please, replace the table statement by

display {d in district, c in contrat_transfert, f in fonction_embauche
diff fonction_promo}
   f, d, time2str(date_act,"%Y%m"), c, vue, typestaffing,
headRes1[d,c,f], correction;

Does this result in the same problem?

Best regards

Xypron


-------- Original-Nachricht --------
> Datum: Wed, 28 Jul 2010 02:15:41 -0700 (PDT)
> Betreff: [Help-glpk] ODBC output

> 
> Hello list,
> 
> Im currently programming a lp problem using GUSEK. Everything's good as
> long
> as the resolution is concerned, except that when i want to export the
> results in my database, I enncounter an error concerning the ODBC table
> driver.
> 
> What i wrote in my program :
> 
> table result1 {d in district, c in contrat_transfert, f in
> fonction_embauche
> diff fonction_promo} OUT
>   'ODBC' 'DSN=glpk;UID=cfouche;PWD=Adeline08'
>   'INSERT INTO STAFFING_DISTRICT'
>   '(ID_FAMFUNCTION,ID_DISTRICT,ID_MONTH,ID_CONTRAT,ID_VIEW,TYPESTAFFING,
> NM_VALUE,ID_TYPE,CORRECTION)'
>   'VALUES(?,?,?,?,?,?,?,"HEA",?);' :
>    f ~ ID_FAMUFUNCTION , d ~ ID_DISTRICT ,  time2str(date_act,"%Y%m") ~
> ID_MONTH, c ~ ID_CONTRAT, vue ~ ID_VIEW, typestaffing ~ TYPESTAFFING,
> headRes1[d,c,f] ~ NM_VALUE, correction ~ CORRECTION;
> 
> and the error : 
> 
> Writing result1...
> Connected to Microsoft SQL Server 09.00.3042 - Geostaff
> INSERT INTO STAFFING_DISTRICT
> (ID_FAMFUNCTION,ID_DISTRICT,ID_MONTH,ID_CONTRAT,ID_VIEW,TYPESTAFFING,
> NM_VALUE,ID_TYPE,CORRECTION) VALUES(?,?,?,?,?,?,?,"HEA",?)
> Assertion failed: out != out
> Error detected in file ..\src\glpmpl03.c at line 5060
> 
> I don't understand what the problem is. I tried to reinstall Gusek But it
> still doesn' work. I also tested manualy my table STAFING_DISTRICT using
> direct SQL statement and it works, so the problem can't come from the
> database.
> Please can someone help me?
> -- 

-- 
Neu: GMX De-Mail - Einfach wie E-Mail, sicher wie ein Brief!  
Jetzt De-Mail-Adresse reservieren: http://portal.gmx.net/de/go/demail