Thank you. -----Original Message----- From: glpk xypron [mailto:[email protected]] Sent: Monday, February 14, 2011 11:59 PM To: Meketon, Marc; [email protected] Subject: Re: [Help-glpk] Error when using "table"
Hello Marc, in GLPK 4.44 a bug exists, which was described in the thread starting with http://lists.gnu.org/archive/html/bug-glpk/2010-07/msg00000.html The bug is fixed in GLPK 4.45. You can download GLPK Lab for Windows 4.45 from http://sourceforge.net/projects/glpklabw/ which contains the editor from Gusek and GLPK 4.45. Or just copy the GLPK 4.45 executable and the DLL to the Gusek directory. Best regards Xypron -------- Original-Nachricht -------- > Datum: Mon, 14 Feb 2011 13:04:17 -0600 > Von: "Meketon, Marc" <[email protected]> > An: "[email protected]" <[email protected]> > Betreff: [Help-glpk] Error when using "table" > I've been building a model using GUSEK for the IDE, which seems to use > GLPK 4.44. > > From time to time, when writing out to an Access table using the "table" > feature, I get a message from Windows saying "GLPSOL.EXE has stopped > working" > > GUSEK then reports an "Exit code: -1073740940". > > I have 3 "table" statements, all of them writing to the same database > table. In the first "table" statement, I have 2 SQL statements: a > "DELETE FROM tbl;" followed by an "INSERT INTO tbl" type statement. > In the second and third "table" statement, I have only one SQL statement, an > "INSERT INTO" > type. > > When I change the first "table" command to output to CSV file, the > output looks fine. And the other two "table" statements work fine. > Then I change the first "table" statement back to using ODBC, and > suddenly it works - at least for the next 10 times I run it. But then > it stops working, and doesn't work again till I repeat the "CSV" trick. > > Question 1: I suspect that there is a timing issue with having two > SQL statements - that Access hadn't released the table yet after the > DELETE FROM statement before it tried to do the INSERT INTO. Is that > possible? Is there anything I can do about it. > > Question 2: Just to play it safe, I tried to create a fourth "table" > statement with the DELETE FROM sql in it, and run that first at the beginning. > Except that it does not work. Specifically I tried (after finding > something that syntactically works): > > table result2 {x in EMPTY_TYPES : x=""} # this is the null set, no > string in EMPTY_TYPES is blank > OUT 'ODBC' > 'Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=' & > DB_LOCATION & ';' > 'DELETE FROM fc_ForecastEmpties;' : 1~ID; > > But it did not delete the records, and the GLPSOL output says: > > Writing result2... > Connected to ACCESS 04.00.0000 - C:\Forecast.mdb > INSERT INTO DELETE FROM tbl_result; ( ID ) VALUES ( ? ) > > So by not having an INSERT INTO statement, it looks like the "table" > statement put one in automatically, and in an unexpected place. > > > ________________________________ > This e-mail and any attachments may be confidential or legally privileged. > If you received this message in error or are not the intended > recipient, you should destroy the e-mail message and any attachments > or copies, and you are prohibited from retaining, distributing, > disclosing or using any information contained herein. Please inform us > of the erroneous delivery by return e-mail. Thank you for your cooperation. -- GMX DSL Doppel-Flat ab 19,99 Euro/mtl.! Jetzt mit gratis Handy-Flat! http://portal.gmx.net/de/go/dsl ---------------------------------------------------------------------------- This e-mail and any attachments may be confidential or legally privileged. If you received this message in error or are not the intended recipient, you should destroy the e-mail message and any attachments or copies, and you are prohibited from retaining, distributing, disclosing or using any information contained herein. Please inform us of the erroneous delivery by return e-mail. Thank you for your cooperation. ---------------------------------------------------------------------------- This e-mail and any attachments may be confidential or legally privileged. If you received this message in error or are not the intended recipient, you should destroy the e-mail message and any attachments or copies, and you are prohibited from retaining, distributing, disclosing or using any information contained herein. Please inform us of the erroneous delivery by return e-mail. Thank you for your cooperation. _______________________________________________ Help-glpk mailing list [email protected] http://lists.gnu.org/mailman/listinfo/help-glpk
