Hi,

I'm having some huge blobs in a table. If I open that table in edb
manager and the blob column is visible, you can think of going out for
a cofee between grid paints. However if I resize the window so that the
blob column is no longer visible, paint it's fast like it should be.

regards,
Lucian

Lucian,

<< I'm having some huge blobs in a table. If I open that table in edb
manager and the blob column is visible, you can think of going out for a
cofee between grid paints. However if I resize the window so that the blob
column is no longer visible, paint it's fast like it should be. >>

Explorer/Preferences/Data View/Grid Display/Uncheck Show BLOB Columns

--
Tim Young
Elevate Software
www.elevatesoft.com

> Explorer/Preferences/Data View/Grid Display/Uncheck Show BLOB Columns

I'd like to know when records have empty blobs...

Lucian

Lucian,

<< I'd like to know when records have empty blobs... >>

Delphi requires that a BLOB be opened/read in order to get the size, and
unfortunately there's not much we can do about that.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim Young wrote:

> Lucian,
>
> << I'd like to know when records have empty blobs... >>
>
> Delphi requires that a BLOB be opened/read in order to get the size,
> and unfortunately there's not much we can do about that.

I did not say I am interested in knowing the size. I am interested in
knowing if it's empty or not ... and more important I am interested to
have a fast paint

regards,
Lucian

Lucian,

<< I did not say I am interested in knowing the size. I am interested in
knowing if it's empty or not ... and more important I am interested to have
a fast paint >>

Yes, but "empty" or NULL ?  EDB can only show you if it is NULL or not in a
fast manner.  To determine whether it is "empty", it has to get the size,
and we're back to square one.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim


Does that mean there's a bit of a positive side to my hated NULL <> EmptyString thing?

Roy Lambert

> Yes, but "empty" or NULL ?

Just semantics ... English is not my native language and in Romanian we
can't say NULL. What I think is the right thing to do is the same as
what DBSYS does. But than of course if tons of EDB customers want to
see the blob size, heck, what can I do?

regards,
Lucian

Lucian

>> Yes, but "empty" or NULL ?
>
>Just semantics ... English is not my native language and in Romanian we
>can't say NULL. What I think is the right thing to do is the same as
>what DBSYS does.


Unfortunately it isn't just semantics. In DBSys an empty string and NULL were the same. In ElevateDB they aren't. As an example its possible to edit a CLOB in a DBMemo, essentially clearing it but an empty string is left in there which is not NULL.

This is why I subclassed TEDBTable to .Clear fields where an empty string would be posted.

Roy Lambert [Team Elevate]

Why not do a SELECT from the table to see if it is empty or not.