<div>
Besides, you can always index a table temporary, just use the INDEX command to create an IDX or a tag of a CDX and specify the destination file, this will not change the table and so won't hurt any system. Besides it would be a seldom side effect for a table to stop working with an additional index tag.<br />
<br />
Bye, Olaf.
</div>


Besides, you can always index a table temporary, just use the INDEX command to create an IDX or a tag of a CDX and specify the destination file, this will not change the table and so won't hurt any system. Besides it would be a seldom side effect for a table to stop working with an additional index tag.

Bye, Olaf.

<div>
Thank you. Simple, direct and it worked.
</div>


<div>
<div class="content wysiwyg-content">
Hi all.<br />
<br />
It's been quite a while since I did any work in FP.<br />
<br />
I have a table with &quot;productid&quot; and &quot;prodcount&quot;. They are both numeric. Prodcount contains inventory counts.<br />
<br />
What I need is to select the ten product ids with the largest counts.<br />
<br />
The table is not indexed on the prodcount field and I cannot change that.<br />
<br />
Thanks!
</div>
</div>


Hi all.

It's been quite a while since I did any work in FP.

I have a table with "productid" and "prodcount". They are both numeric. Prodcount contains inventory counts.

What I need is to select the ten product ids with the largest counts.

The table is not indexed on the prodcount field and I cannot change that.

Thanks!

VFP 9 Select Top 10

Visual FoxPro (VFP), and its predecessor FoxPro, is a data-centric, object-oriented, procedural, database programming language and IDE from Microsoft last released in 2007 that still has some active use due to its low cost of deployment and fairly rapid development. In 2008, Microsoft released a set of add-ons for VFP's xBase components to allow interoperability with various Microsoft technologies. It allows data processing against its native file-based data tables or database servers such as SQL Server.