Hi!:

I noted a extrain behavoir in a while select 
statement.
I am using a temporary table.
I am using Axapta V3 SP6.
The method is the following:

void clicked()
{
    TmpXYZShipDocs    shipDocs = TmpXYZShipDocs;
    SalesId             xSalesId;
    ;

    While Select shipDocs where shipDocs.Check == NoYes::Yes
    {
       if (shipDocs.RecId && shipDocs.Check == NoYes::Yes
            && shipDocs.SalesId != xSalesId)
            {
                super();
                xSalesId = shipDocs.SalesId;
                TmpXYZShipDocs_ds.executeQuery();

            }
        else
        if(!shipDocs.RecId)
            {
                TmpXYZShipDocs_ds.executeQuery();
                throw error('@XYZ261');
            }
     }
}

The select is selecting all rows (like ignoring 
the where clause).
So, for a while I am doing a extra conditional
using variables (in order to avoid loop), but,
anyway, the table is read complete.
Any ideas?.


Reply via email to