Subject Re: [IBO] Probably a stupid question
Author Helen Borrie
At 02:08 PM 14/12/2004 +1300, you wrote:

>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,.......) ' +
>:CONTROLREF, :TRANSDATE, .......); ';

Prepare; // !!!!!!! Otherwise IBO doesn't know about the metadata.

>// 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