blob column question.

[carlossm]

Hi, for some reason the blob columns on a table are not being loaded from disk.
In the GenerateForm embed, I'm trying to copy the content of a blob into a session variable and the size comes back as zero. I know there is data in the column, I checked it with MySql workbench.

size(Pac:AHF) comes back as zero.

Any Ideas?

Thanks
Carlos San Miguel

[Bruce]

Hi Carlos,

I think you'll need to set up an example - ideally with TPS (which also support blobs) for what you are trying to do.

Blobs are not the same as "big strings" and aren't typically used to hold "big string data", so they behave differently to string fields, both at the Clarion driver level, and the NetTalk level.

So take one of the shipping examples, tweak it a bit to contain a blob, and let's see what can be done.

cheers
Bruce

[carlossm]

Thanks Bruce. I ended using cstring(64000). I don't think I'll need more than that.

Carlos San Miguel