How to kill a remote session?

hello raj,

if i am using a local database can i kill my session???
since i am trying this example in my laptop and not in a server where lots of people are using my databse i cant test it. can i test this in local databse?? i created the single instance codeunit but where from shoiuld i call this codeunit to run close sessions??
pls advise as i m new to navision i have little knowledge only
thanks in advance

rajpatelbca wrote:

if you are talking about session killing then see this link.

http://www.mibuso.com/forum/viewtopic.p ... ssion+kill

Dear Kriki
If I will create the Report (Processonly) by taking DataItem(Session) and give filter to Login type to(Windows) then will it work in SQL DB.

hi kriki,

i tried as u said using 2 fin.exe opened. but when i tried to run my codeunit one error message prompted saying "You cannot close a session when u r not connected to server" ??? what did it mean..how to solve this issue pls advise

thanks Vineeth

kriki wrote:

You can open the same local DB multiple times if you use the same fin.exe.

If you put code in the OnRun-trigger of the singleinstance codeunit to initiate the timer, you can just run the codeunit from the object designer.

Dear Kirki

this is my single instance codeunit coding to kill a session



OnRun()

IF ISCLEAR(Timer) THEN
CREATE(Timer);
Timer.StartTimer(6000);
Code;

Code()

Session.SETRANGE("My Session",FALSE);
Session.SETFILTER("Idle Time",'>100 min');
IF Session.FINDFIRST THEN REPEAT
Session.DELETE;//Debugger stops here saying "you cannot delete a session when u r not connected to server
COMMIT;
UNTIL Session.NEXT = 0;



how to solve it.. i tried it by opening two fin.exe and running this codeunit in one

kriki wrote:

I never saw that error. :shock:
Try to use the debugger to see if you find something more on the command that creates the error.

Vineeth.R wrote:

hi kriki,

i tried as u said using 2 fin.exe opened. but when i tried to run my codeunit one error message prompted saying "You cannot close a session when u r not connected to server" ??? what did it mean..how to solve this issue pls advise

thanks Vineeth

kriki wrote:

You can open the same local DB multiple times if you use the same fin.exe.

If you put code in the OnRun-trigger of the singleinstance codeunit to initiate the timer, you can just run the codeunit from the object designer.

The code master strikes again! \:D/