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