This looks ok. Do you have two instances of the app running? Is this a

multi-user situation where another user might have the thing open?

Is there a reason you are using a dbf? Why not use a r/w cursor created

with CREATE CURSOR? If you must use a dbf for some reason, use unique

names created with SYS(2015) or something of your own making, but I

can't think of any reason why a cursor wouldn't suffice.

__________________________________

Cliff Robinson

EASDG

P.O.Box 1121

Carnation, Washington, USA 98014

(425)333-4339

Fax: (425)333-4914

CliffR@EASDG.com

http://www.EASDG.com

===================================

VFP Code Examples at:

ftp://www.easdg.com/pub/vfpexamples

-----Original Message-----

From: Brian Robichaud [mailto:jbr@bretech.com]

Sent: Tuesday, August 31, 1999 7:00 AM

To: Multiple recipients of ProFox

Subject: VFP6 -> delete a table... clarification?

Hello folks,

I'm feeling particularly thick (dense, stupid.. whatever,) this

morning...

can anybody tell me what I'm doing wrong?

USE IN myProjectSearch && <- I thought this closed the table/file.. but:

DELETE FILE 'c: empmyProjectSearch.dbf' && <- this raises a "file in

use

error"

myProjectSearch is a free table that is created and populated on init of

a

grid control then filtered based on set search criteria that may or may

not

be filled in.

How do I properly close this temporary file so that I can delete it when

I'm

done with this screen?

TIA

Brian

mailto:jbr@bretech.com