static void FindTablesWithListCodeId(Args _args)
{
SqlDictionary sqlDictionary;
DictTable dt;
int i, j;
boolean blnFound;
;
while select sqlDictionary
order by name
where sqlDictionary.fieldId==0 &&
sqlDictionary.name like '*'
{
dt = new DictTable(sqlDictionary.TabId);
// Fields
blnFound = false;
for (i=0; i<dt.fieldCnt();i++)
{
j=dt.fieldNext(j);
if (j && dt.fieldObject(j).isSql())
{
// SQL Field
// print dt.fieldObject(j).name(),
dt.fieldObject(j).typeId();
if (dt.fieldObject(j).typeId()==extendedTypeNum(ListCodeId))
{
blnFound = true;
}
}
}
if (blnFound)
print sqlDictionary.name;
}
pause;
}
>From: "Walter Becker" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: <[EMAIL PROTECTED]>
>Subject: [development-axapta] How can I find (Axapta) Tables, who's
>field(s) contain a given extendedDataType?
>Date: Fri, 7 May 2004 15:58:08 +0200
>
>For example:
> I must find all Tables with Fields who's ExtendedDataTypes are
>'ListCodeId'.
>
>How can I accomplish this search with Program Code?
>Is there perhaps already existing functionality in Axapta?
>
>Walter Becker
>DDT
>
| Yahoo! Groups Sponsor | |
|
|
Yahoo! Groups Links
- To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
