TIBCLOADER PutColumnData empty blob

Discussion of open issues, suggestions and bugs regarding IBDAC (InterBase Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Alexis
Posts: 2
Joined: Mon 22 Sep 2014 09:35

TIBCLOADER PutColumnData empty blob

Post by Alexis » Mon 22 Sep 2014 10:12

Hello,

I have a problem with the method PutColumnData of TIBCLoader component.
I want to insert a empty blob and not a null blob but i can't, it always insert a null value in my blob field.
Does it exist a option like the TIBCDataSetOptions.SetEmptyStrToNull for the TIBCLoader ?

This insert a null value : Sender.PutColumnData(0, 0, '');

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: TIBCLOADER PutColumnData empty blob

Post by ViktorV » Mon 22 Sep 2014 11:37

Unfortunately, we cannot implement this functionality, since Delphi considers a Blob field as null.
You can make this sure, for example, by taking a look at implementation of the TBlobField.GetIsNull function in the Data.DB.pas standard Delphi module.

Alexis
Posts: 2
Joined: Mon 22 Sep 2014 09:35

Re: TIBCLOADER PutColumnData empty blob

Post by Alexis » Mon 22 Sep 2014 13:36

Thank you for this quickly response.

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: TIBCLOADER PutColumnData empty blob

Post by ViktorV » Fri 26 Sep 2014 06:27

Feel free to contact us if you have any further questions.

Post Reply