JK,

I'm getting very thirsty for some NO alchohol. Just ordered a DVD of the Denver whopping GB Superbowl. Sorry no Dolphin DVDs available since they haven't won anything in ohhhh about a decade or so.

PF

>I think Perry raised a valid point: Why create a view in VFP on a million record table. Suboptimal. Create a stored procedure on the server which accepts a parameter and sends back a result set. Less roundtripping and MUCH, MUCH faster.
>
>>How do you turn off odometer on the load of an SQL table from a view?
>>
>>I did a Set talk off and then set odometer to 10000, but STILL, when I open an SQL table in Foxpro from a view, it showers a counter by 100s and it is SLOW (on a million record file).