>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

Thanks, very simple very clear and useful.