Hi,
I’m using Parameters in Commands for the first time (across SQL Server database).
I’ve created a parameter and tried to put it into my command.
SQL below for simplicity…
SELECT TOP 1 x.myField
FROM myData x
WHERE x.myOtherField = ''' + {?My Parameter} + '''
However, while the parameter (string data type) has appeared in the report and I am prompted for it, I get no results even when there is data.
Is there something amiss with the way I’ve added the parameter into the Command?
milestyle (BOB member since 2016-11-17)