Developer Toolkit Issue

pvar

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

DenSter

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?

pvar

Yes, the tablerelation is in the DTK database.

DenSter

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.

pvar

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

Is it an actual table relationship or some code that does some check?

pvar

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

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.

pvar

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

"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.

pvar

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

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

pvar

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

<edit> removed, not worth it </edit>

pvar

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.