Subject Re: [IBO] Real Stumper of an error, Please help.
Author Chuck Belanger
Are you talking about the SQL Monitor that we added to the project?

Does this work in a Dataset.Edit; Field.Value := Field.Value; then POST

Like I said, I actually traced this code and looped through all the
fields that were being edited for that record. There is no single edit,
but a series depending on whether the field in question is part of a
list of field names that should be updated for the table. Nothing out of
the ordinary. The code is old and full of fairly complex logic that I do
not want to rewrite at this point to use an UPDATE statement.

> Did you look at the IBO generated SQL trace?
> This should tell you exactly what statement was being executed and with what
> exact values being sent to the server.
> Jason
> -----Original Message-----
> From: [] On Behalf
> Of Chuck Belanger
> Sent: 04 December 2012 11:55 AM
> To: IBObjects Listserve
> Subject: [IBO] Real Stumper of an error, Please help.
> 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