Hi All, Suppose I have 3 sets, J, R and T for Facilities, Resources and Periods respectively and that each is well defined. And suppose there is a set of dimension 3 that was defined as follows:
set FacilityResourcePeriod, dimen 3; table FacilityResourcePeriod_jrtt IN "ODBC" 'FileDSN=.\d2.dsn;READONLY=FALSE' 'TransformerTypePeriodResources' : FacilityResourcePeriod <-[FacilityID, ResourceID, PeriodID]; Note that the set FacilityResourcePeriod would not have all possible combinations of the elements of J, R and T (as the table its values are read from has only a subset of the combinations). What I would like to do is to define a set, that is a subset of J, and that only contains the Facilities that are in FacilityResourcePeriod. I tried to define it that way: set Facilities_IN_FacilityResourcePeriod, dimen 1; table Facilities_IN_FacilityResourcePeriod_jrtt IN "ODBC" 'FileDSN=.\d2.dsn;READONLY=FALSE' 'TransformerTypePeriodResources' : Facilities_IN_FacilityResourcePeriod <-[FacilityID]; But when the data were read, I get an error of "Duplicate Tuple 1 Detected" which is expected since the same FacilitiID can be in multiple records (each with a different combination of ResourceID and PeriodID). So, how can I define such a set? Any help will be greatly appreciated! Aly -- PhD Student Rm. 407 Main Building H. Milton Stewart School of Industrial and Systems Engineering Georgia Institute of Technology 765 Ferst Dr., NW Atlanta, Georgia 30332-0205, USA _______________________________________________ Help-glpk mailing list [email protected] http://lists.gnu.org/mailman/listinfo/help-glpk
