Re: [Firebird-devel] arithmetic exception, numeric overflow, or string truncation after change column datatype and select from older format view

2016-11-22 Thread Leyne, Sean
> SQL> > SQL> select * from v; > > A > == > Statement failed, SQLSTATE = 22001 > arithmetic exception, numeric overflow, or string truncation -string right > truncation > SQL> > > > As you can see.. there is no error until the records are inserted or updated > with a value that the length i

[Firebird-devel] arithmetic exception, numeric overflow, or string truncation after change column datatype and select from older format view

2016-11-22 Thread Alexandre Benson Smith
Hi ! On previous versions of FB (2.1 and earlier) one could not change the column datatype if it has any dependencies (for example used on a view), you need to drop all the views and after that change the column datatype and recreate everything. Fortunatelly, on FB 2.5 we could change the data

Re: [Firebird-devel] Reliably Determining whether Engine12 is available as a Provider

2016-11-22 Thread Alex Peshkoff
On 11/22/16 20:01, Tony Whyman wrote: > On 22/11/16 16:56, Alex Peshkoff wrote: >> On 11/22/16 16:42, Tony Whyman wrote: >>> I am trying to find a way of determining whether Engine12 is available >>> as a provider when using the FIrebird 3 API. >>> >>> Enumerating the list of Providers in firebird.

Re: [Firebird-devel] Reliably Determining whether Engine12 is available as a Provider

2016-11-22 Thread Tony Whyman
On 22/11/16 16:56, Alex Peshkoff wrote: > On 11/22/16 16:42, Tony Whyman wrote: >> I am trying to find a way of determining whether Engine12 is available >> as a provider when using the FIrebird 3 API. >> >> Enumerating the list of Providers in firebird.conf tells you whether it >> has been configu

Re: [Firebird-devel] Reliably Determining whether Engine12 is available as a Provider

2016-11-22 Thread Alex Peshkoff
On 11/22/16 16:42, Tony Whyman wrote: > I am trying to find a way of determining whether Engine12 is available > as a provider when using the FIrebird 3 API. > > Enumerating the list of Providers in firebird.conf tells you whether it > has been configured but because the list is interpreted permiss

[Firebird-devel] Reliably Determining whether Engine12 is available as a Provider

2016-11-22 Thread Tony Whyman
I am trying to find a way of determining whether Engine12 is available as a provider when using the FIrebird 3 API. Enumerating the list of Providers in firebird.conf tells you whether it has been configured but because the list is interpreted permissively, all this tells you is that it might b