Page 1 of 1

Image field in SQL Server Compact

Posted: Tue 25 Sep 2012 15:51
by Halley732
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

Re: Image field in SQL Server Compact

Posted: Wed 26 Sep 2012 13:05
by AlexP
hello,

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

Code: Select all

  UniQuery1.Options.RequiredFields := true;

Re: Image field in SQL Server Compact

Posted: Wed 26 Sep 2012 13:27
by Halley732
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

Re: Image field in SQL Server Compact

Posted: Wed 26 Sep 2012 13:55
by AlexP
hello,

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

Re: Image field in SQL Server Compact

Posted: Wed 26 Sep 2012 14:55
by Halley732
Ah, ok :)

Thanks