Lazarus
Home
Help
TinyPortal
Search
Login
Register
Lazarus
»
Forum
»
Programming
»
Databases
»
How can i hide some rows in dbgrid?
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
Database standards OR Am ...
by
paweld
[
Today
at 07:21:12 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]
Offical launch of the 1 B...
by
Gustavo 'Gus' Carreno
[
Today
at 12:50:46 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]
Demoscene The Champs Crac...
by
KodeZwerg
[April 18, 2024, 11:29:50 pm]
Poll: Watches and Display...
by
440bx
[April 18, 2024, 10:55:14 pm]
How to: create DLL file f...
by
paule32
[April 18, 2024, 10:23:59 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]
Assign (textfile) not com...
by
PascalDragon
[April 18, 2024, 09:51:50 pm]
Question for people who h...
by
PascalDragon
[April 18, 2024, 09:44:32 pm]
Linux Workspaces -- StayO...
by
AmatCoder
[April 18, 2024, 08:34:20 pm]
I just released a commerc...
by
Seenkao
[April 18, 2024, 07:57:21 pm]
Access violation when re-...
by
TRon
[April 18, 2024, 07:37:31 pm]
[SOLVED] assembler name i...
by
TRon
[April 18, 2024, 07:26:33 pm]
A fairly simple sound sol...
by
KodeZwerg
[April 18, 2024, 07:01:52 pm]
Step-into the field sette...
by
Martin_fr
[April 18, 2024, 06:54:19 pm]
[Fun Fact] PNG and Micros...
by
Ten_Mile_Hike
[April 18, 2024, 06:24:19 pm]
HTTP/2+HTTP/1.1+WebSocket...
by
iLya2IK
[April 18, 2024, 06:14:30 pm]
Improvement of TFPTimerTh...
by
AlexTP
[April 18, 2024, 05:56:38 pm]
« previous
next »
Print
Pages: [
1
]
Author
Topic: How can i hide some rows in dbgrid? (Read 4463 times)
majid.ebru
Hero Member
Posts: 502
How can i hide some rows in dbgrid?
«
on:
December 31, 2018, 08:27:11 am »
Hi
I have a dbgrid,how can i hide some rows in dbgrid?!
Logged
mangakissa
Hero Member
Posts: 1131
Re: How can i hide some rows in dbgrid?
«
Reply #1 on:
December 31, 2018, 08:48:49 am »
use the filter of your dataset.
Logged
Lazarus 2.06 (64b) / FPC 3.0.4 / Windows 10
stucked on Delphi 10.3.1
dsiders
Hero Member
Posts: 1080
Re: How can i hide some rows in dbgrid?
«
Reply #2 on:
December 31, 2018, 01:44:56 pm »
Quote from: mangakissa on December 31, 2018, 08:48:49 am
use the filter of your dataset.
Or, if it is SQL-based, by adding a WHERE clause to its SQL select statement.
Logged
Preview Lazarus 3.99 documentation at:
https://dsiders.gitlab.io/lazdocsnext
majid.ebru
Hero Member
Posts: 502
Re: How can i hide some rows in dbgrid?
«
Reply #3 on:
January 01, 2019, 04:55:22 am »
Quote from: mangakissa on December 31, 2018, 08:48:49 am
use the filter of your dataset.
How?
Can you explain?
Logged
Handoko
Hero Member
Posts: 5153
My goal: build my own game engine using Lazarus
Re: How can i hide some rows in dbgrid?
«
Reply #4 on:
January 01, 2019, 08:30:26 am »
https://www.freepascal.org/docs-html/fcl/db/tdataset.filter.html
https://www.w3schools.com/SQl/sql_where.asp
Logged
Robert.Thompson
Jr. Member
Posts: 56
"A very bad coder."
Re: How can i hide some rows in dbgrid?
«
Reply #5 on:
January 02, 2019, 09:32:01 pm »
Newbie here so, beware.
DBGrid1.Columns[N].Visible:=false;
where N = column number with the first being 0 (zero), I think.
Rob.
Logged
Lazarus: 1.8.4 2018-11-17
FPC: 3.0.4 x86_64-linux-gtk2
System: Kernel: 4.15.0-39-generic x86_64 bits: 64 gcc: 7.3.0 Cinnamon 3.8.9 Linux Mint 19 Tara
Phoenix v: 11JB.M044.20100622.hkk date: 06/22/2010
Intel Core i5 M 460 (-MT-MCP-) arch: Nehalem rev.5 cache: 3072 KB
NVIDIA GeForce 310M
mangakissa
Hero Member
Posts: 1131
Re: How can i hide some rows in dbgrid?
«
Reply #6 on:
January 03, 2019, 08:11:08 am »
A column is not a row
Logged
Lazarus 2.06 (64b) / FPC 3.0.4 / Windows 10
stucked on Delphi 10.3.1
Robert.Thompson
Jr. Member
Posts: 56
"A very bad coder."
Re: How can i hide some rows in dbgrid?
«
Reply #7 on:
January 03, 2019, 06:27:59 pm »
"A column is not a row"
Yep, my mistake.
Logged
Lazarus: 1.8.4 2018-11-17
FPC: 3.0.4 x86_64-linux-gtk2
System: Kernel: 4.15.0-39-generic x86_64 bits: 64 gcc: 7.3.0 Cinnamon 3.8.9 Linux Mint 19 Tara
Phoenix v: 11JB.M044.20100622.hkk date: 06/22/2010
Intel Core i5 M 460 (-MT-MCP-) arch: Nehalem rev.5 cache: 3072 KB
NVIDIA GeForce 310M
Print
Pages: [
1
]
« previous
next »
Lazarus
»
Forum
»
Programming
»
Databases
»
How can i hide some rows in dbgrid?
TinyPortal
© 2005-2018