>In my menubar , i want save the login id and logout time.
>so I put the following code in the menu bar 's procedure (named Exit)
>
>
>pAns = MESSAGEBOX("Are You Sure To Quit The Application ?",4+32,"Confirmation")
>
>
>IF pAns = 6
>insert into loginHistory(userid,module,logouttime)values(pub_userid,"SEA-OUT",datetime()) <-- got error "file is in use"
> QUIT()
>ELSE
> RETURN
>ENDIF
>
>does anyone know how to solve it ?
>Thanks a lot
I guess you already have table open exclusive. Anyway, since you are quitting anyway, add "Close database all" before the Insert command.