Subject | Re: [firebird-support] FreeUDF Lib, the CS function....and errors when calling twice |
---|---|
Author | Alexandre Benson Smith |
Post date | 2008-08-21T21:55:20Z |
Rich Pinder wrote:
--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br
> Hi allWhat's the SQL declaration of UDF cs ?
>
> FB 1.5 here, on Intel machine.
>
> I've found that using the little CS function call (from the FreeUDF
> library) very useful to format name and address strings (if you've not
> familiar, it capitilizes the first letters of words in strings)
>
> Calling it once works great:
>
>
>> select ln, cs(ln)
>> from nameadd
>> where recno = 1
>>
>
> PHAM Pham
>
>
> However if I call it TWICE in a statement, I get an error:
>
>
>
>> select ln, cs(ln), fn, cs(fn)
>> from nameadd
>> where recno = 1
>>
>
> invalid request BLR at offset 52 Implementation limit exceeded block
> size exceeds implementation restriction
>
> Any suggestions how to move past this problem ??
>
> Thx
> Rich Pinder
> USC School of Medicine
>
--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br