| can not create record group [message #416881] |
Wed, 05 August 2009 00:08  |
snsiddiqui
Messages: 172
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 #416920 is a reply to message #416896] |
Wed, 05 August 2009 02:56  |
snsiddiqui
Messages: 172
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.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
