OraFAQ Forum: Forms » FRM-40102 Record must be entered or deleted first

Home » Developer & Programmer » Forms » FRM-40102 Record must be entered or deleted first

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

FRM-40102 Record must be entered or deleted first [message #185382]

Tue, 01 August 2006 08:24

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

Report message to a moderator

Re: FRM-40102 Record must be entered or deleted first [message #186216 is a reply to message #185382]

Mon, 07 August 2006 02:07

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

Re: FRM-40102 Record must be entered or deleted first [message #300314 is a reply to message #186216]

Fri, 15 February 2008 00:53

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

Report message to a moderator

Re: FRM-40102 Record must be entered or deleted first [message #300321 is a reply to message #300314]

Fri, 15 February 2008 01:15

mintomohan
Messages: 104
Registered: November 2006
Location: India

Senior Member

hi,

i think the code should be like:

Code: [Select all] [Show/ hide]

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

Minto

Report message to a moderator

Re: FRM-40102 Record must be entered or deleted first [message #300327 is a reply to message #300321]

Fri, 15 February 2008 01:21

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:

Code: [Select all] [Show/ hide]

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

Report message to a moderator

Re: FRM-40102 Record must be entered or deleted first [message #300340 is a reply to message #300327]

Fri, 15 February 2008 02:11

mintomohan
Messages: 104
Registered: November 2006
Location: India

Senior Member

hi,

could you please try this one:

Code: [Select all] [Show/ hide]

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

Minto

Report message to a moderator

Re: FRM-40102 Record must be entered or deleted first [message #300344 is a reply to message #300340]

Fri, 15 February 2008 02:19

lovenelza
Messages: 8
Registered: March 2007

Junior Member

mintomohan wrote on Fri, 15 February 2008 16:11

hi,

could you please try this one:

Code: [Select all] [Show/ hide]

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

Report message to a moderator

Re: FRM-40102 Record must be entered or deleted first [message #300361 is a reply to message #300344]

Fri, 15 February 2008 03:52

sasipalarivattom
Messages: 121
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.

Code: [Select all] [Show/ hide]

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

Hopes It will help you..

Regards,
Sasi...

Report message to a moderator

Re: FRM-40102 Record must be entered or deleted first [message #300562 is a reply to message #300340]

Sat, 16 February 2008 01:49

lovenelza
Messages: 8
Registered: March 2007

Junior Member

mintomohan wrote on Fri, 15 February 2008 16:11

hi,

could you please try this one:

Code: [Select all] [Show/ hide]

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

Report message to a moderator

Re: FRM-40102 Record must be entered or deleted first [message #665668 is a reply to message #185382]

Thu, 14 September 2017 09:51

verameza88
Messages: 1
Registered: September 2017

Junior Member

en mi caso, estaba cargando datos a un detalle desde un cursor dentro de un while, y tenía dos veces next_record

Report message to a moderator

Re: FRM-40102 Record must be entered or deleted first [message #665669 is a reply to message #665668]

Thu, 14 September 2017 10:24

cookiemonster
Messages: 13966
Registered: September 2008
Location: Rainy Manchester

Senior Member

Why did you think it appropriate to write in Spanish on an English thread?
It's up to you to translate into a language everyone else understands.

Report message to a moderator

Previous Topic:	How Two Records in Oracle Forms
Next Topic:	set image in background in forms 6i

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Apr 07 11:00:58 CDT 2025