Subject Re: [IBO] Real Stumper of an error, Please help.
Author Chuck Belanger

Here is some more information on this problem:

I GFIXed the import table, UpdateTV.fdb, and found no errors.
Likewise, GFIXed the user DB, ViewerDB.fdb and found no errors.

To make things clear I am simply getting a dataset and using NEXT to
increment through the record set while looking up the equivalent record
in the second query, then apply the field changes from one dataset to

Each table has its own PK ID, but to find the equivalent records in the
User DB, I use a combination of Original_PK + a user owner ID. This
allows for exact matching even if the records have different PK IDs.

I went to IBExpert and wanted to see if I could copy the record in
question to the clipboard as an UPDATE then actually update the record.
This worked fine on the user DB, but in IBExpert, the Copy to clipboard
as UPDATE was disabled/grayed on the import table (updateTV.fdb) for all
records. I tried closing the table then reopening it and even closing
IBExpert, nothing changed. The copy to Clipboard for INSERT or record,
etc, worked fine. Not sure what deactivated that menu item.

Right now, I am thinking I will simply delete this record and let the
update process readd it back and see what happens.

Any other suggestions?


Chuck Belanger
> 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.
> ___________________________________________________________________________
> - your IBO community resource for Tech Info papers,
> keyword-searchable FAQ, community code contributions and more ! Yahoo! Groups Links