Store empty data (not NULL) to TBlobField

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Ludek
Posts: 301
Joined: Thu 12 Oct 2006 09:34

Store empty data (not NULL) to TBlobField

Post by Ludek » Fri 02 Aug 2013 13:00

Hello, i do I store empty data in a database using SDAC & TBlobField?
so that the db field gets the same contents as after

update table set imagefield = ''

select table must then return just

0x

I tried:
.Clear, .LoadFromStream with empty stream, AsString := '', .asvariant := varArrayOf([])

without any success. everything produces NULL instead of 0x.

What is the right way to store the required value to a TBlobField?

Thanks, Ludek.

AndreyZ

Re: Store empty data (not NULL) to TBlobField

Post by AndreyZ » Mon 05 Aug 2013 08:43

Hello,

We know about this problem. We will try to fix this problem in one of the next SDAC builds.

Post Reply