Table Viewer v1.0

Administrator

Table Viewer v1.0
View Dynamics NAV Table Info and Field Info in one form.

And you can learn how to use Table Reference and Field Reference.

Nice to have...

http://www.mibuso.com/dlinfo.asp?FileID=898

Discuss this download here.

camaris

nice work, thx.

we've got a non english installation, so the table header captions are different to table names.

after adding or updating the table informations to the table viewer, the table caption field will not be filled with any information.

how can i fix this?

thx

kriki

try something like this:
go in Codeunit 50500 and change "Object.Caption" and "Field.CAPTION" to "Object.Name" and "Field.NAME".
I didn't try it out, but I think it is that.

kriki

Some fixes in the code:

in table 50500:
"OnDelete()"-trigger:
original code:

lLines.SETRANGE("Table No","Table No");
IF lLines.FIND('-') THEN
  lLines.DELETEALL;

Better code:

lLines.RESET;
lLines.SETCURRENTKEY("Table No","Field Number");
lLines.SETRANGE("Table No","Table No");
lLines.DELETEALL(FALSE);

-my advice is to ALWAYS put RESET-SETCURRENTKEY-SETRANGE/SETFILTER so it is clear and sure there are NO other filters active.
-no need to do a FIND('-') before doing a DELETEALL. This creates an extra DB-read that is not needed. (and instead of FIND('-'), it would also have been better FINDFIRST for SQL).

Waldo

kriki wrote:

... and instead of FIND('-'), it would also have been better FINDFIRST for SQL).

I would suggest a "NOT ISEMPTY" ...
But indeed ... I wouldn't write the "IF" either.