Brian,

If MyProjectSearch is a temporary table and created, accessed, and deleted

within your app, why not use a cursor?

If you need to you can have an empty structure table kept around permanently

and create a cursor from it using

=AFIELDS(TempArray) and

CREATE CURSOR MyCursor FROM ARRAY Temparray

Since you are getting a file in use, do you have a private data session and

the file is in use somewhere else?

Cindy Winegarden

Duke Children's Information Systems

cindy.winegarden@duke.edu

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

From: Brian Robichaud <jbr@bretech.com>

To: Multiple recipients of ProFox <profox@leafe.com>

Date: Tuesday, August 31, 1999 10:17

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

|

|

|

|