Subject Re: Calculated stringfield problem
Author ifitsx
> 'StartingText' is a Calculated Stringfield, Size 36.
>
> 'EditedText' is ftBlob.
>
> With IBO v4.2.Hd, I have been able to simply assign the blob field to the calculated stringfield, filling the stringfield with the first 36 characters of the blob.
>
> Now, with DXE2 under IBO v4.9.14 36, the blob field loads ok into the DBMemo, but the direct assignment from the blobfield 'EditedText' to the stringfield 'StartingText' is mostly '?????????' with an occasional '4' or a '6'.
>
> Typecasting String(DataSet['EditedText']) or AnsiString(DataSet['EditedText']) compiles ok but 'StartingText' is still mostly '?????????' .
>

It occurred to me to try using the FieldByName('StartingText').AsString and FieldByName('EditedText').AsString for the blob and it works.

I'm not sure if that would have worked in previous versions, but since this works, does that mean that using Streams with text blobs is no longer necessary?

Or are there performance benefits?

Barry