>> >> SELECT job, (sum(IIF(done='yes',1,0))/count(job))*100 AS progress FROM
>> >> mytable GROUP BY job
>> >
>> >Thank you Matt. It's exactly what I need.
>>
>> Is it fast enough for millions of records?!
>
>I don't know yet. My first problem was to get it work somehow. The table
>structure
>is not my design and it cannot be changed. The client is using a DOS based
>application
>and I have to make the VFP version work on the DOS tables. This form will
>only read
>the DOS tables every n seconds and display a graph.
>
>If you have a better solution, please don't keep it secret ... :-)
Sorry, no. I was just curious if it's fast enough. :(
Vlad
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement