>Tore,
>
>
be aware that "Visual Foxpro is not responding" does not necessarily mean that it hangs, it may simply be busy processing your data.>
>If that is the case, why does it show "not responding" even with just getting the structure - oCAParcel.CursorFill( .T., .T. ) against the live database? If I run the form using my test data which has only a few thousand records, it executes ok.
>
>Thanks
>Dennis
Google for MySQL SQL Profiler and if there is no such a tool, run ODBC trace as Sergey suggested. It sounds like you're trying to get all records back - could be some bug in CA.
If it's not broken, fix it until it is.
My Blog