file is in use and used('tablename')

TheMSsForum.com: The Microsoft Software Forum

I use vfp8 and winxp.

When I run this code something strange happens.

IF USED('sdstud') then
USE IN 'sdstud'
endif
USE sdstud IN 0 exclusive && line 47

In line 47 I get 'file is in use' error message.

How come, when I closed it in the instructions above line 47?

When I run the code a step at a time, used('sdstud') is false so it goes
straight to line 47 and reports 'file is in use'.

Can anyone help me?

Sincerely,

Jan Nordgreen
Top

Re: file is in use and used('tablename') by Fred

Fred
Thu Mar 04 09:23:29 CST 2004

The table might be in use by another user, or you have it open under a
different alias in your app, or you may have it open in a different
datasession. There could be lot's of reasons its "in use".

Fred
Microsoft Visual FoxPro MVP


"Jan Nordgreen" <room23111@hotmail.con> wrote in message
news:eS%23LdufAEHA.2040@TK2MSFTNGP12.phx.gbl...
> I use vfp8 and winxp.
>
> When I run this code something strange happens.
>
> IF USED('sdstud') then
> USE IN 'sdstud'
> endif
> USE sdstud IN 0 exclusive && line 47
>
> In line 47 I get 'file is in use' error message.
>
> How come, when I closed it in the instructions above line 47?
>
> When I run the code a step at a time, used('sdstud') is false so it goes
> straight to line 47 and reports 'file is in use'.
>
> Can anyone help me?
>
> Sincerely,
>
> Jan Nordgreen
>
>


Top

Re: file is in use and used('tablename') by Wolfgang

Wolfgang
Thu Mar 04 12:45:04 CST 2004

Hi Jan!

Are you sure that the table is not open in another session or with another
alias? Or is the table involved in a Transaction which is not terminated?

--
_________________

MFG
Wolfgang Schmale

MS Visual FoxPro MVP

--------------------------------
"Jan Nordgreen" <room23111@hotmail.con> schrieb im Newsbeitrag
news:eS%23LdufAEHA.2040@TK2MSFTNGP12.phx.gbl...
> I use vfp8 and winxp.
>
> When I run this code something strange happens.
>
> IF USED('sdstud') then
> USE IN 'sdstud'
> endif
> USE sdstud IN 0 exclusive && line 47
>
> In line 47 I get 'file is in use' error message.
>
> How come, when I closed it in the instructions above line 47?
>
> When I run the code a step at a time, used('sdstud') is false so it goes
> straight to line 47 and reports 'file is in use'.
>
> Can anyone help me?
>
> Sincerely,
>
> Jan Nordgreen
>
>

Top