DB tag binding to SQL query

OK, I am missing something very simple here (I think).

I am attempting to bind a DB tag to a value in my SQL database. I have attempted the following:

SELECT value FROM table WHERE Idx = 1

This is not working for me. Should I be using a system.db function? Is this something that I need not to be doing? I have this query working as a dynamic property for one of the windows, but want to be able to access it when this window is not active.

Thanks.

Adam

The SQLTags realtime provider needs to have your DB selected as the default in order to run that query. You can set this in the Ignition Gateway configuration by editing the default SQLTags provider under SQLTags -> Realtime.