SQL in C/Side ODBC

ronacaxton

I'm trying to access Navision Attain through ODBC using SQL. I'm trying to use a CASE statement, but I'm getting an error everytime it runs. The error is:
[Navision software a/s][Navision Attain ODBC Driver]Expected lexical element not found: FROM

the sql i'm using is:

select
case "G_L_Entry.G_L_Account_No_" of "G_L_Entry.G_L_Account_No_"::"673M80": code := "COMMFEES" end
from G_L_Entry;

What am I doing wrong. All help appreciated.

ingrid

Did you ever find the answer. I'm getting the same error message when trying to use GetDate(). I simply want to query the last modified date that equals today. I've spent two days on this and I can't fint the correct syntax