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
A fairly simple sound sol...
by
paweld
[
Today
at 01:46:11 pm]
Demoscene The Champs Crac...
by
KodeZwerg
[
Today
at 01:45:18 pm]
Database standards OR Am ...
by
paweld
[
Today
at 01:07:33 pm]
Who is Indy mattias?
by
paweld
[
Today
at 12:58:14 pm]
How to: create DLL file f...
by
440bx
[
Today
at 12:42:21 pm]
Access violation when ope...
by
Чебурашка
[
Today
at 12:27:34 pm]
Step-into the field sette...
by
Martin_fr
[
Today
at 11:31:48 am]
Access violation when re-...
by
Chris Osborne
[
Today
at 11:31:25 am]
AI, NLP and CAI: Text Gen...
by
Dzandaa
[
Today
at 11:03:26 am]
dwindows for Android
by
PierceNg
[
Today
at 10:54:44 am]
create system unit from s...
by
Laksen
[
Today
at 10:53:57 am]
how to get class and meth...
by
cdbc
[
Today
at 10:52:22 am]
[Solved] Find child contr...
by
Joanna
[
Today
at 09:53:43 am]
FpDebug unexpected Assemb...
by
Marc
[
Today
at 08:46:38 am]
Offical launch of the 1 B...
by
Handoko
[
Today
at 07:59:07 am]
Big Numbers Math
by
iLya2IK
[
Today
at 07:13:20 am]
Lazarus for Windows on aa...
by
dbannon
[
Today
at 07:02:55 am]
BUG REPORT: Unable to gen...
by
dbannon
[
Today
at 06:29:49 am]
what to do if my target M...
by
Laksen
[
Today
at 12:49:12 am]
For-in loop over constant...
by
ASerge
[
Today
at 12:36:09 am]
Converting a string/index...
by
TRon
[April 18, 2024, 11:56:37 pm]
exclude ALL packages from...
by
PascalDragon
[April 18, 2024, 11:33:29 pm]
Poll: Watches and Display...
by
440bx
[April 18, 2024, 10:55:14 pm]
Have anyone develop UEFI ...
by
PascalDragon
[April 18, 2024, 10:14:15 pm]
The weird Rewrite bug
by
PascalDragon
[April 18, 2024, 09:58:53 pm]
« previous
next »
Print
Pages: [
1
]
Author
Topic: [SOLVED] SQLite Sum() (Read 770 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: 14373
Sensorship about opinions does not belong here.
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
Object Pascal programmers should get rid of their "component fetish" especially with the non-visuals.
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: 1002
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: 1221
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