Lazarus
Home
Help
TinyPortal
Search
Login
Register
Lazarus
»
Forum
»
Programming
»
Databases
»
Firebird 4 - "SUM" with where clause
Free Pascal
Website
Downloads
Wiki
Documentation
Bugtracker
Mailing List
Lazarus
Website
Downloads (Laz+FPC)
Packages (OPM)
FAQ
Wiki
Documentation (RTL/FCL/LCL)
Bugtracker
CCR Bugs
IRC channel
GIT
Mailing List
Other languages
Foundation
Website
Useful Wiki Links
Project Roadmap
Getting the Source
Screenshots
How to use the forum
About donations (wiki)
Bookstore
Computer Math and Games in Pascal
(preview)
Lazarus Handbook
Search
Advanced search
Recent
JEDI error but unit compi...
by
DomingoGP
[
Today
at 08:28:17 am]
Configure JCF messages
by
DomingoGP
[
Today
at 08:19:10 am]
Any upgrades to fpWeb pag...
by
AlexTP
[
Today
at 08:10:55 am]
Zeos components. Had to c...
by
dbannon
[
Today
at 07:26:11 am]
IDE instability on Raspbe...
by
rvk
[
Today
at 07:08:49 am]
A button require administ...
by
Fibonacci
[
Today
at 05:57:21 am]
Using KeyPress event, how...
by
Joanna
[
Today
at 03:07:47 am]
How to detect one externa...
by
d2010
[
Today
at 12:24:32 am]
Center Lost Window featur...
by
Tony Stone
[
Today
at 12:06:16 am]
Complex package installat...
by
wp
[March 27, 2024, 10:47:45 pm]
Controlling the behavior ...
by
wp
[March 27, 2024, 10:43:40 pm]
A "leisure" question on W...
by
EventHorizon
[March 27, 2024, 10:18:38 pm]
need advice about the fol...
by
jamie
[March 27, 2024, 09:56:39 pm]
[SOLVED] Completion box s...
by
Martin_fr
[March 27, 2024, 08:44:09 pm]
Dialog ShowModal and an i...
by
d7_2_laz
[March 27, 2024, 08:25:18 pm]
Offical launch of the 1 B...
by
Gustavo 'Gus' Carreno
[March 27, 2024, 07:41:48 pm]
Your best UI design - con...
by
hrayon
[March 27, 2024, 06:42:28 pm]
Understanding and adjusti...
by
ArchChem
[March 27, 2024, 06:04:25 pm]
Problem setting length of...
by
Remy Lebeau
[March 27, 2024, 05:41:10 pm]
TDBLookupcombobox seems u...
by
Fantablup
[March 27, 2024, 05:18:04 pm]
Poll: Watches and Display...
by
Martin_fr
[March 27, 2024, 03:58:57 pm]
STAR ...Zzzz
by
Boleeman
[March 27, 2024, 02:37:39 pm]
Help needed with Cairo / ...
by
AL
[March 27, 2024, 02:35:10 pm]
I encountered onDatachang...
by
Fantablup
[March 27, 2024, 02:34:08 pm]
Code folding tree — highl...
by
Martin_fr
[March 27, 2024, 01:58:19 pm]
« previous
next »
Print
Pages:
1
[
2
]
Author
Topic: Firebird 4 - "SUM" with where clause (Read 1827 times)
Nicole
Hero Member
Posts: 970
[solved] Re: Firebird 4 - "SUM" with where clause
«
Reply #15 on:
March 24, 2023, 07:32:08 pm »
this figures exactly what I want.
Thank you so much, you are my hero
Logged
rvk
Hero Member
Posts: 6109
Re: Firebird 4 - "SUM" with where clause
«
Reply #16 on:
March 24, 2023, 07:51:49 pm »
BTW This also counts the amounts of records before the Entry_Date in the sum().
If that's not wanted you also need to include that one in the where of the sub select
Logged
Nicole
Hero Member
Posts: 970
Re: Firebird 4 - "SUM" with where clause
«
Reply #17 on:
March 25, 2023, 06:34:27 pm »
this is an extremely useful feature, not a bug.
But I spoiled something.
If you have time, it would be great, if you can read my very last posting.
Logged
Print
Pages:
1
[
2
]
« previous
next »
Lazarus
»
Forum
»
Programming
»
Databases
»
Firebird 4 - "SUM" with where clause
TinyPortal
© 2005-2018