Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Insert table problem
Message
From
08/03/2008 09:58:50
 
 
To
08/03/2008 09:54:38
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01299941
Message ID:
01299944
Views:
9
>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.
Previous
Reply
Map
View

Click here to load this message in the networking platform