How do I convert a query with calc fields to TCursor type?

[Pharmer]

I am querying a rather large DB file with a series of queries, the first 2 of which have "calc count" fields. It runs very long (210 seconds).
The query is coded as follows:
Query
ANSWER: :work:withdawn.DB

pyx6002.DB | Station | PaType | GenMedName | Amt | Month | Index |
| Check | Check wit.. | | >0 | Check | calc count |

EndQuery

Can this query be quickened by TCursor?

Thank you
Doug

 

[Froy]

Doug,

I've been using Tcursor, and I think that query is faster than Tcursor. But probably you can try having secondary index, and try switchindex.

Froy