>Sergey,
>
>What I cannot understand is this:
>
>Why does it work like a charm with only a few thousand records. Then, when it increased at the current level, it stopped working. Even with calling CursorFill() with NoData = .T. The only reason I can deduce is the fact that it has reached a critical record count.
>
>But, it works or can be accessed using SPT() or MySQL Query Browser.
>
>Geeezzz.... am getting desperate...
>
>Dennis
>
>
Does MySQL have a tool similar to SQL Profiler you can use?

In addition, did you try changing selectCmd as I suggested?