how can create the lexical parameter after the select class?
Answer / ashutosh
just create a parameter
and write sql command in report like this...
select * from emp
where &condition
| Is This Answer Correct ? | 9 Yes | 0 No |
What is strip sources generate options?
can you convert or reverse engineer a fmx back to a fmb file?
in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement
What is the difference between $$DATE$$ & $$DBDATE$$
When is PRE-QUERY trigger executed ?
How is link tool operation different between reports 2 & 2.5?
What is an User_exit?
In what situation u create the BPA.
What are three panes that appear in the run time pl/sql interpreter?
What is a predefined exception available in forms 4.0?
What is the use of place holder column?
What are the triggers associated with the image item?