Query Citadel5 db for column name containing a dot

[sgeppert]

Hello,

I am writing an application that accesses a Lookout 6.0.2/Citadel 5 database.  I am able to connect and query via ODBC to retrieve values for most data points, but I cannot seem to query for data points whose names contain a dot. i.e. "//server/process/DataTableObject.Alias".  Do I need to escape the period character?

My query looks like:
select LocalTime, server/process/DataTableObject.Alias as data from nicit.intdata where IntInterval='15:00' and LocalTime is not null and select LocalTime, server/process/DataTableObject.Alias is not null and localtime >= '2006-04-01 00:00:00' order by localtime desc

Thanks

-scott

[sgeppert]

yes, you have to escape the '.' with an '@'

see

http://zone.ni.com/devzone/conceptd.nsf/webmain/ADA7D25D95DD50D68625680800729D71

Cheers