Error in Softdrink planning tutorial for professional

  • 28 January 2022
  • 2 replies
  • 52 views

Userlevel 1
Badge +4

Hi, 

 

I’m new to AIMMS and I’m following the tutorial for professional. I’m in page 80 now and while running the procedure ‘ReadFromDatabase’, I encounter an error saying, 

“Executing SQL query "TotalDemand" of database procedure "TotalDemandQuery" failed: ODBC[-3500] : 42000 [Microsoft][ODBC Microsoft Access Driver] Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'. [while calling the query TotalDemand].”

 

I don’t understand this error as the tutorial does not say anything on this issue and I think I’ve followed the tutorial completely. 

 

Any help, please?

 

 


2 replies

Userlevel 4
Badge +7

Can you check if you have selected “Stored Procedure” and not “Sql Query” in the TotalDemandQuery identifier?

Userlevel 1
Badge +4

Yes, I’ve selected for the “Stored Procedure” in the identifier. It still gave the error. 

Strangely enough, I open again the case just now and it works perfectly :smile: . Thanks anyway ya

Reply


Didn't find what you were looking for? Try searching on our documentation pages:

AIMMS Developer & PRO | AIMMS How-To | AIMMS SC Navigator