Submitted by: lango (lango)

SFID: 551007#⁠
Submitted By: lango

I created a function (using the delphi for that)
that formats values of the type it dates and a Pchar
comes back with the formatted value.

The function works perfectly in any select that I do
in the database, unless the select uses some function
native totalizadora of the database.
When I try to do a select below similar to the
example, I lose the connection with the database:
*-----------*
select
count (id_parcela), formatdate ('mmmm/yyyy',
dt_movimento) month_year
from
my_table
group by
formatdate ('mmmm/yyyy', dt_movimento)

*-----------*
id_parcela = integer
dt_movimento = date

I only receive the following message: " connection
lost to database "

That is a limitation of Interbase/FireBird or is a
bug really?

If it goes a limitation of Interbase/Firebird I
believe that the connection loss should not happen.