> I can't find any infos about this, but it seems there's a hard 64
> characters limit on file path when using an external tables (using
> Firebird 2.1.2 SS on Windows XP SP3).
>
> The CREATE TABLE statement execute without errors, but all operations
> (SELECT, INSERT, ...) fail with an "arithmetic exception, numeric

overflow

> or string truncation"
>
> Is there a way to bypass this limitation ?

This error suggests that the problem is in the definition of the
external table, not with the path length.

Have you:

1 - Double checked the table definition? The fields should be defined
as CHAR().

2 - Created a CRLF CHAR(2) or CR CHAR(1) field? To account for the row
break/separator which may be present in the table data?


Sean