Search results

DEF STREAM velorob. OUTPUT STREAM velorob TO "d:\velo\veloroba.txt". DEFINE VARIABLE centrala AS INTEGER NO-UNDO. centrala = 0. FOR EACH komdet WHERE komdet.vrs = "centrala" AND komdet.opis = "0522", EACH komit WHERE komit.sifkom = komdet.sifkom, EACH rromat WHERE rromat.sifkom...

Exactly Tom, I need to delete 40, so 5th row need to update value to 6, and then i have -40. Or update value in all rows to get that -40 in total. These are items on invoices, and when I do not have enough goods in my store I have to reduce the amount on my account. That's about 2k invoices a...

Thank you Tom, this will delet each row with sometable.somefle >= limit, I need to delete (somefild in row 1+somefild in row 2+.......) >= limit While deleting to sum value in deleted filds and when limit is reached to stop deliting.

Hello, is it posible to selecto some rows with condition where, and delete rows until sum of specific colum in rows is reach defined value. FOR EACH tablename WHERE tablename.date EQ /mm/dd/yyyy AND tablename.somthing > 0. DELETE tablename (UNTIL sum of deleted tablename.somthing = X)...