Select Objects

Administrator

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

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

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

Thanks in advance!

rdebath

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

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

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