Home » Developer & Programmer » Forms » can not create record group (Oracle 10g, Forms6i)
can not create record group [message #416881] Wed, 05 August 2009 00:08 Go to next message
snsiddiqui
Messages: 168
Registered: December 2008
Senior Member
I am facing this error at the time of RECORD GROUP creation. Query is running perfectly in SQLPLUS.
error is
FRM-12001:can not create your record group (check your query).


select jtr_rollno, jtr_jrm_id
from job_trans_mast, job_trans_detl, job_trans_rolls
where jtm_id = jtd_jtm_id
and jtm_id = jtr_jtm_id
and jtd_id = jtr_jtd_id
and jtm_id = (select max(jtm_id)
from job_trans_mast, job_trans_detl
where jtm_id = jtd_jtm_id
and jtm_t_cd_dcode = '12'
and jtm_type = 'I'
and jtd_mktjno = '0918779')
and jtr_status = 'Y'
order by jtr_rollno
Re: can not create record group [message #416896 is a reply to message #416881] Wed, 05 August 2009 01:10 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Use aliases for your tables. I can only assume that a column name is used by more than one table.

David

PS Format your code and use code tags!
Re: can not create record group [message #416920 is a reply to message #416896] Wed, 05 August 2009 02:56 Go to previous messageGo to next message
snsiddiqui
Messages: 168
Registered: December 2008
Senior Member
what I tried to do was write the same sql statement
line by line.
As in adding normal query with no where clause.
It worked
then adding where clause it worked.
then and condition and its working.

I know it might sound sily again but this is how it happened.
anyways Happy that it works.


trust me it is silly but this is really what happened and how it got solved I don't know.
Re: can not create record group [message #417056 is a reply to message #416920] Wed, 05 August 2009 18:19 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
If you posted your new code and then compared it to the previous code you will probably find that it is different.

David
Previous Topic: can we call form through tree?
Next Topic: How to store a file into a table by browsing from the local PC?
Goto Forum:
  


Current Time: Fri Dec 09 09:26:25 CST 2016

Total time taken to generate the page: 0.06199 seconds