Parameter Prompt Mystery

[SonomaCharles]

LO 25.8.4.2 on Windows, HSQLDB external v2.7.4

The following query works as expected:

SELECT "Sequence", ROW_NUMBER ( ) OVER ( ) AS "Row_Number" FROM ( SELECT DISTINCT "Sequence" FROM "Clients" WHERE "Route" = 'B' ) 

The following query gives the error

SELECT "Sequence", ROW_NUMBER ( ) OVER ( ) AS "Row_Number" FROM ( SELECT DISTINCT "Sequence" FROM "Clients" WHERE "Route" = :Enter_Route ) 

Can anyone see what the problem is? (Variations in the placement of the blanks between the equal sign, the colon and Enter_Route seem to have no effect.)

Thanks,
Charles

[CRDF]

Check if SQL Direct button is not pressed (ON) in queries GUI.
Parameters need the Base parser.
Parameters dialog shows up?