I'm having trouble inserting into Firebird using Devart's uniQuery component (Delphi 7 with Unidac). The field that is the primary key is in the fieds of the query and the configuration of the component 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 record.
Error: Violates foreign key constraint
With uniTable sure, but I need it to be with a uniQuery.