Re: [Help-glpk] ODBC Connection to MS-Access - WHERE ClauseSyntax problems

[Andrew Makhorin]

> Thanks for your reply but I remain confused.  I have changed the syntax
> to that proposed (I think) like this:
> 
> set psold dimen 3; 
> param qper{(i,j,k) in psold}; 
> 
> table products_table IN "ODBC" 
>         'DSN=glpk_Sales' 
>         'SELECT Product, MaterialDesc as pdesc, [Manuf Code] as prodman,
> QPer' 
>         'FROM qProductsUnique ' 
>         '"WHERE qProductsUnique.[Manuf Code]='0012LBLK'":
>         psold <- [Product, pdesc, prodman], qper~QPer; 
> 
> And I get the following error message:
> 
> Yorke.mod:39: symbol 0012L... should be enclosed in quotes
> Context: ...; table products_table IN '...' '...' '...' '...' '...' 0012
> MathProg model processing error
> 

The following is correct:

'WHERE qProductsUnique.[Manuf Code]=''0012LBLK'''

or

"WHERE qProductsUnique.[Manuf Code]='0012LBLK'"

Check the spelling in other statements.