How to pass parameter to SQL?

Hi,
i've written this code in a procedure (i didn't create report),
actually i want to give a date condition based on user data, based on that conditional result, i need to create report. can anybody help in this?
(i want where condition in this select statement)

SQL
Select Ename, Job, HireDate, Sal, Comm From Emp;
END

thanq

vijay

posted

Vijay,
Different databases have different date formats. Here is the example for Oracle.

Select Ename, Job, HireDate, Sal, Comm From Emp where HireDate = '01-OCT-2003';

Does this answer your question?

Thanks and Regards
Satish Paladugu

posted

Hi Satish,
Thanq very much for ur reply,

I know this, but i wanted to check for the date entered by the user, something like this

Select Ename, Job, HireDate, Sal, Comm From Emp where HireDate = '&UserDate';

And i wanted to use this result in a different report, can u plz help me out, i'm totally confused,

thanx n regards

vijay

posted

Vijay,

You can directly write a SQL query in your fex file and you can hold/save the output from that query in a holdfile. You can use some thing like this if you are using ORACLE:

SQL SQLORA SET SERVER servername

SQL SQLORA

Select Ename, Job, HireDate, Sal, Comm From Emp where HireDate = '&UserDate';

TABLE
ON TABLE HOLD AS holdfile
END

TABLE FILE holdfile
PRINT Ename Job HireDate Sal Comm
END

I hope this work for you!

Thanks,
Vijay

posted

Thanx for the reply,

Select statement is working properly, but if i give where condition, like,

SELECT EMPNO, ENAME, HIREDATE, JOB FROM EMP WHERE HIREDATE = '&USERDATE';

it is not prompting for the parameter value and even if i open it in resource layout, it's not showing any textbox object.

can u plz. tell me what i've to do?

vijay

Please Wait. Your request is being processed...