General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Need to delete some DBFs, but... FAST!
Hi,
I have an application that at the begining delete some DBF files that are "connected" to a database (they are not free tables, because i need big field names). So, as i enter at the application i do:
LOCAL i
OPEN DATABASE DBC() EXCLUSIVE
IF ADBOBJECTS(abc, 'TABLE') > 0
WAIT WINDOW "Deleting temporary files..." NOWAIT
FOR i = 1 TO ALEN(abc)
IF USED(abc(i))
USE IN (abc(i))
ENDIF
DROP TABLE (abc(i))
NEXT i
RELEASE abc
ENDIF
But, when we have 60 files this become a nightmare for the user, since it take a lot of time. It there any way to delete these files, in a quicker way? NOTE: i cannot use DELETE FILE, otherwise it will give me errors because the "connection" to the database isn't deleted.
Any idea?
Thanks in advance.
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