kriki: Where Used : “Line No.”

[Blog bot]

An anecdote of a conversation, but it might help other developers in searching for a field in the whole application.



Project Leader: I have “Line No.” in some table. Where is it used? How is it used?



Me:Export all as text. Import it in the Navision Developer Toolkit and use the Where-used.



Project Leader: That takes a lot of time. I need to know it in maximum half an hour time. Importing that text-file in NDT takes WWWWWAAAAAYYYYY to long! And opening the text file and just searching for it is not possible because too many tables have that field.



Me: You have a test database, haven’t you?



Project Leader: Yes. ???????????



Me: Design your table. Go to “Line No.”. Change it to “XYZ Line No.”. (Note: I really mean XYZ and not some random value!). Compile+Save the object (if you have references of that field in the table, it is possible you need to change them to “XYZ Line No.” before you can compile+save). (Note: internally, NAV uses the “Field No.” of the field and NOT the field name, so if you change the name of the field, it is almost the same as changing its caption. After you saved it, everywhere in NAV the new name will be used.)

Then export all as text and search the textfile for “XYZ Line No.”.



Project Leader: …



Project Leader: “Geniale! Sei veramente un genio del male!”. What means “Genial! You really are an evil genius!”.







To be honest. That last phrase made me write this post!



NOT because of WHAT he said, but more HOW he said it. For me, this is an obvious trick I used a lot of times. But not for everyone it seems.

And even if my project leader isn’t a NAV-programmer, some times he really surprised me with his technical knowledge of NAV.

So this reply coming from him, is a proof for me that only few people know of this trick.



I hope now that more people know of this life-saving (kind off….) trick.



Читать дальше