03.09.2014 09:44, Macma wrote:
I found that after upgrade from FireBird 2.1.5 Update 1 to 2.1.6 my
query stop working with error Dynamic SQL Error SQL error code = -104
Invalid expression in the select list (not contained in either an
aggregate function or the GROUP BY clause). The same error
Hi,
I found that after upgrade from FireBird 2.1.5 Update 1 to 2.1.6 my
query stop working with error Dynamic SQL Error SQL error code = -104
Invalid expression in the select list (not contained in either an
aggregate function or the GROUP BY clause). The same error occur on 2.5.3
select
W dniu 2014-09-03 o 08:31, Dmitry Yemanov dim...@users.sourceforge.net
[firebird-support] pisze:
03.09.2014 09:44, Macma wrote:
I found that after upgrade from FireBird 2.1.5 Update 1 to 2.1.6 my
query stop working with error Dynamic SQL Error SQL error code = -104
Invalid expression in the
W dniu 2014-09-03 o 08:51, Svein Erling Tysvær
svein.erling.tysv...@kreftregisteret.no [firebird-support] pisze:
Hi,
I found that after upgrade from FireBird 2.1.5 Update 1 to 2.1.6 my
query stop working with error Dynamic SQL Error SQL error code = -104
Invalid expression in the select
On Wed, 03 Sep 2014 10:31:46 +0400, Dmitry Yemanov
dim...@users.sourceforge.net [firebird-support]
firebird-support@yahoogroups.com wrote:
03.09.2014 09:44, Macma wrote:
I found that after upgrade from FireBird 2.1.5 Update 1 to 2.1.6 my
query stop working with error Dynamic SQL Error SQL
I've got a query like:
SELECT ... FROM TBL WHERE COALESCE( FIELD1, FIELD2 ) = 12345
where FIELD2 is the primary key and FIELD1 also has an index (in fact
it's a foreign key back to FIELD2). This results in a table scan.
However expanding the COALESCE by hand:
SELECT ... FROM TBL WHERE (
Joel,
Although I would like to use UTF-8, my application uses several functions
that only work with single byte ASCII characters.
Sorry for responding so late, my group messages are going into the spam
folder for some reason.
On Mon, Aug 25, 2014 at 11:16 AM, Joel do Prado Junior
Hi,
I overcome this issue with this query
select
ke.I_ID_GRUPY,
ke.C_SYMBOL,
(
select first 1 cs.C_OPIS from T_CENY_SKLADNIKI as cs
left join T_CENY_W_OKRESIE as cwo on (cwo.I_ID_CENY_OKRS =
cs.I_ID_CENY_OKRS)
where cs.C_SYMBOL = ke.C_SYMBOL and cwo.I_ID_CENNIKA = any (select
With the help of FreeBSD port maintainer Kurt Jaeger, I managed to successfully
install Firebird 2.5.3 on FreeBSD 10. The updated port will shortly be released
to the FreeBSD ports collection
(http://www.freshports.org/databases/firebird25-server