How do u give the list of values in bind parameter
Answer / vetrikumaran
GO TO THE PROPERTY PALLETE OF USER DEFINED PARAMETER AND
SELECT THE PROPERTY AS LIST OF VALUES..
THEN IT SHOWS STATIC AND SELECT..SELECT THE SELECT OPTION
AND WRITE THE QUERY..NOW IN THE OUTPUT,WE CAN FIND THE LIST
OF PARAMETER VALUES..
USER WILL SELECT THE VALUES ONLY FROM LOV.
Is This Answer Correct ? | 3 Yes | 0 No |
What are the important difference between property clause and visual attributes?
how to create the triggers in the forms?
what is bit map and character mode
What is WHEN-Database-record trigger?
what is latest version in reports
If the maximum record retrieved property of the query is set to 10 then a summary value will be calculated?
Can we use GO-BLOCK package in a pre-field trigger ?
How do you control the constraints in forms ?
i want to print the employee details on department wise with group above report with the fields DEPTNO------group above ENAME ------ SAL-------- COMM------ I WANT OUTPUT LIKE THIS ---------------------------------------------------------- 1)FIRST DEPTNO=10 EMPLOYEES DISPLAYED IN FIRST PAGE AND DEPTNO=20 EMPLOYEES DISPLAYED IN 2ND PAGE WHAT I HAVE TO DO OUTPUT ------- --FIRST_PAGE ----------- DEPTNO:10 ENAME SAL COMM KING 5000 A 2000 2222 ---- =- -- SECONDPAGE DEPTNO:20 ENAME SAL COMM MILLER 220 22 D 45 23 -- - - LIKE THE ABOVE PROCDURE REPORTS HOW MANY DEPARTMENTS ARE EXISITING IN EMP TABLE
What is a Trigger ?
What are the sql clauses supported in the link property sheet?
List the windows event triggers available in Forms 4.0?