[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Help-glpk] ODBC output
From: |
glpk xypron |
Subject: |
Re: [Help-glpk] ODBC output |
Date: |
Wed, 28 Jul 2010 23:20:03 +0200 |
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
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- Re: [Help-glpk] ODBC output,
glpk xypron <=