Image field in SQL Server Compact

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Halley732
Posts: 4
Joined: Fri 21 Sep 2012 09:55

Image field in SQL Server Compact

Post by Halley732 » Tue 25 Sep 2012 15:51

Hi,
i'm trying UNIDac component in my XE2 application with SQL Server Compact 3.5.
I've a problem with a table with a non mandatory image field.
When i try to update tha table it give me an error 'Field fielname must have a value.

I've made anything wrong?

Thanks, Luca

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: Image field in SQL Server Compact

Post by AlexP » Wed 26 Sep 2012 13:05

hello,

To resolve the problem, you should set the RequiredFields property to True

Code: Select all

  UniQuery1.Options.RequiredFields := true;

Halley732
Posts: 4
Joined: Fri 21 Sep 2012 09:55

Re: Image field in SQL Server Compact

Post by Halley732 » Wed 26 Sep 2012 13:27

Hi Alex,
the Options.RequiredFields property is already set to True.
I attach a image of the table definition:

Image

When i update the table it give me an error 'Field fingerprint must have a value'

Thanks, Luca

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: Image field in SQL Server Compact

Post by AlexP » Wed 26 Sep 2012 13:55

hello,

Sorry for my misprints, you should set the RequiredFields property to FALSE

Halley732
Posts: 4
Joined: Fri 21 Sep 2012 09:55

Re: Image field in SQL Server Compact

Post by Halley732 » Wed 26 Sep 2012 14:55

Ah, ok :)

Thanks

Post Reply