New post

Usinng SQLRD constant in condition query for event schedule

I have an event schedule with a number of conditions that are sql based.

e.g. select * from controlTable where event_name = 'DAILY_REPORTS', where DAILY_REPORTS is the name of the event schedule.

I would like to be able to use

select * from controlTable where event_name = '<[m]CurrentScheduleName>', but that does not seem to work. It does not look like SQLRD replaces the string with the name of the current schedule before executing the query.

Does anyone know how to do this? I need SQLRD to replace a string with the current schedule name as part of a sql query.


Please sign in to leave a comment.