I have a program which is invoked using the following command on a button in the onclick event on a form:

! /n c:\questpdm\questpdm.exe

Prior to this I write a record to a table to state when that user logged in to the system.
When the user closes the calling program I want to write the datetime when they logged out for the same record. Can this be done?

Here is my code:

use userlog

INSERT INTO 'userlog' (pdmuserid, domuserid, datetimei) VALUES (thisform.combo1.displayvalue, SYS(0), DATETIME()) 
 
! /n c:\questpdm\questpdm.exe

INSERT INTO 'userlog' (pdmuserid, domuserid, datetimeo) VALUES (thisform.combo1.displayvalue, SYS(0), DATETIME())

Obviously from the code above a record is written. But then as soon as its written another record is written. I know this is wrong.

What I would like to do is halt processing on my button until the calling program as closed. In addition I would like to write the datetimeo to the same record instead of writing another record.

Any help would be greatly appreciated.