Subject Re: [IBO] Still having problems with OnCalculateField
Author Stuart Hunt
--- In, 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
> object as it crosses the threshold. IOW, it might be happening
before the
> field-level trimming for the datalink. (Trimming doesn't alter the
> data, only the displayed data). I think you'll need to use
> 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.
> ....
> ...
> 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