Hi

I'm not sure there is need to check for idleness. Actually, in an extended way of thinking, application idleness is not the same as sql connection idleness. For example, an accountant that downloads data for a report cand spend 2 hours on that report, doing whatever he does. The application is not idle, but the connection is. From this point of view, I think it's safe to execute SQLIdleDisconnect() immediately after the downloading data for report.

Thanks.


>Hi all,
>
>VFP9 offers a new SQLIDLEDISCONNECT( ) Function. According to on-line documentation it "allows a SQL pass-through connection or connections to be temporarily disconnected".
>
>The function works flawlessly. Black magic. The connection (the connection handle) gets recreated automatically when needed.
>
>It looks like SQLIDLEDISCONNECT would be best used after an amount of idle time (say a couple of seconds)... not whilst the user is active.
>
>The question is "how to trigger the function automatically" after a couple of seconds of idle time, probably using a timer. This question leads to another one: how can you check an application for idleness?
>
>Regards
>
>Francis