| FRM-30058: Invalid name for a record group column (merged by CM) [message #441633] |
Tue, 02 February 2010 05:31  |
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 #441638 is a reply to message #441637] |
Tue, 02 February 2010 05:44  |
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 #441645 is a reply to message #441642] |
Tue, 02 February 2010 06:15 |
cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester
|
Senior Member |
|
|
nehaverma wrote on Tue, 02 February 2010 12:04please 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 #451858 is a reply to message #441633] |
Sat, 17 April 2010 11:28 |
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 |
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
I guess it was some uni internal problem 
got2 finish my dissertation now