mibuso.com

Microsoft Business Solutions online community
It is currently Wed Jun 19, 2013 7:27 am

All times are UTC + 1 hour [ DST ]




Post new topic Reply to topic  [ 6 posts ] 
Author Message
 Post subject: Select Objects
PostPosted: Mon Sep 29, 2008 4:39 pm 
Offline
Site Admin

Joined: Sun Nov 07, 1999 8:01 am
Posts: 1914
Location: Wilrijk, Belgium
Country: Belgium (be)
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.


Top
 Profile  
 
 Post subject: Re: Select Objects
PostPosted: Thu Oct 02, 2008 10:12 am 
Offline

Joined: Tue May 06, 2008 2:56 pm
Posts: 350
Location: Walton-On-Thames
Country: United Kingdom (uk)
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');

_________________
Robert de Bath
TVision Technology Ltd


Top
 Profile  
 
 Post subject: Re: Select Objects
PostPosted: Tue Feb 21, 2012 2:19 pm 
Offline

Joined: Fri Feb 29, 2008 9:19 pm
Posts: 23
Location: Ukraine
Country: Ukraine (ua)
Hi all.
Who knows, for which purpose DBM Table No. field used? Which filter for this field I should use?

Thanks in advance!


Top
 Profile  
 
 Post subject: Re: Select Objects
PostPosted: Tue Feb 21, 2012 5:22 pm 
Offline

Joined: Tue May 06, 2008 2:56 pm
Posts: 350
Location: Walton-On-Thames
Country: United Kingdom (uk)
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.

_________________
Robert de Bath
TVision Technology Ltd


Top
 Profile  
 
 Post subject: Re: Select Objects
PostPosted: Wed Feb 22, 2012 12:38 pm 
Offline

Joined: Fri Feb 29, 2008 9:19 pm
Posts: 23
Location: Ukraine
Country: Ukraine (ua)
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!


Top
 Profile  
 
 Post subject: Re: Select Objects
PostPosted: Wed Feb 22, 2012 5:01 pm 
Offline

Joined: Tue May 06, 2008 2:56 pm
Posts: 350
Location: Walton-On-Thames
Country: United Kingdom (uk)
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

_________________
Robert de Bath
TVision Technology Ltd


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 6 posts ] 

All times are UTC + 1 hour [ DST ]


Who is online

Users browsing this forum: No registered users and 2 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum


Search for:
Jump to: