AW: [development-axapta] List of tables which are Savedataprcompany == false

[jesper.joergensen]

HI

 

You are close to the result. 

 

You can't assume, that the counter has the same value as the table id... Try 
this.

 

I have excluded the maps, views, tmptables, and the system tables as well.

 

static void findGlobalTables(Args _args)

{

    Dictionary      Dictionary;

    sysDictTable    dictTable;

    Counter         tableCounter;

    ;

    Dictionary = new Dictionary();

    for (tableCounter = 1; tableCounter <= Dictionary.tableCnt(); 
tableCounter++)

    {

        dictTable = new SysDictTable(Dictionary.tableCnt2Id(tableCounter));

        if (dictTable.dataPrCompany() == false

        &&  !dictTable.isView()

        &&  !dictTable.isMap()

        &&  !dictTable.isSystemTable()

       &&  !dictTable.isTmp())

            info(dictTable.name());

    }

}

 

Mit freundlichen Grüßen / Best regards / Med venlig hilsen

Jesper Jørgensen / Abt. NMT-XD
Senior Product Manager

arvato systems | Technologies GmbH 
An der Autobahn 18 
33311 Gütersloh 

[EMAIL PROTECTED] <blocked::blocked::blocked::mailto:[EMAIL PROTECTED]> 

Phone:   +49 5242 / 40 80 54

Fax:       +49 5242 / 40 80 40

Mobile:  +49 172  / 571 03 34

http://www.as-T.biz <blocked::blocked::http://www.as-t.biz/>  
arvato systems | Technologies GmbH 
Joachim-Jungius-Str. 9, 18059 Rostock 
Geschäftsführung: Erwin Pietz, Matthias Moeller 
Amtsgericht Rostock - HRB 7497 

________________________________

"Der Inhalt dieser Nachricht oder eventueller Anlagen ist vertraulich und 
ausschließlich für den bezeichneten Adressaten bestimmt. Bitte stellen Sie 
sicher, dass die Information in dieser Nachricht ausschließlich an die 
adressierten Personen gelangt. Sollte diese Nachricht versehentlich an Sie 
gesendet worden sein, dann informieren Sie bitte umgehend den Absender und 
löschen Sie die Nachricht. Vielen Dank." 

"The information in this e-mail and any attachments is confidential. The 
information must only be held in areas that have controlled and limited access 
to the addressed persons. If this e-mail has been sent to you in error, please 
immediately notify the sender and delete the e-mail. Thanks." 

________________________________

Von: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] Im Auftrag 
von steffendenize
Gesendet: Freitag, 29. August 2008 15:09
An: development-axapta@yahoogroups.com
Betreff: [development-axapta] List of tables which are Savedataprcompany == 
false

 

Hi all
I need a list of all table which have the property - savedataprcompany
to no. What is the easiest way of doing this?
I've tried the noob-way: 
DictTable dictTable;
int i;
;
for(i = 1; i < 500; i++)
{
dictTable = new Dicttable(i);
if(dictTable.dataPrCompany() == noyes::No)
{
// print tableid2name(i);
info(strfmt("%1",tableid2name(i));
}
}
pause;
which fails (the 500 is just for testing). How do I get the result I
need. 
Regards,
Steffen

 



[Non-text portions of this message have been removed]