Subject | Inserting into Table needing truncate for varchar |
---|---|
Author | fabianchocron |
Post date | 2006-04-18T04:13:19Z |
Hi All,
My name is Fabian, and I have being using Firebird for about 2 years
with greate results.
I have an App that uses "Insert into Table Select Varchar ....
The problem is that sometimes the Varchar is "bigger" than the defined
receiving field. Is there any way to "truncate on the fly"... so the
app can insert regardless of the size of the "selected" field?
Many thanks!
Fabian
My name is Fabian, and I have being using Firebird for about 2 years
with greate results.
I have an App that uses "Insert into Table Select Varchar ....
The problem is that sometimes the Varchar is "bigger" than the defined
receiving field. Is there any way to "truncate on the fly"... so the
app can insert regardless of the size of the "selected" field?
Many thanks!
Fabian