Jason:

Any sample code on how to use IB_LogFiles with
IB_Monitor.OnMonitorOutput? It is not that self-evident to me.

Thanks,

Chuck

> The regression testing app is part of IBO 5. Sorry to mislead you.
> The TIB_Monitor component just gives you an event that dumps out a string.
> Stuff the string wherever you want to. That log file component probably
> would work or just look in the IBO source for IB_LogFile.pas and make use of
> mine.
>
> Jason
>
>
> -----Original Message-----
> From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On Behalf
> Of Chuck Belanger
> Sent: 05 December 2012 01:32 PM
> To: IBObjects@yahoogroups.com
> Subject: Re: [IBO] Real Stumper of an error, Please help.--Jason
>
> Thanks, Jason:
>
> I found at Torrey site: TLogFile. Is that the component you mentioned?
>
> Also, I cannot find the Regression Testing Application you mention both
> here and on your site for 4.9. Not in Samples folder nor Addons.
>
> Could you confirm and point to the Application so I can see how to add
> logging to the IB_Monitor?
>
> Thanks
> Chuck
>> It may help to speed things up to set the MonitorGroup mgRows off. This
> way
>> you won't be tracing the record fetches.
>>
>> Jason
>>
>>
>> -----Original Message-----
>> From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On
> Behalf
>> Of Chuck Belanger
>> Sent: 04 December 2012 02:21 PM
>> To: IBObjects@yahoogroups.com
>> Subject: Re: [IBO] Real Stumper of an error, Please help.
>>
>> Cool.
>> I am running it now to the point all this happens and will start the SQL
>> monitor.
>>
>> Any special switches I might consider?
>>
>> I am saving it to a log file so maybe we can review the output.
>>
>> BTW, tried to simply delete that specific record and the program just
>> went on to the next record and got the same error. The first 5 records
>> have no error.
>>
>> 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
>>>
>>>
>>
>> ------------------------------------
>>
>>
> ___________________________________________________________________________
>> 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
>
>
>
>
>
> ------------------------------------
>
> ___________________________________________________________________________
> 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
>
>
>
>