i want barmark(tpptc942.bmrk) based on parentboq(tppss930.pact) and i wrote query like this and this is showing and error

select tppss930.pact
from tppss930
where tppss930._index1 = {: project}
selectdo
select tpptc942.bmrk
from tpptc942
where tpptc942._index1 = {: project}
and tpptc942.rabl = {:tpptc942.rabl}
| and tpptc942._index1 = {:tpptc942.cact}
selectdo
endselect
endselect

Hi,

It seems like your query is wrong. You are comparing tppss942.rabl with itself which doesn't make any sense. I am not aware of this table but it should be something like this -(assuming tppss930.rabl exists)

select tppss930.pact
from tppss930
where tppss930._index1 = {: project}
selectdo
select tpptc942.bmrk
from tpptc942
where tpptc942._index1 = {: project}
and tpptc942.rabl = {:tppss930.rabl}
selectdo
endselect
endselect

sorry this is the right query parentboq(tppss930.pact) and bmark(tpptc942.bmrk).In rabill=1 i have to two barmarks i am getting the override bmark..How to erradicate this..we have to take project(: project)+activity(tpptc942.cact)+ra bill(rabill) index we have to take activity will link to Parent activity.one BOQ code will be executive in multiple locations i.e parent activity
select tppss930.pact
from tppss930
where tppss930._index1 = {: project}
selectdo
select tpptc942.bmrk
from tpptc942
where tpptc942._index1 = {: project}
and tpptc942.rabl = {:rabillno}
| and tpptc942._index1 = {:tpptc942.cact}
selectdo
endselect

[QUOTE=sai krishna;200348]sorry this is the right query parentboq(tppss930.pact) and bmark(tpptc942.bmrk).In rabill=1 i have to two barmarks i am getting the override bmark..How to erradicate this..we have to take project(: project)+activity(tpptc942.cact)+ra bill(rabill) index we have to take activity will link to Parent activity.one BOQ code will be executive in multiple locations i.e parent activity
select tppss930.pact
from tppss930
where tppss930._index1 = {: project}
selectdo
select tpptc942.bmrk
from tpptc942
where tpptc942._index1 = {: project}
and tpptc942.rabl = {:rabillno}
| and tpptc942._index1 = {:tpptc942.cact}
selectdo
endselect
by using the above requirment we have to do,I did but data is not selected.can you please help me Bhushan
Thanks
siva sai krishna