Hi guys,
I have a serial owner table which has 1 lakh records and i have serial trans table it has more number of records says 3 lakhs , I have to update counterpartner field in serial owner from serial trans and I have to select the last recid in the child table.
in short, I have to use updaterecordset and order by recid .
ttsBegin;
while select forUpdate DMSSerialNumOwner
{
select firstOnly * from DMSSerialNumTrans order by recid desc
where DMSSerialNumTrans.SerialNum == DMSSerialNumOwner.SerialNum;
{
info(strFmt("%1",DMSSerialNumTrans.RecId));
}
DMSSerialNumOwner.counterpartner = DMSSerialNumTrans.counterpartner ;
DMSSerialNumOwner.update;
}
ttscommit;
I will be happy if some one convert the above code in updaterecordset.
Thanks,
Rohit