Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Acess to Tables
Message
 
 
À
18/01/2005 08:22:49
Jon Neale
Bond International Software
Wootton Bassett, Royaume Uni
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Divers
Thread ID:
00978042
Message ID:
00978053
Vues:
42
Thanks John

When I run my new code it fails at the second time I test if the table is open. It says file is in use. Whats more is that if it fails and I run it again I get the same message. Any ideas?
LOCAL lcusername, lcuserstate

thisform.WindowState = 1

lcusername = ALLTRIM(READINI( "PREFS", "LASTUSER", "P:\QUESTPDM.INI"))
lcusertate = ''

= WRITEINI( "PREFS", "LASTUSER", thisform.combo1.displayvalue, "P:\QUESTPDM.INI")

SET EXCLUSIVE OFF

IF !USED("userlog")
	USE userlog IN 0 SHARED
ENDIF

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

! U:\questpdm\questpdm.exe

SET EXCLUSIVE OFF

IF !USED("userlog")
	USE userlog IN 0 SHARED
ENDIF

SET ORDER TO NEIL   && ALLTRIM(PDMUSERID)+ALLTRIM(INSYSTEM)

SEEK 'lcusername'+'In'
REPLACE UserLog.DateTimeO WITH DATETIME(), UserLog.insystem WITH 'Out'

CLEAR EVENTS
QUIT
Neil Lewis
IT R&D Manager
Velmore Ltd
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform