[development-axapta] Re: Temporary Table info

Tue, 11 Oct 2005 05:05:15 -0700

--- In [email protected], "Martin Sujkowski"
<[EMAIL PROTECTED]> wrote:
>
> Is there a way to programatically get a list of fields in a given
> temporary table? If so how?
>

dear all,

to use the dictTable object to get the fields.
// begin
    DictTable       dt = new DictTable(tableNum(tmpIncomingTaxHeader));
    tmpIncomingTaxHeader temp1, temp2;
    FieldId         fd;
    int             i;

    temp1.VendAccount = "2000";
    temp1.InternalInvoiceId = "internal1";
    temp1.insert();

    select firstonly temp1;

    info(strfmt("Temp1: vend %1, invoice %2", temp1.(50001),
temp1.InternalInvoiceId));

    temp2.setTmpData(temp1);

    select firstonly temp2;

    info(strfmt("Temp2: vend %1, invoice %2", temp2.VendAccount,
temp2.InternalInvoiceId));

    for (i = 1; i <= dt.fieldCnt(); i++)
    {
        fd = dt.fieldCnt2id(i);
        info(strfmt("Temp1.%1 = %2", dt.fieldName(fd), temp1.(fd)));
    }
// end

from the above example, you can figure out that temporary table is
just another 'data type', for the detail, see help from axapta

regards,

Nasrullah
--
T I M E
YAHOO! GROUPS LINKS



Reply via email to