Kill session

shuba30

Hi all,

Can anybody explain me the way for killing an idle session in nav 6.1 DB.

Thanks,
G.Shuba

Christel

Hi,

Just click File, Database, information next click on the current session select the one you like to kill and delete that line

If you want the system to do it you can kill fin.exe on the workstation :-$

Greetings

shuba30

Thanks for your response.

But I need to kill an idle session automatically. Can you tell me how can I do it in Nav 6 SP1

Thanks,
G.Shuba

Christel

In the old day's we've done this on the timer trigger of the main form

RecSession = record "Session"

6.0 nobody asked for this function

RecSession.RESET;
RecSession.SETRANGE("My Session",TRUE);
IF RecSession.FIND('-') THEN
IF
(VarCacheReads <> RecSession."Cache Reads") OR
(VarDiskReads <> RecSession."Disk Reads") OR
(VarDiskWrites <> RecSession."Disk Writes") OR
(VarRecordsFound <> RecSession."Records Found") OR
(VarRecordsScanned <> RecSession."Records Scanned") OR
(VarRecordsInserted <> RecSession."Records Inserted") OR
(VarRecordsDeleted <> RecSession."Records Deleted") OR
(VarRecordsModified <> RecSession."Records Modified")
THEN
BEGIN;
VarCacheReads := RecSession."Cache Reads";
VarDiskReads := RecSession."Disk Reads";
VarDiskWrites := RecSession."Disk Writes";
VarRecordsFound := RecSession."Records Found";
VarRecordsScanned := RecSession."Records Scanned";
VarRecordsInserted := RecSession."Records Inserted";
VarRecordsDeleted := RecSession."Records Deleted";
VarRecordsModified := RecSession."Records Modified";
END
ELSE
BEGIN;
SHELL('C:\kill.exe fin.exe');
END;

stryk

Check this out:
http://www.mibuso.com/dlinfo.asp?FileID=367
http://dynamicsuser.net/blogs/stryk/archive/2008/12/10/prevent-multiple-logins-in-nav-with-sql-server.aspx
(applies only to SQL Server)