Rick Debay wrote:

> I created an external table DDL to import a fixed width file with 326
> columns. To move that data in to the internal table, I was going to
> select from a view. I want the view to trim trailing blanks and to
> convert the file's various date formats to Firebird dates.
> Without any data conversion the view can be created without any problem.
> When I try to trim all text fields that are longer than one character, I
> get an error that the table definition, at 65574 bytes, is too large.

Which version of Firebird is this? It seems that you are using the trim
UDF instead of Firebird's builting TRIM function. If this is the case,
try dropping the UDF and using Firebird's trim (if your version supports
it) or declare UDF with 'shorter' field size.


--
Milan Babuskov
http://www.flamerobin.org
http://www.guacosoft.com