THANKS

> What's the SQL declaration of UDF cs ?

If this was meant to be a 'hint' - it got me goin !!
Default declaration was indeed a big value (32760) - so I bumped input
and output length to more realistic cstring lengths...works GREAT

Thanks again
Rich
(god, i love this list!)



Alexandre Benson Smith wrote:

>
> Rich Pinder wrote:
> > Hi all
> >
> > 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
> >
>
> What's the SQL declaration of UDF cs ?
>
> --
> Alexandre Benson Smith
> Development
> THOR Software e Comercial Ltda
> Santo Andre - Sao Paulo - Brazil
> www.thorsoftware.com.br
>
>