Devart Forums

Hello,

I have the following table,

CREATE TABLE "public"."sys_file" (
"file_id" SERIAL,
"file_name" VARCHAR(50) DEFAULT ''::character varying,
"file_body" BYTEA,
CONSTRAINT "sys_file_pkey" PRIMARY KEY("file_id")
) WITHOUT OIDS;

and 'Cannot convert type' error is occur when I try to update the bytea field like that:

myPgQuery.Edit;
TBlobField(myPgQuery.FieldByName('file_body')).LoadFromStream(myStream);
myPgQuery.Post;

Please help!

We could not reproduce the problem. Please send to support*devart*com a complete small sample that demonstrates the problem.

also: what fieldking is your field "'file_body'" in delphi? how that field is mapped? do you map it in code or automatically?

Sample is sent.

I map the field automatically.

Thank You!