Aimms Tutorial for professionals-Error

[u112...@tuks.co.za]

Hello there. 

I am trying to follow aimms tutotial for professionals but i am stuck on page 81, my program is failing to execute the procedure " ReadFromDatabase" and its giving me the following error that i dont quite understand. Can someone kindly help on how i can pass this one? 

"Obtaining info record of sql query "SELECT Factory, COUNT(ProductionLines) As LineCountFROM ProductionLines GROUP BY Factory" of database procedure "NumberOfProductionLinesQuery" failed: ODBC Error: (42000) [Microsoft][ODBC Microsoft Access Driver] The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect."

Thank you.

Dit.

[Guido Diepen]

Hi Dit,

it appears you don't have a space between LineCount and FROM: LineCountFROM 

The FROM is actually the keyword in SQL, so access is missing this detail at the moment.

Guido Diepen

AIMMS Specialist