Subject | RE: [IBO] Field overflow exception |
---|---|
Author | IBO Support List |
Post date | 2013-10-08T21:35:57Z |
Yes, there is a setting at the connection level you can make.
If my memory serves me well it is something like DefaulTrimming or something
like that.
Jason
-----Original Message-----
From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On Behalf
Of Robert Martin
Sent: Tuesday, October 8, 2013 2:59 PM
To: IBObjects@yahoogroups.com
Subject: [IBO] Field overflow exception
Hi
In IBO 4.8.7 when code tried to add more text then a field could hold
the extra text was cropped and processing continued
i.e. 'My test text' into a varChar(10) resulted in 'My test te'.
In 5.2.x this sort of thing results in an exception being raised. This
is great for spotting data sizing issues and numeric overflows and can
easily be resolved by increasing field size or truncating data in code
using Copy().
This does have a major downfall though, in 4.8.7, increasing the DB
field size was automatically handled by both code and data aware
controls, if you put Copy() into code to prevent exceptions you break
the ability to extend storage size by simply modifying the database.
Any field change then also requires coding changes.
So my question is their a 'flag' in IBO that can be used to turn the old
functionality back on. We would like to use the new functionality for
testing but on release we would want the old functionality !
Cheers
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 upgradeYahoo!
Groups Links
If my memory serves me well it is something like DefaulTrimming or something
like that.
Jason
-----Original Message-----
From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On Behalf
Of Robert Martin
Sent: Tuesday, October 8, 2013 2:59 PM
To: IBObjects@yahoogroups.com
Subject: [IBO] Field overflow exception
Hi
In IBO 4.8.7 when code tried to add more text then a field could hold
the extra text was cropped and processing continued
i.e. 'My test text' into a varChar(10) resulted in 'My test te'.
In 5.2.x this sort of thing results in an exception being raised. This
is great for spotting data sizing issues and numeric overflows and can
easily be resolved by increasing field size or truncating data in code
using Copy().
This does have a major downfall though, in 4.8.7, increasing the DB
field size was automatically handled by both code and data aware
controls, if you put Copy() into code to prevent exceptions you break
the ability to extend storage size by simply modifying the database.
Any field change then also requires coding changes.
So my question is their a 'flag' in IBO that can be used to turn the old
functionality back on. We would like to use the new functionality for
testing but on release we would want the old functionality !
Cheers
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 upgradeYahoo!
Groups Links