Error Getting Group Cell
Cell. [message #472619] Mon, 23 August 2010 01:19 manisha_borade Messages: 49Registered: May 2010 Member DECLARE rg_id RecordGroup; rec_count NUMBER; BEGIN -- Get the record group ID -- rg_id := Find_Group( 'PAYMENT_TERM_RG' ); -- Get the number of rows -- rec_Count := Get_Group_Row_Count( rg_id ); -- delete the selected row -- FOR j IN 1..rec_Count LOOP If Get_Group_Number_Cell( 'PAYMENT_TERM_RG.DESCRIPTION', j ) = :XX_PAYMENT_TERM.ATTRIBUTE1 Then Delete_Group_Row( rg_id, j ); exit ; End if ; END LOOP; END; Report message to a moderator Re: frm-41084 Error getting Group Cell. [message #472691 is a reply to message #472619] Mon, 23 August 2010 05:03 cookiemonster Messages: 12330Registered: September 2008 Location: Rainy Manchester Senior Member Post the record group query. And please use [code] tags - you know how. Report message to a moderator Previous Topic: Cursor Problem Next Topic: FRM-92100 Error in Oracle 10.1.0.4 under UNIX B.11.11 Goto Forum: - SQL & PL/SQLSQL & PL/SQLClient Tools- RDBMS ServerServer AdministrationBackup & RecoveryPerformance TuningSecurityNetworking and GatewaysEnterprise ManagerServer Utilities- Server OptionsRAC & FailsafeData GuardReplicationStreams & AQSpatialText & interMedia- Developer & ProgrammerApplication Express, ORDS & MOD_PLSQLFormsReports & DiscovererDesignerJDeveloper, Java & XMLWarehouse BuilderPrecompilers, OCI & OCCI- Fusion Middleware & Colab SuiteWeblogic & Application ServerBusiness IntelligenceWebCenter Suite & PortalCollaboration & Content ManagementSOA Suite, BPEL and OWSM- ApplicationsOracle Fusion Apps & E-Business SuitePeopleSoft, JD Edwards & SiebelPrimaveraOther Application Suites- InfrastructureHardwareUnixLinuxWindowsOther Operating Systems- Open SourceProgramming InterfacesMySQL- OtherGeneralTraining & CertificationMarketplaceCommunity HangoutSuggestions & FeedbackTest- Non-English ForumsArabicDutchFrenchGermanJapanesePortugueseRussianSpanish -=] Back to Top [=- [ Syndicate this forum (XML) ] [ ] Current Time: Tue Oct 11 08:36:51 CDT 2016 Total time taken to generate the page: 0.19377 seconds .:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.
Get the number of rows -- rec_Count := Get_Group_Row_Count( rg_id ); -- delete the selected row -- FOR j IN 1..rec_Count LOOP If Get_Group_Number_Cell( 'PAYMENT_TERM_RG.DESCRIPTION', j ) = :XX_PAYMENT_TERM.ATTRIBUTE1 Then Delete_Group_Row( rg_id, j ); exit ; End if ; END LOOP; END; View 1 Replies Similar Messages: Forms :: Frm-41075 Error Deleting Group? Forms :: On Cell Phone Through Internet Using Live IP? JDeveloper, Java & XML :: Missing Expression And Then Group Function Not Allowed Error Server Administration :: ORA-29702 / Error Occurred In Cluster http://www.orafaq.com/forum/t/160943/ Group Service Operation Update Long String Cell By SQL Command? PL/SQL :: Split Delimited Cell Into Multiple Rows SQL & PL/SQL :: Connecting From Oracle To Excel To Copy Results In Cell Value Reports & Discoverer :: Order Matrix By Cell Content? Reports & Discoverer :: Rpt2Xls Cell Merge And Center? Application Express :: Cell Padding In SQL Report Region http://oracledba.bigresource.com/Forms-frm-41084-Error-getting-Group-Cell--Snc2ZUbdo.html Reports & Discoverer :: Rotate Text Inside Matrix Cell? Reports & Discoverer :: REP-1813 / Object F_2 Too Large To Fit In Matrix Cell Reports & Discoverer :: Matrix Report Cell If No Data Then Display (A) Application Express :: Changing Background Color Of A Cell From APEX_ITEM? Group Records With Less Than One Hour Separation And Count How Many Per Group Exadata :: Monitoring Cell Server With OS Watcher / Other Command Line Tools Forms :: How To Use Group By Command In 6i SQL & PL/SQL :: Combining Rownum And Group By Gives - Not A Group By Expression Forms :: Dynamic Record Group For LOV? Forms :: Query In Record Group Forms :: FRM-41827 - Group Does Not Exist? Forms :: Get Record Group Query Forms :: How To Apply Group By Command In 6i Forms :: Dynamic Record Group Forms :: Saving The Object Group Forms :: Changing Record Group For LOV At Run Time Forms :: Dynamically Changing The Record Group? Forms :: Pivot Table Inside Group Forms :: FRM-41072 Cannot Create Group List ADVERTISEMENT
is of CHAR, DATE, error getting or NUMBER, respectively. Check the validity of the row number and column name specified.Level: 20 Trigger: error getting group ON-ERROR Discussions and Solutions for FRM-41084: Error getting Group Cell. Oracle Forms Books FRM-41084: Error getting Group Cell. Record: 1/1 Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners Oracle: Registered trademark of Oracle