Subject Re: [IBO] Still having problems with OnCalculateField
Author Helen Borrie
At 04:08 PM 14/01/2004 +0000, you wrote:
>further to the posting I made earlier, i'm still having problems with
>OnCalculateField events padding string fields in IB Objects 4.3Aa. My
>complete system is:
>Delphi 4 update pack 2(I know this is very old - I'm about to upgrade
>it but decided to do the upgrade a bit at a time)
>InterBase 7.1
>IB Objects 4.3Aa
>Windows XP Service Pack 1
>The problem is still that when I use ARow.ByName('XXX').AsString in
>the OnCalculatedField method to get a field value it is padding out
>string fields where it didn't used to. For example, code to return
>someones name:
>procedure TfrmDocSel.qryDocumentCalculateField(Sender: TIB_Statement;
>ARow: TIB_Row; AField: TIB_Column);
>AField.AsString:=ARow.ByName('FORENAME').AsString+' '+
>Now returns "Stuart Hunt " instead of "Stuart
>Hunt". I use calculated fields a lot and therefore don't want to have
>to manually trim the fields for all these cases.

Are you sure these columns are varchar and not char? If you are using IB
7.1, there is nothing to trim on varchars, so I'm suspicious. :-)

If this *is* the problem, then use the FieldsTrimming attribute to
eliminate padding in whatever way you desire. This applies trimming at the
field level, either in the dataset, or globally if you want, in the
connection component.

>I have also ensured that the connection's DefaultNoTrimming property
>is FALSE.

This doesn't trim char types, afaik.