Hi Nick!

>Is there any way i can use a progress bar that will execute during a
>SQLEXEC() command. The select that i require from SQL is long and
>the client not very patient.
>
>My command is like this:
>=SQLEXEC(gnConnectHandle,"SELECT DISTINCT clienno FROM customer","ListClient")
>

I don't know any way to do this directly from VFP. In my experience there are
some cases when we do this for SmallTalk using Notification Server For Sybase
SQL Server v.10-11, written using Open Server toolkit. This workaround may be not applicable for your task.

Second advice, with also may relay on actual task, is to use not a bulk select
from SQL Server, but retrieve records in portions, using ROUCOUNT command.

May be this helps.

Alexander Mitchenko, Kiev, Ukraine