Lazarus
Home
Help
TinyPortal
Search
Login
Register
Lazarus
»
Forum
»
Programming
»
Databases
»
Update individual row in datagrid
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
Designer
by
SandyG
[
Today
at 03:20:24 am]
A question on Modula2 vs ...
by
speter
[
Today
at 03:09:19 am]
Initiaiizing records by c...
by
speter
[
Today
at 03:04:31 am]
Best way to exchange data...
by
cdbc
[
Today
at 03:00:24 am]
lamw
by
desconocido
[
Today
at 12:58:09 am]
scanline example
by
speter
[
Today
at 12:12:12 am]
android
by
desconocido
[
Today
at 12:03:24 am]
Pack
by
domasz
[March 18, 2024, 10:24:35 pm]
Fairtris 2: The Ultimate ...
by
furious programming
[March 18, 2024, 10:23:58 pm]
Here's some Pong game. Su...
by
Darie
[March 18, 2024, 10:22:49 pm]
IsManagedType problem, do...
by
PascalDragon
[March 18, 2024, 10:05:44 pm]
Conflict when static link...
by
tetrastes
[March 18, 2024, 10:05:28 pm]
Indeed TCustomApplication...
by
PascalDragon
[March 18, 2024, 10:00:49 pm]
"fpc.cfg is missing" (not...
by
AxBen
[March 18, 2024, 09:50:52 pm]
Interesting discovery wit...
by
wp
[March 18, 2024, 09:11:23 pm]
Use Lazarus 3.2 with FPC ...
by
AxBen
[March 18, 2024, 08:56:42 pm]
More Normal Mode for Laza...
by
RayoGlauco
[March 18, 2024, 08:55:53 pm]
How to make a watermarked...
by
loaded
[March 18, 2024, 08:37:24 pm]
Introducing a "using" key...
by
VisualLab
[March 18, 2024, 08:26:22 pm]
Code completion items
by
Martin_fr
[March 18, 2024, 08:26:17 pm]
Poll: Watches and Display...
by
Martin_fr
[March 18, 2024, 07:36:59 pm]
[Solved] Help with sql
by
Zvoni
[March 18, 2024, 05:46:32 pm]
TBGRABitmap.TextSize retu...
by
circular
[March 18, 2024, 04:40:11 pm]
Еличка - a simple calcula...
by
gidesa
[March 18, 2024, 04:16:43 pm]
Combined pointer style
by
wp
[March 18, 2024, 03:42:17 pm]
« previous
next »
Print
Pages: [
1
]
Author
Topic: Update individual row in datagrid (Read 750 times)
pcurtis
Hero Member
Posts: 951
Update individual row in datagrid
«
on:
January 21, 2021, 12:38:08 pm »
Hi All,
I am using sqlite with zeos.
My question is "How can I show changes to a row in a DBGrid without refreshing the whole dataset?"
Test app attached.
Logged
Windows 10 20H2
Laz 2.2.0
FPC 3.2.2
paweld
Hero Member
Posts: 966
Re: Update individual row in datagrid
«
Reply #1 on:
January 21, 2021, 08:45:39 pm »
Code: Pascal
[Select]
[+]
[-]
procedure
TForm1
.
Button2Click
(
Sender
:
TObject
)
;
var
iTEMP
:
integer
;
begin
if
ZQuery1
.
IsEmpty
then
exit
;
iTEMP
:
=
Random
(
10
)
;
ZQuery1
.
Edit
;
ZQuery1
.
FieldByName
(
'fnCOUNT'
)
.
AsInteger
:
=
iTEMP
;
ZQuery1
.
ApplyUpdates
;
Button2
.
Caption
:
=
iTEMP
.
ToString
;
end
;
if you use only one table in query you can do it this way, but if you use several tables (e.g. via JOIN) then you have to use the
ZUpadateSQL
component
Logged
Best regards / Pozdrawiam
paweld
Print
Pages: [
1
]
« previous
next »
Lazarus
»
Forum
»
Programming
»
Databases
»
Update individual row in datagrid
TinyPortal
© 2005-2018