How to get Table-ID in OnModify() trigger

navvy · 2010-01-18

Hi,

I have to do some coding in an OnModify trigger of a table. Is there a function or a variable I can use to get the ID of the appropriate table ?

I also want to make a function in a codeunit which will use FieldRef to return all field names of a table. This function will be called by an external COM-application.
My second question is: Should I use Table Name or Table ID as parameter to call this function (which change not or maybe less) ? The problem is, if a table will be renumbered or renamed, my external application will no longer be able to get the field names (the function won't find the table).

Best Regards,
navvy

kriki · 2010-01-18

-There is no way to get the TABLE ID of the table. You have the TABLENAME-property of rec. With this you can search in table "Object", but it is not so fast. But I would just use DATABASE:"Your Table" to have the ID. The negative is that you need to manually change it in each table (in case you copy the table to another ID).

-The best way is to use the table ID. There is less change someone changes the ID of an object. The name can be easily changed in NAV without any problems.

navvy · 2010-01-18

Hi kriki

Thanks for the help

What do you mean with "But I would just use DATABASE:"Your Table" to have the ID. ", where should I use this ?

Last question: Is it possible to track renumbering of tables e.g. is there a certain trigger which I can use ?

navvy

kine · 2010-01-19

Renumbering table is more complex process than only renumbering. You need to change all relation in all other objects. It means that it is not done as common function. It is big job to renumber objects in NAV correctly.

Table ID: If you use RecordRef, you can use the recref.NUMBER to get the ID of the table. And how to create RecRef from Record you know... ;-)

kriki · 2010-01-19

navvy wrote:

Thanks for the help What do you mean with "But I would just use DATABASE:"Your Table" to have the ID. ", where should I use this ?

Give this a try:

int := DATABASE::"Sales Line"; // int is an integer variable
MESSAGE('The integer value is <%1>',int);

So DATABASE::"Sales Line" is like an integer constant and is more readable than 37.

Slawek_Guzek · 2010-01-28

navvy wrote:

Hi,
I have to do some coding in an OnModify trigger of a table. Is there a function or a variable I can use to get the ID of the appropriate table ?

How about :

RecRef.GETTABLE(Rec);
Message('%1', RecRef.NUMBER);

where RecRef is a local variable of RecordRef type...

Slawek.

EDIT:
Oops... Kine already suggested this

Vjeko · 2014-09-04

A late reply to this thread, but here's another solution, which enables you to get any object ID from any object type:

http://vjeko.com/blog/detecting-current ... et-interop

Slawek_Guzek · 2014-09-04

Vjeko wrote:

http://vjeko.com/blog/detecting-current ... et-interop

Vjeko, quoting your blog:

"In C# you can easily get access to the current method, or the method that called the current method"

Now - can you do THIS in NAV ?

thegunzo · 2014-09-04

Hi Slawek.

Vjeko did this in NAV using dotnet interop. Just look at his blog and the downloadable objects.
Excellent solution.

Slawek_Guzek · 2014-09-04

thegunzo wrote:

Hi Slawek.

Vjeko did this in NAV using dotnet interop. Just look at his blog and the downloadable objects.
Excellent solution.

Ahhh.. haven't looked in attached code samples..... :oops:

kine · 2014-09-04

But we are in classic forum... I assume that it could be done through own automation, but it means own dll... :whistle:

Howdy, Stranger!

Quick Links

Categories

How to get Table-ID in OnModify() trigger

Comments