Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Acess to Tables
Message
 
 
To
18/01/2005 08:22:49
Jon Neale
Bond International Software
Wootton Bassett, United Kingdom
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00978042
Message ID:
00978053
Views:
43
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform