Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Distribution, Transportation & Warehousing

User login

Frontpage Sponsor

Main

Poll
What do you expect from your SI Implementation partner for the success of ERP implementation.
Bring best practices - Not to offer more CR's Leveraging standard functions
14%
Need more honesty to work with the Users until their processes are fully mapped & Users are trained
43%
Focus on process automation/ integrations/ Real time data/ BI analytics
29%
Stick to basics
14%
Total votes: 7

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 15th March 2023, 12:07
showstuff11 showstuff11 is offline
Junior Member
 
Join Date: Mar 2015
Posts: 28
showstuff11 is on a distinguished road
Baan: fp3 - DB: sql server 2008 r2 - OS: windows 7
Creating Another View for TDSLS4100m000
Baan: Infor ERP 10.6

how can i overwrite via extension the data shown in tdsls4100m000
using this sql

Code:
select tdsls400.ofbp, tdsls400.oamt,tdsls400.ddat,tdsls400.corn |,count(*)
 from tdsls400
 GROUP BY tdsls400.ofbp, tdsls400.oamt,tdsls400.ddat,tdsls400.corn 
 HAVING count(*) > 1

selectdo
	select * 
  from tdsls400
  where tdsls400.ofbp = {:tdsls400.ofbp} and 
        tdsls400.oamt = {:tdsls400.oamt} and
        tdsls400.ddat = {:tdsls400.ddat} and 
        tdsls400.corn ={:tdsls400.corn}
  selectdo
  
  endselect


i tried this in the CDF button i created
Code:
query.extend.select("select tdsls400.ofbp, tdsls400.oamt,tdsls400.ddat,tdsls400.corn", EXTEND_OVERWRITE)
query.extend.from("from tdsls400  GROUP BY tdsls400.ofbp, tdsls400.oamt,tdsls400.ddat,tdsls400.corn  HAVING count(*) > 1", EXTEND_OVERWRITE)
but no changes in the overview session


please help im currently stuck 2week on this problem
Reply With Quote
Sponsored Links
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

Similar Threads
Thread Thread Starter Forum Replies Last Post
After adding non index field as View field,Next.view,next.set etc not working Ajesh Tools Development 2 21st July 2016 13:42
Query extension on DB View lego1as Tools Administration & Installation 0 18th October 2013 18:22
keine Datenanzeige in Multi-Occ-Sessions mit View - Datengrundlage ist eine View spartacus Deutsches Forum 0 25th October 2005 16:26
stpapi.find not working trchandra AFS/DDC/OLE: Function servers 17 1st May 2002 18:46


All times are GMT +2. The time now is 01:20.


©2001-2023 - Baanboard.com - Baanforums.com