Subject | Re: [firebird-support] Question re: inserting data w/ Select and Concat |
---|---|
Author | Michael Weissenbacher |
Post date | 2007-07-02T09:57:22Z |
Hi,
explaination is that eventually the size of the field WILL get too small, no
matter how long it is. Then you get the String Truncation error.
Michael
> Yes, this normally works, but you insert into the same table you do theIIRC Firebird <2.0 starts a never ending loop on this kind of query. So the
> select from.
> I guess this will lead to something like 'title-2-2-2-2-2-2-2-2-2-2' ...
> until the field length is exceeded.
explaination is that eventually the size of the field WILL get too small, no
matter how long it is. Then you get the String Truncation error.
Michael