Thanks, Rob

But NO TRIGGER, no logging table, et al.

Any other ideas?

Chuck

> Hi
>
> My guess is there is a trigger on the table being edited and it is
> inserting a record into a logging (or other) table which does have a PK.
>
> Cheers
> Rob
>
> On 5/12/2012 7:55 a.m., Chuck Belanger wrote:
>> Hello:
>>
>> Using Delphi XE2, Win7-64, IBO 5.2 (latest update from Jason)
>>
>> I am using two IB_Queries to move data between two identical tables from
>> two DBs. It is a part of an DB update routine which updates/adds new
>> data from a master DB that is distributed to numerous users. It is a
>> desktop application used in clinics. Not all clinics are hooked up to
>> the internet, so forget the idea of using an internet based solution :)
>> Plus, the patient data HIPPA issues.
>>
>> I am getting the following error:
>> "Violation of PK pk_cv_table_columns on table CV_Table_Columns"
>>
>> Here's the stumper:
>>
>> This is on a post of a series of individual field edits. No Append, no
>> insert.
>> The fields actually edited do not include the PK, CV_Column_ID.
>> The process works fine on other records of the same exact structure
>> included in the dataset and in many cases the same exact data (because
>> the data can be repetitive).
>> I have looked at the data in a trace and in IBExpert browser. Nothing
>> looks amiss.
>> In fact, the edit update, is not actually changing any data for this
>> specific record, i.e. the field data is identical for both tables being
>> pumped/updated. I have looked at the field values during a trace.
>> This error comes up for this exact same record being edited across more
>> than one DB.
>>
>> This is part of a very large routine to update users' DB and is stopping
>> the entire process from finishing.
>>
>> I would appreciate any help or direction on what to look at.
>>
>> Thank you!
>> Chuck Belanger
>>
>>
>>
>>
>> ------------------------------------
>>
>> ___________________________________________________________________________
>> 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
>>
>>
>>
>>
>>
>> -----
>> No virus found in this message.
>> Checked by AVG - www.avg.com
>> Version: 2012.0.2221 / Virus Database: 2634/5436 - Release Date: 12/04/12
>>
>>
>
>
> ------------------------------------
>
> ___________________________________________________________________________
> 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
>
>
>
>