Unidac uniQuery component does not return keygenerator value

Asked

Viewed 286 times

1

I’m having trouble inserting into Firebird using Devart’s uniQuery (Delphi 7 with Unidac) component. The primary key field is in the query fieds and the component configuration is like this:

CAMPO_ID : 
ProviderFlags > pfKey > True
Required > False

Query:
Options > RequiredFields > False
UniQuery Editor > Options > Provider Interbase > GeneratorMode > gmInsert
UniQuery Editor > Options > Provider Interbase > KeyGenerator > Meu_sequence 

Even with this setting, an error occurs while trying to write.

Error: violates foreign key constraint

With right uniTable, but I need it to be with a uniQuery.

No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.