>>Hi Gang!
>>
>>One last question today.
>>
>>In setting up a form for some reports, there is a field called CLASS in a table PSE_drug
>>
>>I have an index set on class which is simply CLASS.
>>
>>Now, when I open the PSE_drug table and issue the command
>>
>>SELECT DISTINCT class FROM PSE_drug INTO CURSOR class
>>
>>it takes less than a second to get the cursor from a table of 5 MILLION records!
>>
>
>Try issuing DBF("class"). I'll bet you're filtering the original table.

When I start over (close VFP and restart VFP) and issue the SELECT, it took 0.91 secs.

Then I issued the ? DBF('class') command and got

c:\docume~1\tommy\locals~1\temp\04IC002D.tmp

So, this means it is an actual cursor, correct?

>
>>Yet, when I set this up as the ROWSOURCE with ROWSOURCE TYPE = 3 (SQL STATEMENT), it immediately turns into a dog and takes about 70 seconds to populate the control... sigh.
>
>Here, you're probably building an actual cursor.

After running the program, and getting out and going back and running the SELECT manually again, it took about 10 seconds to get the class cursor.

And the DBF('class') was c:\docume~1\tommy\locals~1\temp\04IC008M.tmp this time.

Maybe the program's settings is changing the environment detrimentally as compared to when I intially run the query by hand when I first start up VFP??.......

Thanks!

>
>Tamar