How to use memory stream with asbcd.
lazarus / 16-Databases

----------------------------------------------------------------------
loaded · 2021-09-24 08:07

Hi All,
There is a database that I created using Postgresql, in this database;
Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i 'DOC
BYTEA,'I have a blob column that I have defined, in this column I
intend to store binary data to files.
Using opendialog, I transfer the file I selected to MemoryStream, then
the SQL query is set to the parameter value.

Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i  varfc,fof:
TMemoryStream;....DataModule1.ZQuery_CRecord.SQL.Clear;DataModule1.ZQu
ery_CRecord.SQL.Add(        ' UPDATE '+ table_name+ ' SET '+        '
DOC '+        '=:DOC WHERE ID=:ID;'        );        DataModule1.ZQuer
y_CRecord.Params.ParamByName('ID').AsString:=DataModule1.ZQuery_VZ.Fie
ldByName('id').AsString;        DataModule1.ZQuery_CRecord.Params.Para
mByName('DOC').LoadFromStream(fc,ftBlob);       
DataModule1.ZQuery_CRecord.ExecSQL;   
I transfer it in the form and save it in the relevant database. No
problem, I'm coming here.

But by making a change; This process is not with the sql query, but
directly in the field of the sql query;
I want to transfer the memory stream to the Code: Pascal
 [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i
ZQuery.FieldByName('DOC').AsBCD:=how to use fc; feature, is it
possible?
I would be very grateful if you could help. Regards.