Thanks for the answers Trey.
>Either it got used as a table
>or is open in another data session
>or it's being used by someone else on the network
>or a com server has it open, in which case you won't be able to see it open.
Yes, the DBC was open as a file in datasession 1. I consulted it and forgot to close it. oops!
>Just USED("PL") - you're only checking an alias name
>I would use:
>If Used("pl") And JustFName(DBF("pl"))="PL.DBC"
>JustFName being in FoxTools < VFP6
>Since it's checking an alias, USED() only works in the current data session.
I didn't know that USED only works in current data session, because it uses alias. I am not sure I understand your suggestion. How does one find out if a file "xx.yy" is being used in another data session? I guess normally it doesn't matter, but in this case it does.
>Can you not manually pick it from the viewer? I wasn't sure if you were only doing this is code.
>You could suspend and ACTIVATE WINDOW standard
to pull up the standard toolbar and check the databases in use from the database combo.
I tried picking it from the viewer but it refuses to change to datasession 1.
Thanks a lot.
Alex
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only