Hi,
Besides doing this...
dim rc as RecordSet
dim i as integer
rc = SQLselect("SHOW CONNECTIONS")
if rc <> nil then
i = 0
while not rc.EOF
i = i + 1 //spin and count
rc.MoveNext
wend
rc.Close
Return i
end
Return -1
Is there a more reliable method to get the number of connected users,
connected to a single database on a REAL SQL server, serving several
dbs?
--
Cheers,
Dr Gerard Hammond
MacSOS Solutions
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
