|
|
|
|
| Re: no of rows in a block [message #307513 is a reply to message #305787] |
Wed, 19 March 2008 01:07   |
thomasscaria
Messages: 21
Registered: July 2007
Location: Kuwait
|
Junior Member |
|
|
FUNCTION query_count (p_block_name VARCHAR2) RETURN NUMBER
IS
cnt NUMBER;
BEGIN
GO_BLOCK(p_block_name);
COUNT_QUERY;
cnt := GET_BLOCK_PROPERTY(p_block_name, QUERY_HITS);
IF FORM_SUCCESS THEN
RETURN (cnt);
ELSE
MESSAGE('Error in getting Query Hits for block '||:SYSTEM.CURRENT_BLOCK);
RAISE FORM_TRIGGER_FAILURE;
END IF;
END;
WHEN-BUTTON-PRESSED trigger of 'Details'button
DECLARE
v_cnt NUMBER;
BEGIN
v_cnt := query_count(<detail block name>);
IF (v_cnt = 0) THEN
p_show_alert('No Details exist.');
ELSE
GO_BLOCK(<detail block name>);
EXECUTE_QUERY;
END IF;
END;
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
