AnsweredAssumed Answered

ODBC Issue

Question asked by MikeyG79 on Jan 12, 2010
Latest reply on Jan 12, 2010 by kapitaen_1

Title

ODBC Issue

Post

Trying to make an ODBC call to a FM10 server (win2003) from my XP workstation with the Datadirect ODBC driver.

Using Perl, I can run this query fine:

 

SELECT Activity.Status, Activity.ResourceName_Date FROM Activity

 

When I try to run this:

SELECT Activity.Status FROM Activity WHERE Activity.ResourceName_Date = "Michael01122009"

 

it fails saying Column Not Found  Michael01122009. Can't understand why.

Outcomes