--- In IBObjects@yahoogroups.com, Helen Borrie <helebor@t...> wrote:

> At 10:18 AM 15/01/2004 +0000, you wrote:
>
> > No, not necessary, I think I understand what's the issue here.

This is

> happening because the event is reading the raw SQL data from each

Row

> object as it crosses the threshold. IOW, it might be happening

before the

> field-level trimming for the datalink. (Trimming doesn't alter the

stored

> data, only the displayed data). I think you'll need to use

TrimRight.

>
> Personally, I wouldn't generally use a calculated field for this at

all -

> I'd get it as a run-time column in the SQL.
>
> SELECT
> ....
> FORENAME||' '||SURNAME AS FULLNAME,
> ...
> But using a calc field might be useful if you know you have some

nulls in

> those columns...and they do have the benefit that you can call
> CalculateFields to update them in the buffer...
>
> H.

Thanks Helen. i'd started thinking this might be the case myself as
it was the only scenario that really made sense. Presumably this
means that the previous behaviour was a bug :-) Oh well, at least
trimming fields isn't exactly difficult - and I guess i'll use
VARCHAR fields in future.
Thanks for your help,
Stuart Hunt