Determine if table keys are being used/still required

ytoffey
ytoffey Member Posts: 7
edited 2004-04-12 in Navision Attain
Does anyone know of any free utility that can be used to determine if keys are still required ?

Comments

  • bostjanl
    bostjanl Member Posts: 107
    ytoffey wrote:
    Does anyone know of any free utility that can be used to determine if keys are still required ?

    MBS Navision Developer Toolkit is free for NSC. With "Where used" functionality you can chech if key is used or not,..


    Bostjan
  • eromein
    eromein Member Posts: 589
    Yes, you can probably create a report that print key's that aren't used based on NDTK tables.

    But I could be mistaken...
    "Real programmers don't comment their code.
    If it was hard to write, it should be hard to understand."
  • janpieter
    janpieter Member Posts: 298
    I was planning on making one, but so far no time ... :(
    In a world without Borders or Fences, who needs Windows and Gates?
  • ytoffey
    ytoffey Member Posts: 7
    Thanx for the resopnses guys.

    I'm not that familiar NDTK, but this isn't exactly what I'm looking for i.e. I have to manually use the 'Where Used' function on one key at a time. Also, if I stand on "Item No.,Variant Code,Drop Shipment,Location Code,Bin Code,Posting Date" key of the ILE table (32), then it would include in the results "ItemLedgEntry.SETCURRENTKEY("Item No.");"

    As for writing a report using the NDTK tables, can I have a little more detail. What NDTK tables?
  • eromein
    eromein Member Posts: 589
    dude,

    You'll have to download the "Navision Developers Toolkit (NDTK)". You can do some from the download section of mibuso.com.

    Then (RTFM ;)) read the manual. You'll see that the NDTK is the tool you are looking for.

    Mind you!!!! The change is, deleting keys will almost always lead to problems.
    "Real programmers don't comment their code.
    If it was hard to write, it should be hard to understand."
  • spycraft
    spycraft Member Posts: 66
    since we are on the topic of keys, Navision offers the flexibilty of enabling / disabling keys in table designer. Can someone advise that if a key is disabled, means that data will not be kept for the disabled key?

    The objective i want to achieve is to minimise the growth of the database by disabling unused keys.

Categories