Thanks Jason

Just tried changing the following settings (one at a time)

IBODatabase1.DefaultNoTrimming
IBODatabase1.DefaultNoTrailing
IBODatabase1.DefaultNoLengthCheck


Each of the above made no difference, I still get an overflow
exception. Might DefaultNoTrimming setting might be broken?

Thanks
Rob

On 9/10/2013 10:35 a.m., IBO Support List wrote:
> 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
>
>
>
>
>
> ------------------------------------
>
> ___________________________________________________________________________
> 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
>
>
>
>
>
> -----
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 2013.0.3408 / Virus Database: 3222/6730 - Release Date: 10/07/13
>
>