Thanks for your awesome help and quick support Jason.

It turned out it was nothing to do with IBO but was some sort of
database corruption with one of the fields (which didn't show in a viewer).

Cheers
Rob

On 25/07/2014 10:42 a.m., Robert Martin rob@... [IBObjects] wrote:
> Hi Jason
>
> Any time you are ready please email or Skype me and I will get you on to
> my machine. This is quite critical for my client as he needs to
> transfer products to his stores and cant do so until it is resolved.
>
> Cheers
> Rob
>
>
> On 24/07/2014 12:24 p.m., 'IBO Support List' supportlist@...
> [IBObjects] wrote:
>> Would you please be able to have me look at it remotely?
>>
>> Jason
>>
>>
>> -----Original Message-----
>> From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]
>> Sent: Wednesday, July 23, 2014 6:15 PM
>> To: IBObjects@yahoogroups.com
>> Subject: [IBO] Problem with Field truncation
>>
>> Hi Jason
>>
>> I have a client tool that has been in use for some time. Recently it
>> has come up with an overflow error. It was written in D2007 and IBO 4.9
>> something. I have converted it to XE2 and a newer version of IBO but the
>> issue is still present. I have tracked to to the following...
>>
>> 2 DBS, identical tables. PK is defined as Numeric(11)
>>
>> There is a select on ON dbs table to get data and a parameterised insert
>> query on the other DB.
>>
>> i.e.
>>
>> DB 1: SELECT Pk, field1 FROM tablea
>>
>> DB 2: INSERT INTO tablea (Pk, Field1) VALUES (:Pk, Field1).
>>
>> For a selected record where the value is 10078092 it get an overflow
>> error. Reducing the source value to 1 allows the record to go through.
>> It appears some internal IBO processing is mis detecting the field value.
>>
>> I urgently need to resolve this for my client, any suggestions?
>>
>> Thanks
>> Rob
>>
>>
>>
>>
>>
>> ------------------------------------
>> Posted by: Robert Martin <rob@...>
>> ------------------------------------
>>
>> ___________________________________________________________________________
>> 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 !
>> http://tracker.ibobjects.com - your portal to submit and monitor bug reports
>> http://community.ibobjects.com - your portal to purchase and upgrade
>> ------------------------------------
>>
>> Yahoo Groups Links
>>
>>
>>
>>
>>
>> ------------------------------------
>> Posted by: "IBO Support List" <supportlist@...>
>> ------------------------------------
>>
>> ___________________________________________________________________________
>> 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 !
>> http://tracker.ibobjects.com - your portal to submit and monitor bug reports
>> http://community.ibobjects.com - your portal to purchase and upgrade
>> ------------------------------------
>>
>> Yahoo Groups Links
>>
>>
>>
>>
>>
>> -----
>> No virus found in this message.
>> Checked by AVG - www.avg.com
>> Version: 2014.0.4716 / Virus Database: 3986/7906 - Release Date: 07/23/14
>>
>>
>
>
> ------------------------------------
> Posted by: Robert Martin <rob@...>
> ------------------------------------
>
> ___________________________________________________________________________
> 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 !
> http://tracker.ibobjects.com - your portal to submit and monitor bug reports
> http://community.ibobjects.com - your portal to purchase and upgrade
> ------------------------------------
>
> Yahoo Groups Links
>
>
>
>
>
> -----
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 2014.0.4716 / Virus Database: 3986/7913 - Release Date: 07/24/14
>
>