Chuck,

Yes, I am.

Yes, it does.

Jason

-----Original Message-----
From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On Behalf
Of Chuck Belanger
Sent: 04 December 2012 12:55 PM
To: IBObjects@yahoogroups.com
Subject: Re: [IBO] Real Stumper of an error, Please help.

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
situation?

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.

Chuck

> 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: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] 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.
>

___________________________________________________________________________

> http://www.ibobjects.com - your IBO community resource for Tech Info

papers,

> keyword-searchable FAQ, community code contributions and more !

Yahoo! Groups Links

>
>
>
>

------------------------------------

___________________________________________________________________________
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