Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Detect active users at SQL Server
Message
From
14/11/2011 10:28:11
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
General information
Forum:
Visual FoxPro
Category:
Client/server
Environment versions
Visual FoxPro:
VFP 9 SP2
Database:
MS SQL Server
Miscellaneous
Thread ID:
01528779
Message ID:
01528829
Views:
50
>>>True, but you can have a test within VFP application for the inactivity and release application (and update login tables) for long periods of inactivity.
>>
>>I know that it's possible, but it's a pain in practice.
>
>What are the alternatives?

Do what web apps already do: send a keepalive signal. Maybe once in 4 minutes or so, a timer should update the LastSeenActiveAt datetime field in your login table. Then, serverside, you check for that field being older than 10 minutes or so (give them some chance for one or two failures - the app may be busy and the timer may not have fired).

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Reply
Map
View

Click here to load this message in the networking platform