Hi All

This is probably a stupid question but. I have the following SQL that fails
on execute with a primary key violation. Code snip follows.....


UpdateQuery.GeneratorLinks.Add('WORKREF=WORKFILES_GEN');
UpdateQuery.SQL.Text := 'INSERT INTO WorkGlTrans ' +
'(WORKREF, CONTROLREF,
TRANSDATE,.......) ' +
'VALUES (:WORKREF,
:CONTROLREF, :TRANSDATE, .......); ';
// Set params (except workref)
.....

UpdateQuery.Exec;

WorkRef is the PK for this table. UpdateQuery is an instance of an IBOQuery
that is created in code.

I have persistant IBOQuerys that have similar SQL and settings, they run
fine. What have I missed here?

Confused and feeling stupid :)

Rob Martin
Software Engineer

phone +64 03 377 0495
fax +64 03 377 0496
web www.chreos.com
Wild Software Ltd