ABOUT BLOBFIELD & PARAMTERS

vga · Post by **vga** » Sat 08 Jul 2006 12:09

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)

Antaeus · Post by **Antaeus** » Mon 10 Jul 2006 11:37

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

vga · Post by **vga** » Sun 16 Jul 2006 03:47

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.'

Antaeus · Post by **Antaeus** » Mon 17 Jul 2006 08:28

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

vga · Post by **vga** » Wed 19 Jul 2006 11:41

thanks

it's ok!