BaanTech
27th September 2002, 22:48
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

Ruskin
1st October 2002, 02:28
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).