Lazarus
Home
Help
TinyPortal
Search
Login
Register
Lazarus
»
Forum
»
Programming
»
Databases
»
[SOLVED] SQLite Sum()
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
Free AI to use in local
by
BSaidus
[
Today
at 10:03:59 am]
Controlling the behavior ...
by
rvk
[
Today
at 08:31:48 am]
A "leisure" question on W...
by
Awkward
[
Today
at 07:59:12 am]
Big Numbers Math
by
Thaddy
[
Today
at 07:22:49 am]
how to change the color f...
by
Thaddy
[
Today
at 07:14:33 am]
Parquet?
by
Thaddy
[
Today
at 07:11:17 am]
STARS and Regular POLYGON...
by
Boleeman
[
Today
at 06:41:41 am]
Offical launch of the 1 B...
by
Gustavo 'Gus' Carreno
[
Today
at 05:53:09 am]
Project fails on run but ...
by
jamie
[
Today
at 12:54:49 am]
Curling Pythagoras Tree: ...
by
Boleeman
[
Today
at 12:00:37 am]
Ribbon bar in Lazarus 3.2...
by
wp
[March 28, 2024, 11:29:17 pm]
how to search in rxmemory...
by
rcmz
[March 28, 2024, 10:19:54 pm]
Configure JCF messages
by
GordonFindlay
[March 28, 2024, 10:16:19 pm]
Poll: Watches and Display...
by
Martin_fr
[March 28, 2024, 10:15:08 pm]
Dialog ShowModal and an i...
by
d7_2_laz
[March 28, 2024, 09:51:39 pm]
JEDI error but unit compi...
by
Thaddy
[March 28, 2024, 09:30:33 pm]
Understanding and adjusti...
by
circular
[March 28, 2024, 09:09:56 pm]
Dynarray initialization p...
by
Thaddy
[March 28, 2024, 06:30:12 pm]
Zeos components. Had to c...
by
Fantablup
[March 28, 2024, 04:17:13 pm]
[SOLVED] Completion box s...
by
furious programming
[March 28, 2024, 04:12:26 pm]
[LAMW] How to create a ca...
by
af0815
[March 28, 2024, 03:48:16 pm]
Complex package installat...
by
wp
[March 28, 2024, 03:38:16 pm]
[SOLVED] Combined pointer...
by
CM630
[March 28, 2024, 02:48:41 pm]
Using KeyPress event, how...
by
Zvoni
[March 28, 2024, 02:24:42 pm]
a Unit problem?
by
Thaddy
[March 28, 2024, 01:56:12 pm]
« previous
next »
Print
Pages: [
1
]
Author
Topic: [SOLVED] SQLite Sum() (Read 758 times)
Pe3s
Hero Member
Posts: 533
[SOLVED] SQLite Sum()
«
on:
November 23, 2022, 05:48:04 pm »
Hello, I have a question if it is possible to display the result of the summation in a control other than dbgrid?
Code: Pascal
[Select]
[+]
[-]
procedure
TForm1
.
Button10Click
(
Sender
:
TObject
)
;
begin
ZQuery1
.
SQL
.
Clear
;
ZQuery1
.
SQL
.
Text
:
=
'SELECT SUM(amount) FROM product'
;
ZQuery1
.
Open
;
end
;
«
Last Edit: November 24, 2022, 04:28:29 pm by Pe3s
»
Logged
Thaddy
Hero Member
Posts: 14210
Probably until I exterminate Putin.
Re: SQLite Sum()
«
Reply #1 on:
November 23, 2022, 06:39:24 pm »
In any text based control, like a memo or even a caption.
(And plz do not use Zeos, use what Freepascal has a default. Zeos is a pain debugging and never has been fit for purpose)
«
Last Edit: November 23, 2022, 06:48:23 pm by Thaddy
»
Logged
Specialize a type, not a var.
Pe3s
Hero Member
Posts: 533
Re: SQLite Sum()
«
Reply #2 on:
November 23, 2022, 07:17:16 pm »
But when I execute this code it still displays in dbgrid
Logged
Pe3s
Hero Member
Posts: 533
Re: SQLite Sum()
«
Reply #3 on:
November 23, 2022, 08:21:36 pm »
What do I need to change in the code to make it add up the time?
Code: Pascal
[Select]
[+]
[-]
procedure
TForm1
.
Button10Click
(
Sender
:
TObject
)
;
var
bm
:
TBookmark
;
Total
:
Integer
;
begin
bm
:
=
ZQuery1
.
GetBookmark
;
ZQuery1
.
DisableControls
;
try
Total
:
=
0
;
ZQuery1
.
First
;
while
not
ZQuery1
.
Eof
do
begin
Total
:
=
Total
+
ZQuery1
.
FieldByName
(
'Wiek'
)
.
AsInteger
;
ZQuery1
.
Next
;
end
;
Form1
.
Caption
:
=
IntToStr
(
Total
)
;
finally
ZQuery1
.
GotoBookmark
(
bm
)
;
ZQuery1
.
EnableControls
;
end
;
end
;
Logged
paweld
Hero Member
Posts: 970
Re: SQLite Sum()
«
Reply #4 on:
November 23, 2022, 09:09:24 pm »
This is probably because you are using a only one a TZQuery component in the application, which is connected to the grid via datasource.
Place another ZQuery component on the form, such as ZQuery2
Code: Pascal
[Select]
[+]
[-]
procedure
TForm1
.
Button10Click
(
Sender
:
TObject
)
;
begin
ZQuery2
.
SQL
.
Clear
;
ZQuery2
.
SQL
.
Text
:
=
'SELECT SUM(wiek) suma_lat FROM pracownik'
;
ZQuery2
.
Open
;
try
Form1
.
Caption
:
=
ZQuery2
.
FieldByName
(
'suma_lat'
)
.
AsString
;
finally
ZQuery2
.
Close
;
end
;
end
;
Logged
Best regards / Pozdrawiam
paweld
dseligo
Hero Member
Posts: 1196
Re: SQLite Sum()
«
Reply #5 on:
November 23, 2022, 09:19:46 pm »
Quote from: paweld on November 23, 2022, 09:09:24 pm
Place another ZQuery component on the form, such as ZQuery2
And don't forget to connect it to ZConnection.
Oh, and Zeos works just fine.
Logged
Pe3s
Hero Member
Posts: 533
Re: SQLite Sum()
«
Reply #6 on:
November 24, 2022, 04:28:15 pm »
Thank you
Logged
Print
Pages: [
1
]
« previous
next »
Lazarus
»
Forum
»
Programming
»
Databases
»
[SOLVED] SQLite Sum()
TinyPortal
© 2005-2018