Oracle Error 40102
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Oracle forms FRM-40102:RECORD MUST BE ENTERED OR DELETED FIRST up vote 0 down vote favorite I made this in a button on oracle forms to fill a form automatically from several table records and when I run the form it throws the error FRM - 40102 RECORD MUST BE ENTERED OR DELETED FIRST I tried manually deleting the default record first but it doesn't seem to change. DECLARE /* cursor declaration */ CURSOR C IS SELECT ALU.IDEALU, EVA.IDEEVA, UNI.IDEUNI, MAT.IDEMAT FROM ALU, EVA, UNI, MAT ORDER BY ALU.IDEALU; ALT NUMBER; R C%ROWTYPE; N NUMBER; errnum NUMBER := ERROR_CODE; V_CONT NUMBER; AL_CONT NUMBER; V_ADD_AMT NUMBER; V_ADD_DEDUCT NUMBER; V_SAL_ADD_AMT NUMBER; BEGIN SELECT COUNT(IDEALU) INTO AL_CONT FROM ALU; /*cursor open*/ OPEN C; --================= IF errnum = 40508 THEN ALT:=SHOW_ALERT('FAIL'); RAISE Form_Trigger_Failure; END IF; --================ GO_BLOCK('CAAE'); IF AL_CONT=0 THEN FIRST_RECORD; ALT:=SHOW_ALERT('FAIL'); ELSE LAST_RECORD; NEXT_RECORD; END IF; NEXT_RECORD; LOOP FETCH C INTO R; ----cursor fetch/read :CAAE.CAAEALU:=R.IDEALU; --- data assign... :CAAE.CAAEEVA:=R.IDEEVA; :CAAE.CAAEUNI:=R.IDEUNI; :CAAE.CAAEMAT:=R.IDEMAT; EXIT WHEN C%NOTFOUND; NEXT_RECORD; END LOOP; PREVIOUS_RECORD; CLOSE C; END; forms oracle plsql oracleforms share|improve this question asked Dec 9 '15 at 14:20 Sergio Yáñez Jiménez 33 add a comment| 2 Answers 2 active oldest votes up vote 0 down vote
must be entered or deleted first [message #185382] Tue, 01 August 2006 08:24 mfa786 Messages: 210Registered: 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 http://stackoverflow.com/questions/34181116/oracle-forms-frm-40102record-must-be-entered-or-deleted-first 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: 10180Registered: March 2005 http://www.orafaq.com/forum/t/67154/ Location: Canberra ACT Australia Senior MemberAccount 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: 8Registered: 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 Message
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have https://community.oracle.com/community/developer/search.jspa?q=FRM-40102 JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it http://coenni.blogspot.com/2010/10/frm-40102-record-must-be-entered-or.html enabled. Please turn JavaScript back on and reload this page.Search this communityOracle CommunityBridged communitiesOracle BlogsOracle University TrainingOracle oracle error VideosOTN DocumentationOTN Search ResultsSearch forSearch forContentSearch forPeopleSearch forPlacesLast modifiedLast modifiedAll timeLast modified1 dayLast modified7 daysLast modified30 daysLast modified90 daysLast modified1 yearSort byRelevanceRelevanceLast modifiedLast modifiedRestrict results byRestrict results by: PeopleRestrict results by: PlacesSubspace depthSubspace oracle error 40102 depthNo subspacesSubspace depthChild subspacesSubspace depthAll subspacesMatchingMatch names onlyDeactivated UsersShow/HideShowShowAll contentShowBlog postsShowDocumentsShowDiscussionsShowPollsShowIdeasShowStatus updatesShowMessagesShowExternal activityShowShowAll placesShowSpacesShowProjectsShowGroupsContent marked asShowAll ContentShowFinalShowReservedShowCommunity RecommendedShowOutdatedShowAction ItemShowDecisionShowHelpfulShowResolvedShowCommunity Feedback RequestedSocial Search On/OffSearchSearch TipsView more results from Oracle BlogsView more results from Oracle University TrainingView more results from Oracle VideosView more results from OTN DocumentationView more results from OTN Search ResultsAbout Oracle Technology Network (OTN)My Oracle Support Community (MOSC)MOS Support PortalAboutModern Marketing BlogRSS FeedPowered byOracle Technology NetworkOracle Communities DirectoryFAQAbout OracleOracle and SunRSS FeedsSubscribeCareersContact UsSite MapsLegal NoticesTerms of UseYour Privacy Rights© 2007-2016 Jive Software | Powered by Home | Top of pageJive Software Version: 8.0.3.1 , revision: 20160414082626.1619a91.release_8.0.3.x
today while writing code selecting rows from table and listing in data block gave me error FRM-40102 Record Must be entered or deleted first. after some googling I found right answer. Among the other answers there is one outstanding idea that rows which is returned vaule inserted is fewer than table-selecting rows. Hope the text below will help you. Before populating any block,First go to that block by specifying Go_block('blockname'); Since U dont use this builtin,Records in that partculat block will be 0 and if u enter any data it will give FRM-40102 error... So any time if u want to loop through any block,Place these 2 stmts. go_block('blockname'); Hope u got ur pbm.. also dont forget to use create_record; inside your loop. My example is like this: go_block('webindex'); FOR i IN (select ID, URL from Webindex) LOOP :webindex.ID:=i.ID; :webindex.URL:=i.URL; create_record; END LOOP; Posted by Coenni at 02:48 Bunu E-postayla GönderBlogThis!Twitter'da PaylaşFacebook'ta PaylaşPinterest'te Paylaş Labels: 40102, ora-error, oracle form builder Hiç yorum yok: Yorum Gönder Sonraki Kayıt Önceki Kayıt Ana Sayfa Kaydol: Kayıt Yorumları (Atom) About Me Coenni AzerbaijanianSoftwareDeveloper Profilimin tamamını görüntüle Blog Archive ► 2016 (5) ► Ağustos (1) ► Temmuz (2) ► Ocak (2) ► 2015 (2) ► Kasım (1) ► Temmuz (1) ► 2013 (10) ► Haziran (1) ► Nisan (1) ► Mart (4) ► Şubat (2) ► Ocak (2) ► 2012 (6) ► Aralık (1) ► Kasım (1) ► Eylül (3) ► Ocak (1) ► 2011 (10) ► Ağustos (2) ► Nisan (1) ► Mart (1) ► Şubat (1) ► Ocak (5) ▼ 2010 (5) ► Kasım (3) ▼ Ekim (1) FRM-40102 Record Must be entered or deleted first ... ► Eylül (1) Provider Linklər Cinayətkar Mr.Famous Categories proqramlama ruby funny programer C# ExtJs ExtJs 3.4 anecdote java jsonArray proqramci python PLSQL azərbaycan eleman error hibernate image iş həyatı jsonobject kriptoqrafiya record store şirket 20 Yanvar 40102 70 bin dolar Delivery Hero Gravity Payments MVC Nevzat Aydın Object Oriented Programming Obyekt Yönümlü Proqramlama Yemeksepeti activate add add to store array azviki azvikipediya başarı blog database design casting change checkers download checkers game checkers game with artificial intelligence checkers history class class metho