Dan Wilson wrote:

> I am attempting to use external tables for the first time. My goal is to import data using an external table and an SP. I have tested the SP and the code that creates the external table, and it works for the first record written to the external table. However, the second record fails inside the SP with Error -413, Overflow occurred during datatype conversion, Code 335544334 Conversion error from string '0'.
>
> I suspect that my record length, written from C++, differs from what Firebird (1.5 final) is expecting. As one attempt to fix this, I placed a #pragma pack(1) command around the C structure definition. That changed the file size, but didn't fix the problem.
>
> Are there any gotchas I should be aware of regarding creation and storage of records into external tables?

Try my fbexport tool and save yourself a headache. More info here:

http://fbexport.sourceforge.net


HTH

--
Milan Babuskov
http://fbexport.sourceforge.net