It works fine as is, My concern was the numerous UPDATE lines, is there a faster way or maybe a better <GRIN> way.Also I am trying to find if the COMPUTERNAME entry exists, but using I always get back 0. ANy ideas....
; Look for COMPUTERNAME in DB ...
$recordset=val("&"+olecallfunc($connection,"execute","s","select count(COMPUTERNAME) as total from logon where COMPUTERNAME = '@WKSTA'"))
? "$recordset"
? "$total"
; If COMPUTERNAME does not exist create record ...
if $recordset.wkstatotal=0
?"mdac:error - user not in table"
; Add a record for this COMPUTERNAME, note this field is primary will allow no duplicates...
$= olecallfunc($connection,"execute","s","insert into logon (COMPUTERNAME) values ('@WKSTA')")
endif
CTG
