Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Tools Development

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
37%
Installation Wizard into new VRC
39%
Manual into existing VRC
3%
Manual into new VRC
21%
Total votes: 38

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 29th December 2016, 11:04
sai krishna sai krishna is offline
Junior Member
 
Join Date: Dec 2016
Posts: 12
sai krishna is on a distinguished road
Baan: 10.04 - DB: baan sql - OS: windows 10
bmark

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

Code:
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

Last edited by bhushanchanda : 29th December 2016 at 14:11. Reason: added code tags
Reply With Quote
Sponsored Links
  #2  
Old 29th December 2016, 14:13
bhushanchanda's Avatar
bhushanchanda bhushanchanda is offline
Guru
 
Join Date: Sep 2012
Location: India
Posts: 2,320
bhushanchanda has a spectacular aura aboutbhushanchanda has a spectacular aura aboutbhushanchanda has a spectacular aura about
Baan: LN FP 1-9, 10.4, a little bit of Baan IV - DB: SQL Server 2008, Oracle - OS: Windows Server 2008 R2, Unix
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)

Code:
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
__________________
Regards,

Bhushan

Unless you try to do something beyond what you have already mastered, you will never grow!
Reply With Quote
  #3  
Old 30th December 2016, 06:59
sai krishna sai krishna is offline
Junior Member
 
Join Date: Dec 2016
Posts: 12
sai krishna is on a distinguished road
Baan: 10.04 - DB: baan sql - OS: windows 10
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

Last edited by sai krishna : 30th December 2016 at 07:45.
Reply With Quote
  #4  
Old 30th December 2016, 12:41
sai krishna sai krishna is offline
Junior Member
 
Join Date: Dec 2016
Posts: 12
sai krishna is on a distinguished road
Baan: 10.04 - DB: baan sql - OS: windows 10
[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
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +2. The time now is 11:28.


©2001-2017 - Baanboard.com - Baanforums.com