Subject Probably a stupid question
Author Robert martin
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.SQL.Text := 'INSERT INTO WorkGlTrans ' +
TRANSDATE,.......) ' +
// Set params (except workref)


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
Wild Software Ltd