Hello folks.
I have the following code:
What this does, of course, is create a text file in the <interbase home>/ext directory. Problem is I often need to drop the table that is based on an external file (since I just use them intermittently for exports and imports), so I do that. No problem there. However, the file itself on the disk is locked somehow. I can't modify it, rename it or delete it. I tried the dropping the table thing, thinking this would disconnect the file from Interbase. I also tried shutting down IBConsole.
The only thing I haven't tried is shutting down the database and/or server.
Do you have any suggestion?
Thank you for your help.
-Mike
I have the following code:
Code:
CREATE TABLE EXT_R0000048
EXTERNAL FILE 'ext_r0000048_1.txt'
(
RECORD INTEGER NOT NULL,
STATUS INTEGER,
TIMEZONE INTEGER,
LISTCODE INTEGER,
STRATEGY INTEGER,
DIALS INTEGER,
CALLS INTEGER,
LASTCALLED TIMESTAMP,
DISPOSITION INTEGER,
FILLER9 VARCHAR(9),
PHONE VARCHAR(10),
FIRST_NAME VARCHAR(12),
LAST_NAME VARCHAR(13))What this does, of course, is create a text file in the <interbase home>/ext directory. Problem is I often need to drop the table that is based on an external file (since I just use them intermittently for exports and imports), so I do that. No problem there. However, the file itself on the disk is locked somehow. I can't modify it, rename it or delete it. I tried the dropping the table thing, thinking this would disconnect the file from Interbase. I also tried shutting down IBConsole.
The only thing I haven't tried is shutting down the database and/or server.
Do you have any suggestion?
Thank you for your help.
-Mike