> -----Original Message-----
> From: Robert martin [mailto:rob@...]
> Sent: Tuesday, December 14, 2004 12:08 PM
> To: IBObjects@yahoogroups.com
> Subject: [IBO] Probably a stupid question
>
>
>
> 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
>
>
>
>
>
> __________________________________________________________________
> _________
> IB Objects - direct, complete, custom connectivity to Firebird or
> InterBase
> without the need for BDE, ODBC or any other layer.
> __________________________________________________________________
> _________
> http://www.ibobjects.com - your IBO community resource for Tech
> Info papers,
> keyword-searchable FAQ, community code contributions and more !
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
>