Hello Adeel, I ran my SQL statement designed exactly as you have mentioned in your post, it goes through but doesn't prompt me for the input value.
When I run my SQL it will only generate the titles of the column without any data in it.
Please help me with this.
I tried the statement given by Adeel on my table.
select * from T_test
where dtmid = ?inputvalue1
It did prompt for inputvalue and returned rows.
If for given input value you don't have data present in table then it will return no rows.
Hi Bibek, Are you using SQLA tool, in sqla tool you have option in tools>options>query> check , allow parameterized queries. It should ask for value when run.