Display a mysql blob field text like the demo

[Tinygoldwing]

I porting over my app from intraweb to uniGui and I'm trying to get the mysql blob field to display text instead of BLOB.  I've tried DisplayMemo and a combination of other properties like ForceFit to get it to display like the fish demo.  Any idea of what of what I'm missing?

Thank Ed

Unigui 1.90.0.1545
xe10.3

[Sherzod]

1 hour ago, Tinygoldwing said:

Unigui 1.90.0.1545

Hello,

Sorry, are you using a trial edition?

[Tinygoldwing]

No registered version

[Sherzod]

13 hours ago, Tinygoldwing said:

No registered version

Please adjust your forum email address first. 

[Tinygoldwing]

Sherzod sorry I didn't realize I used my personal email.  It's changed.

[Sherzod]

Just now, Tinygoldwing said:

I didn't realize I used my personal email.  It's changed.

 

[Tinygoldwing]

I thought the office added me as a authorized user.  The main user is randy.sill@vas.com   I will check with them.  Question, in the form above it only has a place for one email but two of us are using it.  Is there a way to have two people's emails.

Thanks,

Ed

[Farshad Mohajeri]

On 3/3/2021 at 6:29 AM, Tinygoldwing said:

I porting over my app from intraweb to uniGui and I'm trying to get the mysql blob field to display text instead of BLOB.  I've tried DisplayMemo and a combination of other properties like ForceFit to get it to display like the fish demo.  Any idea of what of what I'm missing?

Thank Ed

Unigui 1.90.0.1545
xe10.3

What is type of the Blob field?

[Ron]

To display text blobs I typically do a substr of the blob field in the sql call.

select substr(textblobfield, 1, 500) as textfield from mytable;