Focal Point
SREG in SQL Listener

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/1381057331/m/5961036491

November 03, 2006, 06:07 PM
brandonkirsch
SREG in SQL Listener
Hello,
I'm trying to setup a SQL listener that checks for new orders that need to be processed. I am trying to use a special register to filter out orders running in different iWay configurations, say Dev for testing or Production for the real deal.

The SQL Query looks like this:
SELECT * FROM [INET].[dbo].[ELineTrafficCopNewOrders] WHERE iWayConfig = 'SREG(current_config)'

It isn't pulling any records, because according to the activity log the query is literally placing the text SREG(current_config) inside quotes.

How do I use a special register in this query? I have used SREG(variable_name) in FILE listeners just fine, I'm not sure what I'm doing wrong here. Any help is appreciated!