Date:  05/02/2011 08:04:02 PM Msg ID:  004277
From:  Ali Koumaiha Thread:  004277
Subject:  Number of current active users?
I am wondering if accessing the _fwsession table and getting all the records where the LastHit in the last 25 minutes would give me the desired results.

something like this:

Select Count(*)  as CurrentUserCnt ;
  From _fwSession ;
  where (Datetime() - LastHit) / 60 ) <= 25 ;
 into cursor _curCurrentHits

lnUserCount = nvl(_curCurrentHits.CurrentUserCnt,0)

use in select('_curCurrentHits')
 

Or is there a method in the Auth class that does that? or any other class in FoxWeb?

Thanks