---

 Comments

---

The reason that this cannot be fixed goes back to incident report #2509. Due to the way that the TBlobField class in Delphi implemented the Clear method, ElevateDB has to set any BLOB column to NULL when a TEDBBlobStream is opened with the bmWrite flag. However, the TBlobField.SetAsString method uses a stream to peform its writes also, and it will not actually write to the stream if the length of the string is zero. Therefore, ElevateDB has no way of knowing that the stream was written to, and leaves the BLOB column as NULL.

---

 Resolution

---

Cannot Fix Problem

---

 Products Affected

---

ElevateDB Additional Software and Utilities
ElevateDB VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial