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

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

Baanboard at LinkedIn

Reference Content

Thread Tools Display Modes
Old 1st June 2018, 14:24
vam143na vam143na is offline
Join Date: Apr 2014
Posts: 44
vam143na is on a distinguished road
Baan: 7 - DB: sql - OS: windows 7
Not to delete record in middle
Baan: ERP LN 6.1 FP7 (Infor ERP 10.1)
C/S: Server

Hi All,

I have a query, kindly help me.
I have a maintain session in which i have entered few records in sequence. The thing is i dont want to delete the record in between.
for Ex: seq |amt(from)| amount(to)
1 | 1 |5
2 | 6 | 7
3 | 8 | 10.

So here i dont want to delete the sequence 2?

Reply With Quote
Old 4th June 2018, 03:38
Ajesh's Avatar
Ajesh Ajesh is offline
Join Date: Feb 2009
Posts: 566
Ajesh is on a distinguished road
Baan: LN 10.4 - DB: Oracle - OS: HP-Unix
On what basis, you don't want to delete 2,is it because it is coming between 1 & 3??
Reply With Quote
Old 6th June 2018, 14:53
mark_h's Avatar
mark_h mark_h is offline
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 7,193
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
More information is needed. Because if you enter a few records hit save, then you could mark record 1 and 3 and hit the delete button in 4c4. That would delete those two records. Just don't give a user the delete range functionality.

GO Cards!
My latest mantra - make sure you have latest stpapi patches and the latest session object. If on LN then please explore the option of using DAL2 functionality.

Shared Solutions for Baan systems provided free by Baan Board.
Play the Google game and help Baanboard get better rankings. Do your part. Click here to find how.
Reply With Quote
Sponsored Links
Old 6th June 2018, 21:24
rahul ingale rahul ingale is offline
Join Date: May 2011
Location: Mumbai
Posts: 57
rahul ingale is on a distinguished road
Baan: baan infor - DB: sql - OS: windows xp
If you are using dal then in before.destroy.object check mark record is having greater than sequence and also less then sequence.if present then give dalhookerror.
Reply With Quote
Old 6th August 2018, 14:05
Sahil Sharma Sahil Sharma is offline
Junior Member
Join Date: Jul 2018
Posts: 15
Sahil Sharma is on a distinguished road
Baan: FP 10.4 - DB: BAAN - OS: windows 10
first of all take out the maximum and the minimum sequence and then check whether the record exists between these two limits. If Yes, then return DALHOOKERROR.
Reply With Quote

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
Cannot delete record okneb1 Tools Development 2 12th September 2016 11:50
AFS fail to delete record in Maintain Estimated End Items ppchong AFS/DDC/OLE: Function servers 1 22nd September 2011 15:47
AFS fail to delete record in Maintain Estimated End Items ppchong AFS/DDC/OLE: Function servers 1 21st September 2011 14:16
Delete a record in a customized session mostrightfuture Operating Systems & Databases 6 9th November 2006 09:23
How to delete record in scheme? yurong Tools Administration & Installation 4 31st December 2004 00:35

All times are GMT +2. The time now is 08:53.

©2001-2018 - -