Blob Insert into Firebird using Devart
Posted: Wed 19 Oct 2011 13:30
Can anyone please point me to a code example of how to insert a blob into a table, without using TClientDataset, for Delphi or C++Builder using DBX and Devart? I am using C++ Builder XE.
The table is huge, so an intermediate TClientDataset memory resident copy of the entire table is not possible. I looked for ways to limit the size of the memory resident copy to the last few rows, I am sure there must be a mechanism, but I couldn't figure it out.
I presume that I need to create a TBlobStream and assign it to a parameter of a TSQLQuery? I can do it with an INSERT statement for integer types, but am having difficulty with the blob data.
The table is huge, so an intermediate TClientDataset memory resident copy of the entire table is not possible. I looked for ways to limit the size of the memory resident copy to the last few rows, I am sure there must be a mechanism, but I couldn't figure it out.
I presume that I need to create a TBlobStream and assign it to a parameter of a TSQLQuery? I can do it with an INSERT statement for integer types, but am having difficulty with the blob data.