>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.
Neil,
For your second line use:
REPLACE UserLog.DateTimeO WITH DATETIME()
<\PRE>
HTH,
Jim