Search Forum Home   Visual FoxPro  Cod, sintaxa si comenzi  sum & delet...  sum & delete    1/17/2012 10:46:28 AM 806dan 8 posts sum & delete  (N/A) buna ziua, am un tabel, exemplu: id / pret 1 30 1 25 2 15 3 50 3 50 3 12 si vreau sa sterg toate inregistrarile unde suma ptretului pe fiecare id nu depaseste o anumita valoare sa zicem 30. Eu am incercat cu: CLOSE all SELECT a USE exemplu INDEX on id TO pp DO WHILE NOT EOF() STORE id TO wid sum pret TO wpret FOR id = wid IF wpret < 30 dele all for id = wid ENDIF skip enddo Multumesc  1/17/2012 10:53:00 AM 806dan 8 posts Re: sum & delete  (N/A) Scuze de dublu post, dar nu gasesc cum sa-mi editez postul original. am un tabel, exemplu: id / pret 1 30 1 25 2 15 3 50 3 50 3 12 si vreau sa sterg toate inregistrarile unde suma ptretului pe fiecare id nu depaseste o anumita valoare sa zicem 30. Eu am incercat cu: CLOSE all SELECT a USE exemplu INDEX on id TO pp DO WHILE NOT EOF() STORE id TO wid sum pret TO wpret FOR id = wid IF wpret < 30 dele all for id = wid ENDIF skip enddo Multumesc  1/17/2012 10:53:07 AM myself 64 posts Re: sum & delete  (N/A) Sum te duce la sfarsitul tabelei  1/17/2012 11:08:24 AM 806dan 8 posts Re: sum & delete  (N/A) si cum as putea face treaba asta fara sum? sau oricum....  1/17/2012 11:15:24 AM Daniel Buduru 2335 posts Re: sum & delete  (N/A)  Presupun ca ai vfp9, altfel ai fi precizat versiunea :) Delete from tabel where id in (select id from (select id, sum(pret) as sumpret  from tabel group by id) bb where sumpret<wpret) Daniel Buduru  1/17/2012 11:26:11 AM Daniel Buduru 2335 posts Re: sum & delete  (N/A) Sorry pentru scapare,  am corectat postul anterior. Daniel Buduru  1/17/2012 2:40:08 PM 806dan 8 posts Re: sum & delete  (N/A) multumesc, a mers perfect!  Page 1 of 1   Visual FoxPro  Cod, sintaxa si comenzi  sum & delet... Flat View Tree View Oldest To Newest Newest To Oldest