Thank you for your reply.
Be informed that we were able to reproduce the error using your sample and investigated it.
In the example provided, when using the Insert query, the IDE cannot automatically determine the type of the Value parameter when assigned. This results in a data conversion error.
Please note that when working with Blob fields, it is recommended to use Assign.
For example:
Code: Select all
qryPg.ParamByName ('immagine'). Assign (tblTemp.FieldByName ('immagine'));
https://www.devart.com/unidac/docs/deva ... tblob).htm
You can also specify the explicitly type of the parameter when assigning:
Code: Select all
qryPg.ParamByName ('immagine').AsBlob: = tblTemp.FieldByName ('immagine'). Value;
Code: Select all
qryPg.ParamByName ('immagine').DataType: = ftBlob;
qryPg.ParamByName ('immagine').Value: = tblTemp.FieldByName ('immagine'). Value;
Regards,
Evgeniy