parameter in SQL command 1

[ub1234567]

Hi everyone,
Hope everyone doing excellant.

i am using SQL query in SQL command.
query runs fine in TOAD.
but when i am tyring to filter result of query by using parameter in sql command then it gives me problem and it is not working.

when same parameter i implemented in record selection,
then it gives me appropriate results.

can anybody explain me why or how to handle parameter in SQL command ?

Thanks.

 

[Turkbear]

Hi,
Create the parameter using the Command creation wizard where you created ( I assume ) your Sql Command.

Then place the [?parametername] in the same place as you implemented it in the selection formula test.

Example:
Parameter named OfficeNumber

Command:

Select employees from Table_name where Table_name.Office_Number = {?OfficeNumber}





To Paraphrase:"The Help you get is proportional to the Help you give.."