Home » Developer & Programmer » Forms » FRM 40102 Records must be inserted or deleted first
FRM 40102 Records must be inserted or deleted first [message #119207] Wed, 11 May 2005 03:56 Go to next message
Gokul
Messages: 21
Registered: October 2000
Junior Member
In Oracle 9i DS (Forms), when i use the following code in the KEY-NEXT-ITEM trigger of item "sup.add3" which resides in block "sup"
Block : sup - Non Database Block(Control Block),Single Record display

Item : Name - Type
-----------------------
Item 1 : code - Text Item
Item 2 : name - Text Item
Item 3 : add1 - text Item
Item 4 : add2 - text Item
Item 5 : add3 - text Item
Item 6 : cancel - push button
Item 7 : home - push button

Coding :
Trigger : KEY-NEXT-ITEM
Block : sup Item : add3


begin
go_block('sup');
next_record;
-- or create_record;
go_item('sup.code');
end;



I got the following error repeatedly


FRM 40102 Records must be inserted or deleted first


Give me Solution for this error as soon as Possible.
Re: FRM 40102 Records must be inserted or deleted first [message #119210 is a reply to message #119207] Wed, 11 May 2005 04:11 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
General question to anyone. Can a non-database block have more than one record?

David
Re: FRM 40102 Records must be inserted or deleted first [message #119211 is a reply to message #119207] Wed, 11 May 2005 04:16 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Gokul,

Where are you going to store your data once it is keyed in? If you are going to place it in a table that has, at least, 5 (five) fields - code, name, add1, add2, add3, then why don't you base your block SUP on that table.

Just leave the buttons on the other non-database block.

David
Re: FRM 40102 Records must be inserted or deleted first [message #119220 is a reply to message #119207] Wed, 11 May 2005 05:31 Go to previous messageGo to next message
Gokul
Messages: 21
Registered: October 2000
Junior Member
here is the answer for your doubts or suggestions:

Control Block can have more than one record

Form's Property : mouse navigation limit - Record
so the push button must be in the same block.
when i press enter key the data will be retained in that record itself.

Can you give the solution(or reason like why it comes) not a suggestion (because that is my requirement)

Anyhow thanks.
Re: FRM 40102 Records must be inserted or deleted first [message #119334 is a reply to message #119207] Wed, 11 May 2005 20:01 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
<rant>The reason I give a suggestion to use two blocks is because it works and it works easily.

I have too many things to do and too little time in which to do them to spend my time resolving others people's half-baked ideas.</rant>

For reasons why you should use two blocks, please go to http://www.oracle.com/technology/documentation/forms.html, find 'Guidelines for Building Applications'. Download it and keep it as part of your reference material.

As I asked in my previous reply "Where are you going to store your data once it is keyed in? If you are going to place it in a table that has, at least, 5 (five) fields - code, name, add1, add2, add3, then why don't you base your block SUP on that table.

Just leave the buttons on the other non-database block."

The push buttons DO NOT need to be in the same block. It is a push button and can be 'clicked' by the mouse even if it is keyboard navigable = False.

I suggest that you reread your assignment. I believe that it says 'all fields are in one record'. For me, buttons are not fields, therefore, they don't need to be in the same record/block.

David

Re: FRM 40102 Records must be inserted or deleted first [message #119337 is a reply to message #119207] Wed, 11 May 2005 22:49 Go to previous messageGo to next message
Gokul
Messages: 21
Registered: October 2000
Junior Member
djmartin,

1) In Forms if the mouse navigation limit is Record(not keyboard navigable is false) then when-button-trigger of different block will not fire. so only i used push buttons on the same block.

2) Also, if sup block is used as database block then if commit is used then the records in that will get saved. I don't want that I want to manually Insert record.

Finally if you have no time then no need to send suggestions and don't think that only your idea is best and others are half-baked.
Re: FRM 40102 Records must be inserted or deleted first [message #120125 is a reply to message #119207] Tue, 17 May 2005 18:45 Go to previous messageGo to next message
danosw
Messages: 20
Registered: May 2005
Location: California
Junior Member
Your block is (probably) set to Single Record = Yes. So you will always get that error when you do a "Next Record".

I'm not sure what your goal is but try setting the block property Single Record = NO.


And yes, a non-database block can have multi-records. Just set the 'Number of Records Displayed' > 1.


Dano
FRM 40102 Records must be inserted or deleted first [message #356113 is a reply to message #119207] Wed, 29 October 2008 11:03 Go to previous messageGo to next message
remoto
Messages: 2
Registered: October 2008
Junior Member
Hi everbody, excuse me for posting a problem that was previously posted and solved, but the solution doesn't work for me.

first_record;
loop
:b2.id_cat1:= :b.cat1;
:b2.id_cat2:= :b.cat2;
:b2.id_cat3:= :b.cat3;
:b2.id_cat4:= :b.cat4;
exit when :system.last_record = 'true';
next_record;
end loop;

Block "B" is not table based and contains the values returned from a Lov (list of values), block "b2" is table based and I scan the whole block in order to assign those values (from B) to the fields.

Thank you very much for your help.
Re: FRM 40102 Records must be inserted or deleted first [message #356250 is a reply to message #356113] Thu, 30 October 2008 01:38 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Looks good to me! What is not working? What are you seeing in the database?

David
Re: FRM 40102 Records must be inserted or deleted first [message #356733 is a reply to message #356250] Sat, 01 November 2008 12:19 Go to previous messageGo to next message
remoto
Messages: 2
Registered: October 2008
Junior Member
Thank you for your answer. Before entering the loop I select some values from a LOV, then I enter the loop and scan the whole "B2" block assigning those values to the fields of that based table block. When it reaches the end of the block shows the error "frm 40102 Records must be inserted or deleted first" and abort the execution.
Re: FRM 40102 Records must be inserted or deleted first [message #356876 is a reply to message #356733] Sun, 02 November 2008 23:31 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
In which trigger do you have the code that you posted? On which command in which trigger are you when the "frm 40102 Records must be inserted or deleted first" message appears?

David
Previous Topic: LOV Query Display Problem
Next Topic: Simple Animation Sample Form
Goto Forum:
  


Current Time: Thu Dec 08 00:18:43 CST 2016

Total time taken to generate the page: 0.11704 seconds