| how to restrict creating new records in details block [message #87516] |
Mon, 10 January 2005 23:34  |
Mohan G
Messages: 36
Registered: August 2004
|
Member |
|
|
hello
i need to restrict creation of new record (based on some condition) when the user goes to the next record in block.if all the compulsory fields are entered in the current record then only a new record is to be created.
how to do it ?
i am using data block
|
|
|
|
| Re: how to restrict creating new records in details block [message #87530 is a reply to message #87516] |
Tue, 11 January 2005 18:15  |
ashish
Messages: 107
Registered: December 2000
|
Senior Member |
|
|
try this on save button
**********************************
if :a is null then
message('a can not be null');
rase FORM_TRIGGER_FAILURE
elsif :b is null then
message('b can not be null');
rase FORM_TRIGGER_FAILURE
end if;
************************************
or u can also set block prorety as
set_block_porperty('block_name',insert_allowed,property_false);
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
