--- In development-axapta@yahoogroups.com, "steffendenize"
<[EMAIL PROTECTED]> wrote:
>
> 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
>
Found the solution to my problem:
static void Job15(Args _args)
{
DictTable DictTable;
UtilIdElements UtilIdElements;
while select UtilIdElements
group by id
where UtilIdElements.recordType == UtilElementType::Table
{
DictTable = new DictTable(UtilIdElements.Id);
if(DictTable.dataprcompany() == NoYes::No)
{
info(strfmt("%1 %2", UtilIdElements.Id,
tableId2Name(UtilIdElements.Id)));
}
}
// sry for bad formatting
