Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 3 of 3 total
Thread EDBManager & graphics columns
Mon, Jun 23 2008 8:56 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Tim

I have a column in my emails table _Graphics which is a blob field and contains in-line images for html. I also have a size field which shows the overall size of the email including attachments.

I just had a mild panic since I looked at the _Graphics in EDBManager and found a mix of things like 146517 bytes or NULL. I was frantically going through my conversion code trying to find where I'd written the size into _Graphics.

Without double clicking the column its impossible to visually determine that it is a blob column holding images.

I'm not sure what to suggest but I think some sort of visual indicator is needed since I doubt anyone can remember the type of all the columns in a database. Maybe different coloured headers or columns for different types?

Roy Lambert
Mon, Jun 23 2008 9:11 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Roy,

<< I'm not sure what to suggest but I think some sort of visual indicator is
needed since I doubt anyone can remember the type of all the columns in a
database. Maybe different coloured headers or columns for different types?
>>

I'm not sure what the issue is, because it's very consistent - any BLOB
columns contain the size of the BLOB if there is data present, and NULL if
not.  If you click on the BLOB value in the grid, the details on the left
will tell you that it's a BLOB value.

--
Tim Young
Elevate Software
www.elevatesoft.com

Mon, Jun 23 2008 9:51 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Tim

>I'm not sure what the issue is, because it's very consistent - any BLOB
>columns contain the size of the BLOB if there is data present, and NULL if
>not. If you click on the BLOB value in the grid, the details on the left
>will tell you that it's a BLOB value.

The issue is that whilst I thought I remembered that _Graphics was a BLOB and I'd stuffed the in-line images in there visually its no different to any other column (until you double click it) with a mixture of NULL and data, and since I also had a size column it looked identical. I know its not going to be that common an occurrence having a column which resembles your display but it would be nice if they were differentiated in some way.

Roy Lambert
Image