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
how to tweek fpmake to co...
by
marcov
[
Today
at 10:35:11 am]
splitting an image
by
TRon
[
Today
at 10:34:19 am]
Can function be used for ...
by
Thaddy
[
Today
at 10:24:31 am]
Parameter passing odditie...
by
Nitorami
[
Today
at 09:59:28 am]
Why isn't TTIRadioGroup's...
by
egsuh
[
Today
at 08:09:35 am]
FpDebug questions
by
440bx
[
Today
at 03:43:41 am]
Lazarus for Windows on aa...
by
Wallaby
[April 23, 2024, 11:46:56 pm]
(Solved) TIndexedAVLTree ...
by
lainz
[April 23, 2024, 10:49:03 pm]
Demo Scene Picture sinwav...
by
KodeZwerg
[April 23, 2024, 10:26:21 pm]
fkInternalCalc
by
zraja
[April 23, 2024, 09:31:07 pm]
A fairly simple sound sol...
by
KodeZwerg
[April 23, 2024, 09:23:37 pm]
add new targets to make
by
marcov
[April 23, 2024, 08:38:42 pm]
Quirky windows
by
ASerge
[April 23, 2024, 07:07:16 pm]
[Request] Demo Scene Sub ...
by
Gigatron
[April 23, 2024, 06:29:39 pm]
Unlocking Files
by
KodeZwerg
[April 23, 2024, 06:03:08 pm]
[SOLVED] trunk bug for mi...
by
Key-Real
[April 23, 2024, 05:56:32 pm]
Demo Scene Bitmap Font Sc...
by
Gigatron
[April 23, 2024, 05:56:27 pm]
Compile/Convert Delphi pr...
by
Martin_fr
[April 23, 2024, 05:43:11 pm]
Generics - correct syntax
by
Thaddy
[April 23, 2024, 05:40:59 pm]
InstallAware Using Lazaru...
by
msintle
[April 23, 2024, 05:26:36 pm]
Xcode Command Line Tools ...
by
Joseph
[April 23, 2024, 05:16:39 pm]
Offical launch of the 1 B...
by
Hartmut
[April 23, 2024, 04:49:29 pm]
what to do if my target M...
by
nickysn
[April 23, 2024, 04:16:02 pm]
compiler error in unit
by
paule32
[April 23, 2024, 03:49:50 pm]
Multithreading - synchron...
by
mika
[April 23, 2024, 01:48:51 pm]
« previous
next »
Print
Pages: [
1
]
Author
Topic: [SOLVED] SQLite Sum() (Read 797 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: 14383
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: 1003
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: 1222
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