Does anyone know how I can identify all redundant table keys. I’ve read about an Impuls Workbench tool, but can’t seem to find it. Can anyone help? Regards YToffey ytoffey@bs3.co.za
First off, redundant means that the same thing is stored more than once. Because you can’t have two identical keys in a Navision table, by definition key redundancy does not exist in Navision. Of course we all know what you mean, I’m just being a smartass about it :). You can use the Navision developers toolkit (which now replaces the impulse workbench) to see where objects are used, so keys that are not use anywhere are not used and you could turn them off. You could also turn off keys that are only used in reports that you don’t use. I don’t know if you can do a batch where used though, that does thjis where used on all keys of tables.
quote:
re•dun•dant, adj. 1. Exceeding what is necessary or natural; superfluous. 2. Needlessly wordy or repetitive in expression: a student paper filled with redundant phrases. 3. Of or relating to linguistic redundancy. 4. Chiefly British. Dismissed or laid off from work, as for being no longer needed. 5. Electronics. Of or involving redundancy in electronic equipment. 6. Of or involving redundancy in the transmission of messages. (Dictionary.com)
(4) makes the use of Redundant perfectly appropriate (Who said smartass? [8D]). Anyway, finding where specific keys are used with the Developers Toolkit is, to say the least, troublesome and unreliable (e.g. try finding keys within a WITH structure or used by a SumIndexField).