Home » Developer & Programmer » Forms » FRM-30058: Invalid name for a record group column (merged by CM) (oracle 10g on XP)
FRM-30058: Invalid name for a record group column (merged by CM) [message #441633] Tue, 02 February 2010 05:31 Go to next message
nehaverma
Messages: 80
Registered: January 2010
Location: JAIPUR
Member
hallo

please suggest me what can I do in this case.
earlier the query was running on same record group but i hav to delete some code so i did but after made such changes it returns this error.
but still query is correct i complied on toad.
thank you.

regards//
Neha
Re: FRM-30058: Invalid name for a record group column (merged by CM) [message #441637 is a reply to message #441633] Tue, 02 February 2010 05:42 Go to previous messageGo to next message
cookiemonster
Messages: 12320
Registered: September 2008
Location: Rainy Manchester
Senior Member
Showing us the code would be a good start - please use code tags - see the orafaq forum guide if you're not sure how.
Re: FRM-30058: Invalid name for a record group column (merged by CM) [message #441638 is a reply to message #441637] Tue, 02 February 2010 05:44 Go to previous messageGo to next message
nehaverma
Messages: 80
Registered: January 2010
Location: JAIPUR
Member
SELECT Distinct z.PO_NO, z.PO_DATE, z.mod_sr_no VERSION_NO,req_no, REQ_DATE,
GENERAL(Z.REQ_BY)||' on '||REQ_DATE Request,
LTRIM(RTRIM(AUTH_STATUS_M(X.PO_NO, X.PO_DATE, X.VERSION_NO))) "AUTH_STAT"
FROM MGH_POMAIN X,
(
(
SELECT A.PO_NO, A.PO_DATE, A.VERSION_NO
FROM MGH_POMAIN A, MGM_POST_SEC B
WHERE B.SECTION_CODE = SUBSTR(A.PO_NO, 1, 2)
/*AND B.POST_CODE = :PARAMETER.POST_CODE*/
INTERSECT
SELECT PO_NO, PO_DATE, MOD_SR_NO FROM MPH_POMODIFY
)
MINUS
(
SELECT C.PO_NO, C.PO_DATE, C.VERSION_NO
FROM MGH_POMAIN_AT C, (SELECT PO_NO, PO_DATE, VERSION_NO,
MAX(DATE_OF_AUTH) DOA FROM MGH_POMAIN_AT
GROUP BY PO_NO, PO_DATE, VERSION_NO) D
WHERE
C.PO_NO = D.PO_NO
AND C.PO_DATE = D.PO_DATE
AND C.VERSION_NO = D.VERSION_NO
AND C.DATE_OF_AUTH = D.DOA
AND ((C.STAT_IND = 'A' AND C.AMEND_IND = 'Z')
OR (C.STAT_IND = 'R'
/* AND C.POST_LEVEL <= :PARAMETER.POST_LEVEL*/
)
OR (C.STAT_IND <> 'R'
/*AND C.POST_LEVEL >= :PARAMETER.POST_LEVEL*/
))
)
) Y, MPH_POMODIFY Z
WHERE X.PO_NO = Y.PO_NO
AND X.PO_DATE = Y.PO_DATE
AND X.VERSION_NO = Y.VERSION_NO
AND Z.PO_NO = Y.PO_NO
AND Z.PO_DATE = Y.PO_DATE
AND Z.MOD_SR_NO = Y.VERSION_NO
order by REQ_DATE
Re: FRM-30058: Invalid name for a record group column (merged by CM) [message #441642 is a reply to message #441633] Tue, 02 February 2010 06:04 Go to previous messageGo to next message
nehaverma
Messages: 80
Registered: January 2010
Location: JAIPUR
Member
please TELL ME WHAT SHOULD I DO
Re: FRM-30058: Invalid name for a record group column (merged by CM) [message #441645 is a reply to message #441642] Tue, 02 February 2010 06:15 Go to previous messageGo to next message
cookiemonster
Messages: 12320
Registered: September 2008
Location: Rainy Manchester
Senior Member
nehaverma wrote on Tue, 02 February 2010 12:04
please TELL ME WHAT SHOULD I DO


Well using code tags like I asked and not posting in caps (it's considered shouting) would be a good start.

How are you creating this record group? Are you doing it directly in form builder or are you populating it programmatically at run time?
And why is the alias AUTH_STAT in double quotes?
Re: FRM-30058: Invalid name for a record group column (merged by CM) [message #441662 is a reply to message #441645] Tue, 02 February 2010 08:38 Go to previous messageGo to next message
Supernova11
Messages: 12
Registered: December 2008
Location: Indonesia
Junior Member
Please re-format your code..
It's really hard to read it.

i already feel sleepy when i look at it.
Re: FRM-30058: Invalid name for a record group column (merged by CM) [message #441816 is a reply to message #441662] Wed, 03 February 2010 04:29 Go to previous messageGo to next message
nehaverma
Messages: 80
Registered: January 2010
Location: JAIPUR
Member
Sorry I dont want to let u feel this Razz

I will try to do this again.
Re: FRM-30058: Invalid name for a record group column (merged by CM) [message #446674 is a reply to message #441816] Tue, 09 March 2010 22:53 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Sorry that I have been so long in replying. Have you solved your problem?

I think you need to have the same column names on each side of an 'intersect' as well as the 'union' or 'minus'.

David
Re: FRM-30058: Invalid name for a record group column (merged by CM) [message #451858 is a reply to message #441633] Sat, 17 April 2010 11:28 Go to previous messageGo to next message
yahoo
Messages: 3
Registered: April 2010
Location: Aberdeen
Junior Member
hi
So i got this error as well. Record cant see my child block. Any way to direct it?
FRM-30058: Invalid name for a record group column .
Record Group FIRSTREG_LIST
Form: MODEL
FRM-30085: Unable to adjust form for output.


Im trying to create a record group for the form made with 2 data blocks and the column name doesnt belong to the master one
blocks: model and cardetails connected on model_name
I need it for some lov in cardetails

im using 10g form builder

[Updated on: Sat, 17 April 2010 11:48]

Report message to a moderator

Re: FRM-30058: Invalid name for a record group column (merged by CM) [message #451870 is a reply to message #441633] Sat, 17 April 2010 16:23 Go to previous messageGo to next message
cookiemonster
Messages: 12320
Registered: September 2008
Location: Rainy Manchester
Senior Member
Show us the query you're using.
Re: FRM-30058: Invalid name for a record group column (merged by CM) [message #451897 is a reply to message #451870] Sun, 18 April 2010 08:12 Go to previous message
yahoo
Messages: 3
Registered: April 2010
Location: Aberdeen
Junior Member
I used static values like 2008, 2009 and so on
well it works today Smile I guess it was some uni internal problem Laughing got2 finish my dissertation now Razz

[Updated on: Sun, 18 April 2010 08:18]

Report message to a moderator

Previous Topic: Update statement on button
Next Topic: Age
Goto Forum:
  


Current Time: Wed Sep 28 00:38:28 CDT 2016

Total time taken to generate the page: 0.05244 seconds