Dear All,
We face the problem with longblob field, that cannot be saved/update by unidac with error message "Data Type not supported".
here the snap of code:
QBiodata := TUniQuery.Create(Self);
QBiodata.Connection := MainForm.DBConn1;
QBiodata.SQL.Clear;
QBiodata.SQL.Text := 'Update m_biodata set foto = :p_foto where EID = ' + quotedStr(cxTextEdit1.Text);
if cxImage1.Picture.Graphic nil then
QBiodata.ParamByName('p_foto').Assign(cxImage1.Picture.Graphic)
else QBiodata.ParamByName('p_foto').Value := NULL;
QBiodata.Execute;
The error pointed at:
QBiodata.ParamByName('p_foto').Assign(cxImage1.Picture.Graphic)
with message: "Data Type not supported"
How to resolve this problem.
Thank you