Hey folks ... anyone?

Hi Mark ... I do want to limit who can eject someone from a record ... but I'm doing that with checkbox limiters on a staff profile form. 

I trust the person to responsibly eject people, but not necessarily be technically savvy enough to use the administrative panel.

How about this -- if I use @Asynchshell and the 'taskkill' command function, I could potentially force other clients to close their sesame clients.  However, is there a way to retrieve the locking IP address of a given record, or send a pop-up message to a remote client to warn them their sesame executable might suddenly vanish if they don't get off the record?

Thanks!

OK!  That gives me a great idea, if I can do the following:

1) Have the GlobalValue 'gKillIP' that can be altered by a 'Kill Button'.  The Kill Button would ask the Admin for a client IP (which they can see in the message bar at the bottom of the locked record), and then set the global value in the application.

2) Have every computer look up it's IP on logging in as a client and set the local global value 'gClientIP'.

3) Have RunEntryOnInterval check every 5 minutes to see if gKillIP = gClientIP, and if so, wipe the gKillIP global value to "", force the record to advance by F10, or exit the form.  If I'm feeling fancy have @MsgBox pop up to tell them they've been ejected.

Would this work?

If it would in theory, I need to figure out the following, because these areas of Sesame are unfamiliar to me.

- how to look up a local client ip when someone logs in?

- how to activate RunEntryOnEvent when entering a form, and looping in the background every 5 minutes or so (can that be done?  Will it tie up network resources?)

Am I on to something here?

Thanks!

Success!

I've successfully launched a 'heartbeat' run on interval and kill button.  Happy to share my code.

Here's my Global Code that grabs the local IP and kicks in the heartbeat code:

// ======================
// Grab Local IP of User
// ======================

gLOCALIP = @redirectprocess("ipconfig","")
gLocalIP = @replace(gLocalIP,";","-")
gLocalIP = @replace(gLocalIP,@newline(),";")
gLocalIP = @containsstringarray(gLocalIP,"IPv4",0)
gLocalIP = @replace(gLocalIP,":",";")

RunEntryOnInterval(DBColNot,120000)
 

Here's the heartbeat code that kicks in on form entry:

var gKillIP as string

gKillIP = @GlobalValue("gKill")

if @instr(gLocalIP,gKillip) >0
{
	GlobalValue("gKill","")
	FormCommit("")
	@Save
	ExitSesame()
}
 

And here's the 'Kill User' button I've created:

var gKill as string
var vKillUser as string

vKillUser = @PromptForUserInput("Which IP Would You Like To Kill?","")

if vKillUser<>""
{
	GlobalValue("gKill", vKillUser)
}
 

Ultimately, I'd love to leave a pop up screen independent of Sesame (I think I saw something I can co-opt out of InsideSesame) saying 'you've been kicked out', but otherwise I'm pretty happy with the way this works ...