>>>Make sure, that you only call SQLIDLEDISCONNECT() when the 5 second connection check fails. If you do this for each and every cursorfill rather than when neccesary, it is going to have performance effects as the connection is reset on the OBDC driver level.
>>>
>>>Walter,
>>
>>Please explain what do you mean by "5 second connection check fail".
>>Do you mean if there is no connection to the server for 5 or more seconds? If so, how do you check how long ago the application connected to the server? Does VFP have a native function for it or I need to create the application property and store the value myself?
>
>The intention is that whenever the last activity on the connection was more than 5 seconds ago, you check the connection with an empty command and fix the connection before you execute a new query.
>
>Technically I do this by storing the time when I access the applic.sqlhandle property (by using applic.sqlhandle_access). In my CA class I just do a =Applic.SQLhandle in the beforecursorrefresh and beforecursorfill events.
>
>In the sqlhandle_Access, I check the timedifference between now and the last time. If it was more than 5 seconds ago. I check the connection. Upon failure I try to reconnect. If successfull, it will continue to try to execute the original
>SQL statement (e.g. through cursorfill), if unsuccessfull my application will wait until forever until the connection comes back

Sorry for a follow up question (hopefully the last one)
You wrote:
>> if unsuccessfull my application will wait until forever until the connection comes back
I created a method of the application class that checks for the SQL connection and so on. This method is called from the conn_handle_access method (of course, if the time passed from the last connection is 5 or more seconds).
Do you mean that the code "stays" forever in the conn_handle_access until the oApp.check_sql_connect() (method that checks connection) returns .T.?

TIA