Subject Re: [firebird-support] Re: View output differs from straight SELECT output
Author Ismael L. Donis Garcia
Download from site official FirebirdCS-2.5.2.26536-0.RC1.i686.tar.gz or FirebirdCS-2.5.2.26536-0.RC1.amd64.tar.gz

Best Regards.
=========
|| ISMAEL ||
=========
PD: It works to me to perfection


----- Original Message -----
From: reinier_olislagers
To: firebird-support@yahoogroups.com
Sent: Tuesday, October 23, 2012 9:26 AM
Subject: [firebird-support] Re: View output differs from straight SELECT output



--- In firebird-support@yahoogroups.com, Thomas Steinmaurer <ts@...> wrote:
>
> > Firebird 2.5RC3 (Debian version) on Debian Squeeze
<snip>
> > I created a view with this SQL:
> > CREATE VIEW OKRESULTS (RUNID, OKCOUNT, OKPERCENTAGE)
<snip>
> > which gives output (in FlameRobin) like:
> > RUNID OKCOUNT OKPERCENTAGE
> > 8 5 [null]
> >
> > What am I doing wrong? Do I need to explicitly CAST the expression to
> > e.g. a float?
Hi Thomas,

Thanks.
> Looks a bit like:
> http://tracker.firebirdsql.org/browse/CORE-3141
Yes, it does... and it is fixed in FB embedded Windows 2.5.1
>
> Any reason why you are using a RC of 2.5.0?

It's the one distributed by Debian stable (6.0/Squeeze) - so it's a simple apt-get ;)
Looks like an upgrade may be a good idea ;)





[Non-text portions of this message have been removed]