blob size

[John Cantin]

how can i get the size of the data stored in a blob field?

i was trying...

sizeof(ibquery1.fieldbyname('picture').Value)

but it always returns a 16

ive also tried

sizeof(ibquery1.fieldbyname('picture').asstring)

but it always returns a 4

i figure its probably the size of the pointer to the data instead of the
size of the data

[Craig Stuntz [TeamB]]

Post by John Cantin
sizeof(ibquery1.fieldbyname('picture').asstring)

Depends on what's in it. If you want the length of a string in chars,
use Length, not SizeOf.

If it's something else, be more specific, please.

[John Cantin]

that was the trick!

thanks!

Post by Craig Stuntz [TeamB]

Post by John Cantin
sizeof(ibquery1.fieldbyname('picture').asstring)

Depends on what's in it. If you want the length of a string in chars,
use Length, not SizeOf.
If it's something else, be more specific, please.

[Marc Rohloff [TeamB]]

On Tue, 29 Jan 2008 13:22:08 -0600, John Cantin wrote:

Please don't multipost. I answered this elsewhere.

[John Cantin]

sorry, i wasnt sure where to ask.

Post by Marc Rohloff [TeamB]
Please don't multipost. I answered this elsewhere.