community.borland.com

Article #25481: Using External file Names With Create Table

Problem:
Do you have to specify the drive letter when you create an table that  references external file? 
I worked through the example on p. 82 of the Data Definition Guide for Create Table.
Then I did a Show Metadata.  The metadata definition  shows drive  that the file is 
always located on drive c: -- regardless of the drive letter it really resides on.


Solution:

Yes, you do need to specify the full path of the file.  Otherwise, InterBase will attempt to
reference the file in a path on drive "c".   It does not check to see that the file is there.    
It will not default to the directory name where the database is located.    You have to specify the full path 
and file name correctly for your external table definition to work correctly.

Last Modified: 26-OCT-00