[Help-glpk] Least significant digit error in "table" statement

[Meketon, Marc]

I have a simple "table" statement that fails with the message: 'E-2' cannot be converted to a number.

 

One of the input numbers (for the field TransitTime) is 0.0191176470588235.  When I strip away the least significant digit to make it 0.019117647058823, the "table" statement works fine.

 

The test code is below; the Access database and model file are attached.

 

param DB_LOCATION symbolic := "C:\TestOfTable.mdb";
#param ACCESS_DRIVER symbolic := "Driver={Microsoft Access Driver (*.mdb)}";
param ACCESS_DRIVER symbolic := "Driver={Microsoft Access Driver (*.mdb, *.accdb)}";

 

set OD_R dimen 2;
param TransitTimeHours     {OD_R};

 

table R IN 'ODBC'
   ACCESS_DRIVER & ';DBQ=' & DB_LOCATION & ';'
  'SELECT FromCode, ToCode, TransitTime '
  'FROM tbl'  :
  OD_R                 <- [FromCode,ToCode],
  TransitTimeHours      ~ TransitTime;

 

display card(OD_R);

 

end;

---

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.

TestOfTable.zip
Description: TestOfTable.zip