Hi Gang!

My colleague is having a bit of a problem with databases in VFP 8.0 SP1.

This is what he emailed me.....

Here is what is happening:

Database local_lbl is open from pharmmain.prg.

The following code snippet gives me a file in use error on Line 5 (delete database…)

IF FILE("c:\temp\local_lbl.dbc")
SET DATABASE TO local_lbl
USE IN SELECT("rx_label")
CLOSE DATABASE
DELETE DATABASE c:\temp\local_lbl deletetables
ENDIF


Any clues as to why he is getting this error? I don't see why at this point .....

Thanks in advance!