Hi,

How do we access external files in FB 1.5 ?


CREATE TABLE E_LOG_FILE EXTERNAL 'D:\PHARMA\LOG_FILE.TXT' (
ENTRY_DATE CHAR(10) CHARACTER SET NONE,
ENTERED CHAR(13) CHARACTER SET NONE,
ID CHAR(8) CHARACTER SET NONE,
CONTROL_NO CHAR(10) CHARACTER SET NONE,
PRODUCT_ID CHAR(5) CHARACTER SET NONE,
QUANTITY CHAR(5) CHARACTER SET NONE,
DESCRIPTION CHAR(50) CHARACTER SET NONE,
NEWLINE CHAR(2) CHARACTER SET NONE
);


A file created with above given statment gives the following
error
when accessing ?


Unsuccessful execution caused by a system error that precludes
successful execution of subsequent statements.
I/O error for file "D:\PHARMA\LOG_FILE.TXT".
Error while trying to open file.
The operation completed successfully.
.


Pls help

Thank you.

Ben