Baanboard.com

Go Back   Baanboard.com > Forum > CMS - Forum Integration > Blogs and Web links

User login

Frontpage Sponsor

Main

Poll
How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
18%
200 - 500 GB
28%
500 - 800 GB
3%
800 - 1200 GB
7%
1200 - 1500 GB
7%
1500 - 2000 GB
13%
> 2000 GB
24%
Total votes: 71

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 20th June 2019, 07:42
DDPatel DDPatel is offline
Junior Member
 
Join Date: Dec 2018
Location: India,Gujarat,Umbergaon 396150
Posts: 4
DDPatel is on a distinguished road
Baan: LN10.3 and LN10.4 - DB: SQL SERVER 2008 R2 - OS: WINDOW SERVER 2008 R2
duplicate record in query.extend.where.in.zoom

A new blog entry has been added:

duplicate record in query.extend.where.in.zoom

Quote:
hiii gurus,

I need a help in query.extend.where.in.zoom.
(Scenario)
field.orno.from:
   before.zoom:
   selection.filter:
      query.extend.select.in.zoom("tdcsl491.orno")
      query.extend.from.in.zoom("tdcsl491")
      query.extend.where.in.zoom("tdpur400.orno = tdcsl491.orno)
- i have used two table in query.extend.
- on above example tdpur400.orno has only one record but tdcsl491.orno has a multiple record.
So, When i am trying to open the zoom button,it show me many duplicate record...

Is that possible to get single/Unique record on  "query.extend.where.in.zoom" ???


Thanks in Advance,
DPatel
Reply With Quote
  #2  
Old 8th July 2019, 08:06
oirfeodent's Avatar
oirfeodent oirfeodent is offline
Member
 
Join Date: Jun 2016
Posts: 69
oirfeodent is on a distinguished road
Baan: Baan - DB: DB - OS: OS
Quote:
Originally Posted by DDPatel View Post
A new blog entry has been added:

duplicate record in query.extend.where.in.zoom
An easy approach would be to use exists in the where clause instead of equi-join.
However the above approach could become costly on the DB.

Regards,
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 On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Listing the particular record by mentioned the record number pralash Tools Development 4 8th October 2017 16:46
Duplicate record using AFS vik.patil AFS/DDC/OLE: Function servers 11 15th March 2017 09:58
Ascertain if a table record is locked when read andy2609 Tools Development 9 10th September 2014 13:59
To save record via tab cursor nolihayati isma Tools Development 7 19th June 2013 04:40
error 100 duplicate record in tdsls050 Joy Conner Distribution, Transportation & Warehousing 0 29th November 2012 18:05


All times are GMT +2. The time now is 22:37.


©2001-2018 - Baanboard.com - Baanforums.com