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

Well, it has taken hours to run what normally takes about 5 minutes with
the SQL Monitor active. Everything appears to be getting slower and at
this pace it may take all night or longer.

What is the proper way to call the SQL monitor (and what settings do you
suggest) programmatically. That way I can get close to where the problem
is then launch the SQL monitor.

Thanks,

Chuck
> 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
>
>
>
>
>
> ------------------------------------
>
> ___________________________________________________________________________
> 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
>
>
>
>