UniTable return error must have the value

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
soyjoy
Posts: 13
Joined: Fri 09 Oct 2015 13:41

UniTable return error must have the value

Post by soyjoy » Wed 14 Oct 2015 17:26

My dear , when you insert a record with Unitable on a table with primarykey , I got the following error: Field ID must have the value .
In IBTable I can tell IndexDefs , Name = ' pk_table '
Fields = ' FD_ID '
Options = [ ixUnique ]
How to do it with UniTable ?
Thankful since already .

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

Re: UniTable return error must have the value

Post by AlexP » Thu 15 Oct 2015 08:57

Hello,

To resolve the issue, you should set the UniQuery1.Options.RequiredFields property to False. In addition, if you have created persistent fields, then set the Required property of the need field to False

soyjoy
Posts: 13
Joined: Fri 09 Oct 2015 13:41

Re: UniTable return error must have the value

Post by soyjoy » Thu 15 Oct 2015 19:31

Thanks for the help , I will test and return to tell if it worked.

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

Re: UniTable return error must have the value

Post by AlexP » Fri 16 Oct 2015 10:39

If this solution doesn't help, please contact us again.

soyjoy
Posts: 13
Joined: Fri 09 Oct 2015 13:41

Re: UniTable return error must have the value

Post by soyjoy » Fri 16 Oct 2015 20:53

Hello,
Based on what informed me , I researched the component and decided as follows:
TUniTable > UniTable Editor > Options
> Provider: Interbase ;
GeneratorMode = gmInsert
KeyGenerator = ID_MY_TABLE


It worked perfectly.
Thank you very much for your support.

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

Re: UniTable return error must have the value

Post by AlexP » Mon 19 Oct 2015 04:17

Glad to see that you have found the solution. If you have any other questions, feel free to contact us.

Post Reply