Home » Developer & Programmer » Forms » Restricting user not to create more than one record in a multi record block
Restricting user not to create more than one record in a multi record block [message #79930] Fri, 26 July 2002 05:34 Go to next message
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
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 Go to previous message
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
Previous Topic: about SET_WINDOW_PROPERTY.
Next Topic: problem saving insert s into a tabular form
Goto Forum:
  


Current Time: Tue Nov 30 12:36:49 CST 2021