Can not add image/binary data into SQL Server Compact table

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
jaska45
Posts: 28
Joined: Fri 23 Dec 2005 03:55

Can not add image/binary data into SQL Server Compact table

Post by jaska45 » Mon 30 May 2011 08:43

Hi

I have a SQLCE table that has an image field. When I try to add a new record

table.Append;
table.FieldByName('Id').AsInteger := i;
table.FieldByName('ImageRaw').AsBytes := BytesOf(image);
table.Post;

I get following error on table.Post

"Errors occurred. [,,,,,]"

This seems like a bug in UniDac.

I am using Delphi 2010, the newest UniDac and SQLCE 4.0

Best regards,
Jaakko

AndreyZ

Post by AndreyZ » Mon 30 May 2011 11:38

Hello,

We have already fixed this problem. This fix will be included in the next UniDAC build.

Post Reply