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