Home » Developer & Programmer » Forms » FRM-40102 Record must be entered or deleted first
FRM-40102 Record must be entered or deleted first [message #185382] Tue, 01 August 2006 08:24 Go to next message
mfa786
Messages: 210
Registered: February 2006
Location: karachi
Senior Member
hi master
Sir
I create new record by using F6 key but I not record this record and I press delete button from menu and all field blank but system give me this error

FRM-40102 Record must be entered or deleted first

And no delete that blank record

And not move to next record

Please give me idea how I solve this problem

Thanks

Aamir


Re: FRM-40102 Record must be entered or deleted first [message #186216 is a reply to message #185382] Mon, 07 August 2006 02:07 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
In the Key_DelRec trigger test the status of the record. If it is a real record then continue with the delete, otherwise just clear the record.

David
Re: FRM-40102 Record must be entered or deleted first [message #300314 is a reply to message #186216] Fri, 15 February 2008 00:53 Go to previous messageGo to next message
lovenelza
Messages: 8
Registered: March 2007
Junior Member
Hello, Sir.

I am also getting this message. Can you help me on this?

I'm getting it everytime I press Add button.

Add button contains these codes:
BEGIN
toolbar_action;
GO_ITEM('tbl_matclaims_claimanttype.description');
SET_ITEM_PROPERTY('h_toolbar.btn_qry',ENABLED, PROPERTY_FALSE);
SET_ITEM_PROPERTY('h_toolbar.btn_canclqry',ENABLED, PROPERTY_FALSE);
SET_ITEM_PROPERTY('h_toolbar.btn_save',ENABLED, PROPERTY_TRUE);
END;

KEY_CREREC contains these codes;
BEGIN

create_record;
SET_BLOCK_PROPERTY('tbl_matclaims_claimanttype', INSERT_ALLOWED, PROPERTY_TRUE);

END;

Thank you.

Nelza
Re: FRM-40102 Record must be entered or deleted first [message #300321 is a reply to message #300314] Fri, 15 February 2008 01:15 Go to previous messageGo to next message
mintomohan
Messages: 104
Registered: November 2006
Location: India
Senior Member
hi,

i think the code should be like:

BEGIN
   SET_BLOCK_PROPERTY ('tbl_matclaims_claimanttype',insert_allowed,property_true);
   CREATE_RECORD;
END;

Minto
Re: FRM-40102 Record must be entered or deleted first [message #300327 is a reply to message #300321] Fri, 15 February 2008 01:21 Go to previous messageGo to next message
lovenelza
Messages: 8
Registered: March 2007
Junior Member
mintomohan wrote on Fri, 15 February 2008 15:15
hi,

i think the code should be like:

BEGIN
   SET_BLOCK_PROPERTY ('tbl_matclaims_claimanttype',insert_allowed,property_true);
   CREATE_RECORD;
END;

Minto


Hi, Minto.

I interchanged the code but I'm still getting that message.

Nelza
Re: FRM-40102 Record must be entered or deleted first [message #300340 is a reply to message #300327] Fri, 15 February 2008 02:11 Go to previous messageGo to next message
mintomohan
Messages: 104
Registered: November 2006
Location: India
Senior Member
hi,

could you please try this one:

BEGIN
   SET_BLOCK_PROPERTY ('tbl_matclaims_claimanttype',insert_allowed,property_true);
   GO_BLOCK ('tbl_matclaims_claimanttype');
   LAST_RECORD;
   CREATE_RECORD;
END;

Minto
Re: FRM-40102 Record must be entered or deleted first [message #300344 is a reply to message #300340] Fri, 15 February 2008 02:19 Go to previous messageGo to next message
lovenelza
Messages: 8
Registered: March 2007
Junior Member
mintomohan wrote on Fri, 15 February 2008 16:11
hi,

could you please try this one:

BEGIN
   SET_BLOCK_PROPERTY ('tbl_matclaims_claimanttype',insert_allowed,property_true);
   GO_BLOCK ('tbl_matclaims_claimanttype');
   LAST_RECORD;
   CREATE_RECORD;
END;

Minto



Minto,

This code doesn't work either.

Nelza
Re: FRM-40102 Record must be entered or deleted first [message #300361 is a reply to message #300344] Fri, 15 February 2008 03:52 Go to previous messageGo to next message
sasipalarivattom
Messages: 118
Registered: June 2007
Location: Cochin ( INDIA )
Senior Member

Dear Friends,

I was also getting some such errors but I solved it.
It may be a foolish coding but the result satisfied me.

In my data block, there where some required fields.
I know that if any of this field is null, then it is not a valid record. So I did a checking before I create a record.

In key create record trigger, I wrote the following code.

   LAST_RECORD;
If :my_block.req_field is null then
   clear_record;
end if;
create_record;


Hopes It will help you..

Regards,
Sasi...
Re: FRM-40102 Record must be entered or deleted first [message #300562 is a reply to message #300340] Sat, 16 February 2008 01:49 Go to previous message
lovenelza
Messages: 8
Registered: March 2007
Junior Member
mintomohan wrote on Fri, 15 February 2008 16:11
hi,

could you please try this one:

BEGIN
   SET_BLOCK_PROPERTY ('tbl_matclaims_claimanttype',insert_allowed,property_true);
   GO_BLOCK ('tbl_matclaims_claimanttype');
   LAST_RECORD;
   CREATE_RECORD;
END;

Minto



I've found out that the message appears because I'm already in the first record and I'm still invoking create_record command. When I removed the create_record, the message disappeared.

Thanks for all your help.

Nelza
Previous Topic: getting error while accessing d2k form builder
Next Topic: How to Open File in Developer 10g using GET_FILE_NAME
Goto Forum:
  


Current Time: Sun Dec 11 02:31:05 CST 2016

Total time taken to generate the page: 0.03727 seconds