Hi
I am looking for a function which are able to add values from a table as
records are fetched.
Something like this:
Value Calculated value
1 1
2 3
3 6
4 10
5 15
The calculated value is just the sum of all previous values of VALUE.
Whats the name of such function in engli
Hello Michael,
> I am looking for a function which are able to add values from a table as
> records are fetched.
Cumulative sum?
> Something like this:
>
>
> ValueCalculated value
>
> 11
>
> 23
>
> 36
>
> 410
>
> 515
>
> The calculated value is just the sum of all previous values of VALUE.
>
>
>
Thanks :)
All I was looking for
Mivi
On 23/01/2015 10:25, michael.vilhelm...@microcom.dk [firebird-support]
wrote:
Hi
I am looking for a function which are able to add values from a table
as records are fetched.
Something like this:
ValueCalculated value
11
23
36
410
515
The calculated value is just the sum of all prev
Dear Svein and Dimitry,
thank you for both of your answers! That's really interesting.
I am in a quite hurry right now. Svein, I Like your approach and I will give it
a try next week! The complete SP is about 500 lines for the query because it
contains business rules interms of dates and rates o
Hm, maybe I am doing something wrong, but
- I open 2 instances of ISQL.EXE
- In ISQL1 I write: SELECT * FROM CLIENTS;
- In ISQL2 I write: SELECT MON$TIMESTAMP, MON$TRANSACTION_ID FROM
MON$STATEMENTS;
- In ISQL1 I write: COMMIT;
- In ISQL2 I write: SELECT MON$TIMESTAMP, MON$TRANSACTION_
I have an old VM that was developed in 2003 and last used in 2008. I am not
able to boot the VM but I am able to get files out of it. I have a database
extension .gdb for the data file.
I also have archived installers on the VM, most notably
Firebird-1.5.4.4910-0-Win32.exe which I believe was t
23.01.2015 15:30, masb...@za-management.com wrote:
>
> Dimitry, why is it so that for every outer join the inner part is always
> re-evaluated?
Because there are no alternative algorithms for outer joins in Firebird
(yet).
> And if I switch to an inner join, this could be avoided?
Yes, it could
64-bit Classic, Superclassic & Superserver July 17, 2014
Firebird-2.5.3.26778_0_x64.exe
http://sourceforge.net/projects/firebird/files/firebird-win64/2.5.3-Release/Firebird-2.5.3.26778_0_x64.exe/download
10 MB Windows executable installer for full Superclassic/Classic or
Superserver, recommende
Looks like some parts of the site refer to the old download page. The 2.5.3
downloads have been removed in favour of 2.5.3 update 1, check
http://www.firebirdsql.org/en/firebird-2-5-3-upd1/ for correct links.
Mark
- Reply message -
Van: "c...@hower.org [firebird-support]"
Aan:
Onderwer
Installed (yesterday) from iso Fedora 21 Workstation (Gnome dt), 64 bit,
and used YUM Extn to update all packages. Subsequently installed
Firebird RPMs (no configuration options were offered in the RPM
install):
firebird v.2.52.26539.0-14 x86_64
firebird-classic (same vers and arch for all)
fire
Installed 2.5.x x64 - Invalid DB. So I installed the old 1.5.x x86 and am able
to read the DB now.
You can export the data using gbak and then import to a 2.5.
On Friday, 23 January 2015, c...@hower.org [firebird-support] <
firebird-support@yahoogroups.com> wrote:
>
>
> Installed 2.5.x x64 - Invalid DB. So I installed the old 1.5.x x86 and am
> able to read the DB now.
>
>
13 matches
Mail list logo