Adam Tarkowski
1/4/2006 6:10:00 PM
I know but it is not what i want to do, i must use it to change some
records,
I have found the answer
Maybe this will be usefull for someone
Thank you
SysQueryRun chooseJour;
chooseJour = new SysQueryRun(queryStr(smmCustQuotationJour));
ParmId oldParmId;
super();
chooseJour.reset();
chooseJour.query().dataSourceTable(tableNum(smmCustQuotationJour)).rangeFiel
d(fieldNum(smmCustQuotationJour, ParmId)).value(queryValue(parmId));
if (chooseJour.prompt())
{
oldParmId = parmId;
parmId = numberSeq::newGetNum(CompanyInfo::numRefParmId()).num();
ttsbegin;
while (chooseJour.next())
{
if (chooseJour.Changed(tableNum(smmCustQuotationJour)))
{
CustQuotationTable = chooseJour.Get
(tableNum(smmCustQuotationJour));
CustQuotationTable.ParmId = parmId;
CustQuotationTable.update(oldParmId);
}
}
ttscommit;
element.deleteAllByParmId(oldParmId);
}