mibuso.com

Data Lookup Codeunit Generator
Small command-line tool to generate NAV codeunit to call default lookup/drilldown forms for RecordRef (RecordRef/FieldRef is good functionality but some things are unfinished).

Resulting codeunit contains one Method called "LookupDate(VAR RecRef : RecordRef)".

You need just export NAV tables as text, generate codeunit, import codeunit back to NAV and compile.

Sample is included. Tools works only with tables with LookupFormID/DrillDownFormID properties set.

Microsoft .NET Framework 2.0 required.

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

Discuss this download here.

Not sure why the command line tool is needed? Why not just write this as a codeunit in Navision without needing to first export the tables and then run another seperate program?

If it's for cool factor then

Yep, indeed! But it's much more fun, than just code in NAV!

No, Steve... I've suddenly recalled why I did external tool! I was too busy to think about this.

I'm creating code not for all tables but for tables with default Lookup/Drilldown forms.

Happy New Year!

Hi,

Dont suppose anyone has worked out how to get around the case stuff

EG.

form,run(0,recref);


B ??

i assume that your reply copying my question indicates you didn;t understand the question ?

in the codeunit i download there is a CASE statement

CASE RecRef.NUMBER OF
DATABASE::"Payment Terms": BEGIN
"Payment Terms".SETVIEW(TableView);
FORM.RUN(0,"Payment Terms");
END;
DATABASE::"Currency": BEGIN
"Currency".SETVIEW(TableView);
FORM.RUN(0,"Currency");
END;
DATABASE::"Finance Charge Terms": BEGIN
"Finance Charge Terms".SETVIEW(TableView);
FORM.RUN(0,"Finance Charge Terms");
END;

has anyone worked out how to do the form.run function
FORM.RUN(0,RECREF);

is this possible yet ?

Bruce

Nope. Even in NAV5.