
'NOT A TABLE' error message
Hi, can any1 help me with this? Its very weird, I have a table which is
accessed whenever a user logs on to my program. Its purpose is to store the
username of the last person who logged on, then that username is displayed
automatically during the next log on.
It works perfectly most of the time, but every now and then the table seems
to get corrupted and i get a message 'NOT A TABLE'.
To get around this i simply delete the table and it is created again
automatically the next time someone logs in.
I havent been able to determine a common factor associated with this other
than the fact that it seems to happen on average once a week.
Your help is as always very appreciated
John
***this code is run at the start of log in***
IF FILE(SYS(5)+'\lastlogin.dbf')
use SYS(5)+'\lastlogin' exclusive IN 0
select lastlogin
username3=ALLTRIM(lastlogin.userlist)
use
ELSE
username3=username
ENDIF
***this code is run at the end of log in***
SET SAFETY off
SELECT * from login;
WHERE
alltrim(upper(LOGIN.USERLIST))==alltrim(upper(thisform.TEXT1.value));
INTO TABLE SYS(5)+'\lastlogin'
SET SAFETY on