Adding a new field dynamically to a table

You can do an insert in the Field table as long you have the appropiate license and use the correct field numbers.

Field.INIT;
Field.TableNo := DATABASE::Currency;
Field."No." := 11002002;
Field.FieldName := 'My Field';
Field.Class := Field.Class::Normal;
Field.Type := Field.Type::Boolean;
Field.Enabled := TRUE;
Field.INSERT;

lvanvugt wrote:

Maybe I thinking wrong (and reading the original post wrong), but that's not adding a field to a tbale, but populating existing fields with values.

Right?

Did you try it, my sample code? This will create an actual NEW field in Table 4...

Duikmeester wrote:

You can do an insert in the Field table as long you have the appropiate license and use the correct field numbers.

I disagree with this approach completely. Yes it can be done, but why would you?

You still have to get that code on to the customer database somehow. So you're importing an object regardless. How could writing code to add a field possibly save time over just simply adding the field by hand?

I learned a long time ago that NAV wants you to do things in a certain way. That doesn't mean don't find ways to improve processes, that's what NAV is about, but when it comes to the basics, like adding a field, stick to the usual method.

matttrax wrote:

Duikmeester wrote:

You can do an insert in the Field table as long you have the appropiate license and use the correct field numbers.

I disagree with this approach completely. Yes it can be done, but why would you?

You still have to get that code on to the customer database somehow. So you're importing an object regardless. How could writing code to add a field possibly save time over just simply adding the field by hand?

I learned a long time ago that NAV wants you to do things in a certain way. That doesn't mean don't find ways to improve processes, that's what NAV is about, but when it comes to the basics, like adding a field, stick to the usual method.

:thumbsup: =D>

idiot wrote:

Does using code to add field require a re-compile of the table?

Table does not seem to have to be recompiled, the modified time/date/mark however will change.

P.S: I have never used this in real world situation, I just know that this works...