next one, again on the server side. I have a SQL statement that returns some VARCHARs fields (including the primary key as first field, which is a GUID), and a BLOB field. And I have a TDataSet with the according columns.
No problem with the VARCHARs, but how can I get the content of the BLOB? DataSet.Column['Data'].AsBlob returns an empty stream.
So I read the manual and wrote a SelectData SQL command. It is very simple: SELECT Data FROM Archiv WHERE ID=:ID. No idea how EWB knows that it has to use the ID field, no idea how it get the parameter. But that command is not executed, I tested it with a buggy SQL command.
Did anyone successfully access a BLOB field in server code, and if yes, how?