Devart Forums

if not OpenPictureDialog1.Execute then exit;

MyQuery1.SQL.Text :=
'insert into `job_table` (pic_image) values (:pic_image)';

MyQuery1.ParamByName('pic_image').LoadFromFile(OpenPictureDialog1.FileName, ftblob);

MyQuery1.Execute;

this does not work with mydac4.3 in delphi 10. what's wrong?

(it worked well with mydac 3.10 in delphi7)

Please specify what the result is if you execute presented code using Delphi 2006 (file is not loaded, error message appears etc.). Also supply us following information:
- Exact version of Delphi (including update packs)
- Exact version of MyDAC. You can see it in About sheet of TMyConnection Editor
- Exact version of MySQL server and MySQL client. You can see it in Info sheet of TMyConnection Editor

thanks.

mydac version, 4.30.0.10 for delphi 2006

mydac430d10.msi (3590144 byte ) delphi 2006 update 2 (10.0.2288.42451)


error msg: 'Data type is not supported.'

Try downloading current version of MyDAC from our site. It must solve the problem.

thanks

it's ok!