Re: [Axapta-Knowledge-Village] Checking of Field Names and Field Types

[vijaykarthik K]

Hi Ricardo,
The below job explained, How we get the field details & base type of fields.
i had taken ' EmplTable', and check the field name 'Status'.

static void FindTableColumn(Args _args)
{
    SysDictTable    sysDictTable;
    SysDictField    sysDictField;
    int j;
    str tablename,fldName;
    Types type;
    ;

    tablename    = 'EmplTable';
    sysDictTable = new SysDictTable(tablename2id(tablename));

    for(j=1; j<=sysDictTable.fieldCnt(); j++)
    {
        fldName = sysDictTable.fieldName(sysDictTable.fieldCnt2Id(j));
        if(fldName == 'status')
        {
            sysDictField = new SysDictField(tablename2id(tablename),
sysDictTable.fieldCnt2Id(j));
            type = sysDictField.baseType();
            print 'Type: ',type;
            print 'Fieldname : ',fldName;
            pause;
        }
    }
}

hope it will help u.

Thanks & Regards,
VijayKarthik.K
mob:+91 9963005830

On 9/10/07, ricardodegouveia <[EMAIL PROTECTED]> wrote:
>
>   Hi i'm trying to find out how in the emplTable or any table which
> fields are in the table, in other words i want to check if in code
>
> eg. field name = "Race" is a field in the EmplTable?
>
> as well how do you check the base type of the field like "Race" is it a
> string or enum and so on in code?
>
> Thanking you in Advance,
> Ricardo
>
>  
>


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