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
change details Office fil...
by
KodeZwerg
[
Today
at 07:05:44 am]
Forum slow
by
TRon
[
Today
at 04:26:32 am]
Web Applications with Pas...
by
egsuh
[
Today
at 04:02:51 am]
Demo Scene Picture sinwav...
by
Gigatron
[
Today
at 03:42:01 am]
Demo Scene Bitmap Font Sc...
by
Gigatron
[
Today
at 03:14:55 am]
open dialog - default dir...
by
jamie
[
Today
at 02:24:45 am]
Is it possible to open a ...
by
Martin_fr
[
Today
at 01:56:48 am]
leetcode doesn’t support ...
by
Joanna
[
Today
at 01:42:28 am]
Preparing FPC 3.2.4, poin...
by
peter.dell
[
Today
at 01:38:41 am]
Can function be used for ...
by
jamie
[
Today
at 12:26:42 am]
DbGrid, grid column check...
by
KodeZwerg
[
Today
at 12:08:29 am]
Colore celle StringGrid
by
JuanBell
[April 24, 2024, 10:37:56 pm]
Likely bug
by
440bx
[April 24, 2024, 10:12:59 pm]
Any upgrades to fpWeb pag...
by
verasan
[April 24, 2024, 10:11:46 pm]
AI, NLP and CAI: Text Gen...
by
indydev
[April 24, 2024, 08:54:00 pm]
Offical launch of the 1 B...
by
Gustavo 'Gus' Carreno
[April 24, 2024, 08:48:22 pm]
Multidimensional arrays a...
by
KodeZwerg
[April 24, 2024, 08:34:38 pm]
Ho Ho Ho IntraWeb in Laza...
by
Thaddy
[April 24, 2024, 08:31:29 pm]
[SOLVED] System.Now gives...
by
alpine
[April 24, 2024, 08:29:19 pm]
Installing and using Vamp...
by
Odacir
[April 24, 2024, 07:58:22 pm]
what's difference between...
by
ASerge
[April 24, 2024, 07:09:52 pm]
splitting an image
by
KodeZwerg
[April 24, 2024, 07:07:21 pm]
Debugger error
by
bobonwhidbey
[April 24, 2024, 07:03:07 pm]
How to: create DLL file f...
by
paule32
[April 24, 2024, 07:02:31 pm]
Your best UI design - con...
by
circular
[April 24, 2024, 06:48:12 pm]
« previous
next »
Print
Pages: [
1
]
Author
Topic: [SOLVED] SQLite Sum() (Read 798 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: 14393
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