Support Forums
'WHERE' clause not working while pulling up data via ODBC into Excel

I can successfully pull up the data into Excel using ODBC connection. The SQL statement like

select * from Alarms;

is working perfectly fine. The issue is when I use 'where' statement, I get an error. The following command is giving an error.

select * from Alarms where Active = 1;

OR

select * from Alarms where 'Active' = 1;

OR

select * from Alarms where Active = '1';

I noticed "where" clause is not working at all in all other queries as well. Please let me know what is the reason. Any workaround.

I can successfully pull up the data into Excel using ODBC connection. The SQL statement like select * from Alarms; is working perfectly fine. The issue is when I use 'where' statement, I get an error. The following command is giving an error. select * from Alarms where Active = 1; OR select * from Alarms where 'Active' = 1; OR select * from Alarms where Active = '1'; I noticed "where" clause is not working at all in all other queries as well. Please let me know what is the reason. Any workaround.

Well I found the error was in using ;. No ; must be used.

Well I found the error was in using ;. No ; must be used.
36
1
1
live preview
enter atleast 10 characters
WARNING: You mentioned %MENTIONS%, but they cannot see this message and will not be notified
Saving...
Saved
With selected deselect posts show selected posts
All posts under this topic will be deleted ?
Pending draft ... Click to resume editing
Discard draft