OraFAQ Forum: Forms » Restricting user not to create more than one record in a multi record block

Home » Developer & Programmer » Forms » Restricting user not to create more than one record in a multi record block

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Restricting user not to create more than one record in a multi record block [message #79930]

Fri, 26 July 2002 05:34

Vinod
Messages: 76
Registered: April 1999

Member

Hi all,

Can anyone please tell me what is the code i have write in forms to restrict the user so that he cannot add more than 1 record in a multi record block. That is if he tries to add a second record before he saves a message should pop up saying he cannot create more than one record.

This is very urgent

Thanks
Vinod

Report message to a moderator

Re: Restricting user not to create more than one record in a multi record block [message #79931 is a reply to message #79930]

Fri, 26 July 2002 06:08

Ranjit Bisoyi
Messages: 18
Registered: November 2001

Junior Member

Hi,
See, if this works for you.

If :System.Cursor_Record > 1 then
Set_Block_Property('BlockName',Insert_Allowed,Property_False);
End If;

Regds
Ranjit Bisoyi

Report message to a moderator

Previous Topic:	about SET_WINDOW_PROPERTY.
Next Topic:	problem saving insert s into a tabular form

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 00:49:11 CDT 2024