ну и под занавес, мой любимый RecId itd
X++:
static void Job10(Args _args)
{
TempDummyTable t;
;
ttsbegin;
t.Field1="1";
t.Field2="2";
t.insert();
ttscommit;
ttsbegin;
t.Field1="1";
t.Field2="4";
t.insert();
ttscommit;
while select maxof(Field1) from t
group by Field1
where t.Field1 == '1'
{
info(strfmt("fisrt query %1--%2",t.Field1,t.Field2));
}
while select t
group by Field1
where t.Field1 == '1'
{
info(strfmt("second query %1--%2--%3",t.Field1,t.Field2,t.RecId));
}
}
(21:44:51)
fisrt query 1--
second query 1--2--1328
second query 1--4--1376