24.05.2009, 12:32 | #1 |
Участник
|
В таблицу CustInvoiceTrans вставила новый real столбик и по дефолту значение придала 0.00 .
Запускаю простой Job, Код: public void cusInvoiceTrans_KiekisGk(Args _args) { CustInvoiceTrans CustInvoiceTrans; real weight; ; ttsbegin; while select forupdate CustInvoiceTrans where CustInvoiceTrans.KiekisKG ==0 && CustInvoiceTrans.InvoiceDate >= str2Date('2009.01.01', 321) { weight = decround(CustInvoiceTrans.NetWeight(),4); if (weight != CustInvoiceTrans.KiekisKG) { CustInvoiceTrans.KiekisKG = weight; CustInvoiceTrans.update(); } } ttscommit; } |
|