Aly, This is the SQL script snippet found in transp.sql (below) that creates 2 primary keys. The location of the script is in ...glpk-4.42/examples/sql/transp.sql for mysql.
CREATE TABLE transp_result ( LOC1 TEXT(127), LOC2 TEXT(127), QUANTITY REAL, PRIMARY KEY ( LOC1(127), LOC2(127) ) ); In Access, you can not create 2 primary keys in one table. Please see transp_result table in design view in transp.mdb that i created. There is no primary key in transp_result. Putting a primary in one of the field will create an error - it will not write the solution - 62 error. I hope it is clear now. Noli On 2/11/10, Aly Megahed <[email protected]> wrote: > Thanks a lot, Noli. I really appreciate your attention and detailed reply. > I'll check it out and get back to you if there are any problems. > > However, I didn't get the tip you mentioned?! Do you mean that if a table > has more than 1 primary key, then it won't work? And if so, what's the > solution to that problem? > > Thanks, > > Aly _______________________________________________ Help-glpk mailing list [email protected] http://lists.gnu.org/mailman/listinfo/help-glpk
