Tim

Just posted this to the extensions ng and I suddenly thought - what, if any, are the implications of setting CLOBS & BLOBS to emptystring rather than NULL?

Does this mean that the files will use BLOBBLOCKSIZE (or whatever it is in ElevateDB) bytes for each record in the table?

---------------------------------------------------------------------------------------------------------------------------
John

From a post by Tim way back in January in response to me

<< That's the easy (decision not doing) one. I'm still working on what to do
with integers, floats, blobs, clobs, dates, times and timestamps. >>

<<Except for BLOBS and CLOBS, which work like strings in terms of NULLs, the
other types work exactly the same as DBISAM, therefore you shouldn't have to
do anything.>>

So both our scripts need a bit more work

Roy Lambert
---------------------------------------------------------------------------------------------------------------------------

Roy Lambert

Roy,

<< Just posted this to the extensions ng and I suddenly thought - what, if
any, are the implications of setting CLOBS & BLOBS to emptystring rather
than NULL?

Does this mean that the files will use BLOBBLOCKSIZE (or whatever it is in
ElevateDB) bytes for each record in the table? >>

Yes.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim


><< Just posted this to the extensions ng and I suddenly thought - what, if
>any, are the implications of setting CLOBS & BLOBS to emptystring rather
>than NULL?
>
> Does this mean that the files will use BLOBBLOCKSIZE (or whatever it is in
>ElevateDB) bytes for each record in the table? >>
>
>Yes.

OUCH!

Roy Lambert

Roy,

<< OUCH! >>

Yes, well, the assumption was that someone wouldn't go to the trouble of
populating every BLOB in the table with empty data.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim


You forgot someone who wants consistency in his testing without having to use two different tests each time and who took your words literally without testing out the behaviour of TDBMemo, expecting it to work the same as TDBEdit. It doesn't.

Deleting the contents of a TDBMemo and posting results in a NULL, deleting the contents of a TDBEdit results in an emptystring which we all know by now isn't a NULL.

To save me having to hurt my brain by ferreting around in DB is this as a result of your work on the problem I had with .Clear and .IsNull with storing tables in blobs a while back or Delphi's?

Anyway I'm now tearing up approach number one to solving my NULL issue - didn't like it much anyway.

Roy Lambert

Roy,

<< To save me having to hurt my brain by ferreting around in DB is this as a
result of your work on the problem I had with .Clear and .IsNull with
storing tables in blobs a while back or Delphi's? >>

Yes, that's the reason.  However, I figured out a way to do both, so I'll
log this as an incident report and make sure that it's fixed in 2.00 B3.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim


><< To save me having to hurt my brain by ferreting around in DB is this as a
>result of your work on the problem I had with .Clear and .IsNull with
>storing tables in blobs a while back or Delphi's? >>
>
>Yes, that's the reason. However, I figured out a way to do both, so I'll
>log this as an incident report and make sure that it's fixed in 2.00 B3.

What, he asks suspiciously, is the both that you have figured out a way to do.

Roy Lambert

Roy,

<< What, he asks suspiciously, is the both that you have figured out a way
to do. >>

Allow for a Clear=NULL and a Set to ''=NOT NULL.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim

>Allow for a Clear=NULL and a Set to ''=NOT NULL.

Arrggghh

Just when I thought things were going my way a bit.

Roy Lambert

Roy,

<< Just when I thought things were going my way a bit. >>

Right is right.  If someone modifies a BLOB column without using Clear, then
the result should be that the column is not NULL.

--
Tim Young
Elevate Software
www.elevatesoft.com