Store empty data (not NULL) to TBlobField
Posted: 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.
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.