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?.