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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only