>> >> 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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only