Would love to, my client is pressuring me !

I have Skype on, skype me when you are ready :)

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