Search Forum Home   Visual FoxPro  Cod, sintaxa si comenzi  Suma in select...  Suma in select    9/1/2010 3:08:12 AM darky85 113 posts Suma in select  (N/A) Se poate sa afisez suma in fereasra de select , pe ultimul rand pe care il calculez ? Multumesc  9/1/2010 3:13:25 AM Daniel Buduru 2141 posts Re: Suma in select  (N/A) Ce  intelegi prin "fereastra de select"? Incearca sa explici mai in detaliu ce anume vrei sa faci. Daniel Buduru  9/1/2010 11:13:28 AM oviciandrus 761 posts www.comptech.ro Re: Suma in select  (N/A) Cred ca vrea ceva de genul select;       idfact, valfact as valoare; from facturi; UNION select;       Space(10) as idfact, sum(valfact) as valoare from facturi in zona albastra se selecteaza fiecare factura, in zona verde se face totalul facturilor, prin UNION se optine un singur cursor  9/1/2010 2:37:44 PM darky85 113 posts Re: Suma in select  (N/A) imi da eroare de sintaxa la select; idfact, valfact as valoare; from facturi; UNION  9/1/2010 3:55:16 PM oviciandrus 761 posts www.comptech.ro Re: Suma in select  (N/A)  Salut randurile trebuie sa se termine prin caracterul ; (punct si virgula) la o comanda intinsa pe mai multe randuri select;       idfact, valfact as valoare; from facturi; UNION; select;       Space(10) as idfact, sum(valfact) as valoare; from facturi  9/1/2010 11:23:20 PM darky85 113 posts Re: Suma in select  (N/A) gata ms frumos pusesem si eu niste ; da cred ca prea multe :))  Page 1 of 1   Visual FoxPro  Cod, sintaxa si comenzi  Suma in select... Flat View Tree View Oldest To Newest Newest To Oldest