>Any idea to prevent fox from being a bit too fast ?
François,
Une autre idée...
Check SQLSETPROP in the help file. Here is the beginning of it. You'll see that you have a way to control the way SQL works.
Also, I would tend to minimize the loading time of the view, by having a NoDataOnLoad = .T. and limit the result set by having the user define one or some view parameters and issue a REQUERY() after that.
José
------------------
SQLSETPROP(nConnectionHandle, cSetting [, eExpression])
Returns
Numeric
Arguments
nConnectionHandle Specifies the connection handle to the data source returned by SQLCONNECT( ).
cSetting Specifies the setting. The following table lists the values for cSetting.
Setting Description
Asynchronous Specifies whether result sets are returned synchronously (false (.F.), the default), or asynchronously (true (.T.)).
Read-Write.
-----------------