Go Back > Forum > CMS - Forum Integration > Blogs and Web links

User login

Frontpage Sponsor


How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
200 - 500 GB
500 - 800 GB
800 - 1200 GB
1200 - 1500 GB
1500 - 2000 GB
> 2000 GB
Total votes: 85

Baanboard at LinkedIn

Reference Content

Thread Tools Display Modes
Old 20th June 2019, 07:42
DDPatel DDPatel is offline
Junior Member
Join Date: Dec 2018
Location: India,Gujarat,Umbergaon 396150
Posts: 10
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

A new blog entry has been added:

duplicate record in

hiii gurus,

I need a help in
   selection.filter:"tdcsl491.orno")"tdcsl491")"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  "" ???

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

duplicate record in
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.

Reply With Quote
Sponsored Links

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 23:16.

©2001-2018 - -