> Which version of Firebird is this?

Version 1.5.2. We're migrating to 2.1.2 when it releases. Yes, we're
using the UDF.

-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Milan Babuskov
Sent: Friday, February 20, 2009 5:12 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] External file load

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



------------------------------------

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Yahoo! Groups Links




Disclaimer: This message (including attachments) is confidential and may be privileged. If you have received it by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized use or dissemination of this message in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change. RxStrategies, Inc. shall not be liable for the improper or incomplete transmission of the information contained in this communication or for any delay in its receipt or damage to your system. RxStrategies, Inc. does not guarantee that the integrity of this communication has been maintained nor that this communication is free from viruses, interceptions or interference.