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
35%
Installation Wizard into new VRC
42%
Manual into existing VRC
3%
Manual into new VRC
19%
Total votes: 31

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 27th September 2002, 21:48
BaanTech's Avatar
BaanTech BaanTech is offline
Member
 
Join Date: Mar 2002
Location: Canada
Posts: 60
BaanTech is on a distinguished road
Baan: c3 -> c4 - DB: Oracle - OS: Unix
Mass Delete of Device data

We've created a tool internally to do a mass update of device data (and preference lists) to accommodate a centralizing of our print services. Part of the clean up exercise is to remove old devices on the local queues.

I need to do a db.delete on ttaad306.000 and I know this
will fail if the device exists in the device queue data (as per standard logic). The other ref I know of is via table ttaad306. Does anyone know of anything else to watch out for or if there is a standard DLL that gives this logic.

Or else, can someone with tt code tell me what to look out
for when deleting devices outside of the standard session.

Thanks (ps. on c4).

BaanTech
Reply With Quote
  #2  
Old 1st October 2002, 01:28
Ruskin's Avatar
Ruskin Ruskin is offline
Unconfirmed User
 
Join Date: Feb 2002
Location: New Zealand
Posts: 91
Ruskin is on a distinguished road
Baan: All - DB: MS-SQL, Informix, Oracle - OS: UNIX and NT Server
have you tried....

Don't have the tt code, but the only device tables that you should need to worry about are;

if ttaad320 is empty, you can clear ttaad306 (have done it myself)...

It also holds true for ttaad300 (except that you need to clear ttaad301 as well).
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
ERPJewels Hitesh Shah Third Party Products 10 6th November 2006 05:38
Delete Outbound Data jmathew Distribution, Transportation & Warehousing 4 15th September 2003 09:25
zooming to device data ttaad3500m000 baan_afbs AFS/DDC/OLE: Function servers 1 6th December 2002 15:20
Maintain Device Data, HOWTO Bob Ino Tools Development 1 10th April 2002 21:21


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


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