Developer Toolkit Issue

pvar
pvar Member Posts: 157
edited 2009-05-01 in Navision Attain
I was using 'Where Used ' on a Table field to know where all it referenced and unfortunately the tool didn't find a TableRelation defined on another field on the same table. I also tried 'Where Used With' everything checked but still it didn't find the Tablerelation. I am using V2.0 SP3?

Am I not using the tool correctly or is this a know problem with this version of the tool?

Thanks

Answers

  • DenSter
    DenSter Member Posts: 8,307
    Are the objects in your DTK database up to date? Did you discovere the actual tablerelationship in the object that is in your DTK database, or in the database itself?
    Daniel Rimmelzwaan
    RIS Plus, LLC
  • pvar
    pvar Member Posts: 157
    Yes, the tablerelation is in the DTK database.
  • DenSter
    DenSter Member Posts: 8,307
    Could you explain exactly what the relation is? It seems as though you have a field in the table that has a relationship to itself.
    Daniel Rimmelzwaan
    RIS Plus, LLC
  • pvar
    pvar Member Posts: 157
    Actually it is checking another field in the same table for certain value

    I forgot to mention that it is our custom table (above 50K range) if that makes any difference.
  • DenSter
    DenSter Member Posts: 8,307
    Is it an actual table relationship or some code that does some check?
    Daniel Rimmelzwaan
    RIS Plus, LLC
  • pvar
    pvar Member Posts: 157
    It's actual Tablerelation defined on 'Global customer' table like below for a field 'Parent Customer No.'

    "Global Customer" WHERE (Corporate Office=CONST(Yes))
  • DenSter
    DenSter Member Posts: 8,307
    I think it might be because only the table is defined and not the field that is linked to. Try defining the field as well as the table, update the objects in your DTK database and try again.
    Daniel Rimmelzwaan
    RIS Plus, LLC
  • pvar
    pvar Member Posts: 157
    Both the fields are defined in the table.

    Can you try setting up a relation like this in any of your tables and run the where used, I would be curious to know the result.
  • DenSter
    DenSter Member Posts: 8,307 
    "Global Customer" WHERE (Corporate Office=CONST(Yes))
    This links to the table only. Try adding the field reference explicitly. 
    "Global Customer"."No." WHERE (Corporate Office=CONST(Yes))
    Notice that the second one includes an explicit reference to the field. "Global Customer"."No." instead of just "Global Customer"

    I don't have a DTK database set up at the moment.
    Daniel Rimmelzwaan
    RIS Plus, LLC
  • pvar
    pvar Member Posts: 157
    The application works just fine with the way the relation is defined.

    All what I am saying is the DTK not finding the string 'Corporate Office' defined in the tablerelation when I do a where used on that field. Basically the where used is not looking at the tablerelation property when it searches, probably a bug in the tool.
  • DenSter
    DenSter Member Posts: 8,307
    You're not hearing what I am saying. It's not a bug, I think it's not picking it up because there is no explicit reference to the field, the foreign key. I know the app works without it, it's just that it seems that the DTK needs the field reference to be there to be able to pick it up. It looks for the FIELD reference, not the TABLE reference.

    Hey if you don't want to try it, that's fine with me, I'm not the one with the problem. Good luck though :)
    Daniel Rimmelzwaan
    RIS Plus, LLC
  • pvar
    pvar Member Posts: 157
    You're not hearing what I am saying. It's not a bug, I think it's not picking it up because there is no explicit reference to the field, the foreign key
    My friend, since you are that confident that it is not a bug, I gave it a try adding the explicit reference to the field but the tool still didn't find it. Sometimes what you think is not going to work and that's why I wanted you to try by yourself to see the problem.

    As far as I know the where used tool works similar to a search tool and it should find the string you are searching for in the places you asked to search.

    I would be interested to see if some one else have any comments on this otherwise I will try to get some explanation from Microsoft.

    Thanks
  • DenSter
    DenSter Member Posts: 8,307
    <edit> removed, not worth it </edit>
    Daniel Rimmelzwaan
    RIS Plus, LLC
  • pvar
    pvar Member Posts: 157
    If anyone still reading this topic it's worth to note that the issue with 'where used' functionality in version 2 of the toolkit has been fixed in version 3, according to Microsoft and you can download the latest version in the download section of NAV 2009 forum on mibuso or from partner source.

Categories