Select Objects

Administrator · 2008-09-29

Select Objects
Often it is necessary to compare objects in various NAV-databases. You have the big group of objects in database 1. How to make the same selection of objects in a database 2?

With this tool you can do it in 4 simple steps:
1 Select objects in Database 1.
2 Copy, Paste in Excel and Save.
3 Run Form "Select Objects" in Database 2, fill all fields and click Select button.
4 Set Filter on the DBM Table No. of the Object-Table (Object Designer).

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

Discuss this download here.

rdebath · 2008-10-02

Oh sneaky, thankyou that's a very good idea.

But I expect you should make really sure that someone doesn't run it on native eg:

IF AllObj.GET(AllObj."Object Type"::Table, 2000000051) THEN ERROR('Really bad idea for Native');

Freeman · 2012-02-21

Hi all.
Who knows, for which purpose DBM Table No. field used? Which filter for this field I should use?

Thanks in advance!

rdebath · 2012-02-21

It's not used with the SQL server.

For the native (classic) database it's used in tabledata records to map the logical representation of Company name + Nav Table to a physical table within the database.

Freeman · 2012-02-22

Hi rdebath.
Thanks for fast answer!

So, as I understand, if I have database on SQL Server, I can leave filter blank for this field. But, I get error that it is must be greater than 0. What should I fill in in this field?

Thanks!

rdebath · 2012-02-22

Errm, you mean for this download?

It pops up a message for the value that it puts into the DBM Number field after the import. Or you could just use <>0

Select Objects

Comments

Categories