I am using Delphi 10, compiling 32bit, and have following tables in MSSQL Express 2014 64bit
Code: Select all
CREATE TABLE PDKS_DETAY(
AdresKodu nvarchar(30) NOT NULL,
Tarih date NOT NULL,
PersonelTCNo nvarchar(15) NOT NULL,
Yil smallint NOT NULL,
Ay smallint NOT NULL,
Hafta smallint NOT NULL,
Gun smallint NOT NULL,
KaydiGiren nvarchar(10) NOT NULL,
BaslangicSaati datetime NOT NULL,
BitisSaati datetime NOT NULL,
MolaSuresi datetime NOT NULL,
NetCalismaSaati datetime,
Yevmiye smallmoney NOT NULL,
OnaylananYevmiye smallmoney,
Prim smallmoney,
OnaylananYevmiyeNotu nvarchar(30),
KayitZamaniIlk datetime NOT NULL,
KayitZamaniDegisiklik datetime,
KaydiGirenIlk nvarchar(10) NOT NULL,
PRIMARY KEY (AdresKodu, Tarih, PersonelTCNo)
)Code: Select all
CREATE TABLE PERSONEL(
TCNo nvarchar(15) NOT NULL,
SicilNo nvarchar(15) NOT NULL,
SGKNo nvarchar(15) NULL,
Ad nvarchar(30) NOT NULL,
Soyad nvarchar(40) NOT NULL,
OncekiSoyadi nvarchar(40),
DogumTarihi date NOT NULL,
Cinsiyet nchar(1) NOT NULL,
Istihdam nvarchar(1) NOT NULL,
CalismaDurumu nvarchar(5) NOT NULL,
IseAldiran nvarchar(102) NOT NULL,
Kaydeden nvarchar(102) NOT NULL,
SonHareketTarihi date,
EvTel nvarchar(20),
CepTel nvarchar(20),
Cep2Tel nvarchar(20),
Cep3Tel nvarchar(20),
Notlar nvarchar(2048),
Adres1 nvarchar(50),
Adres2 nvarchar(50),
PostaKodu nvarchar(10),
ILCE nvarchar(15),
IL nvarchar(15),
Aktif nchar(1) NOT NULL,
BankaAdi nvarchar(20),
SubeKodu nvarchar(10),
SubeAdi nvarchar(20),
BankaIL nvarchar(20),
IBAN nvarchar(34),
HesapNo nvarchar(16)
)
ALTER TABLE PERSONEL WITH CHECK ADD CONSTRAINT [CK_PERSONEL] CHECK (([Cinsiyet]='E' OR [Cinsiyet]='K'))
ALTER TABLE PERSONEL CHECK CONSTRAINT [CK_PERSONEL]Code: Select all
select a.*,(b.Ad+' '+B.Soyad) as "AdiSoyadi" from PDKS_DETAY a, PERSONEL b
where b.TCNo = a.PersonelTCNo
There are two TTimer components on this form. They are doing nothing related with Grid, and they are not Enabled by default. One is Enabled in Form.OnActivate and other one is Enabled after 1 minute. They are both disabled in about 70 seconds later and not Enabled again until next Form.OnActivate.
Following parameters are set for CRDBGrid:
Allign:= alBottom;
Height:= 114;
Options.dgEditing := False;
Options.dgRowSelect := True;
Options.dgAlwaysShowSelection := True;
OptionsEx.dgeSummary := True;
TabStop := False;
Following Columns are defined at Design-Time in CRDBGrid.
0 - PersonelTCNo
1 - AdiSoyadi
2 - BaslangicSaati
3 - BitisSaati
4 - MolaSuresi
5 - NetCalismaSaati
6 - Yemiye
7 - OnaylananYevmiye
8 - Prim
All Columns' Title.Allignment is set to taCenter. Columns Yevmiye, OnaylananYevmiye and Prim have property SummaryMode set to smSum.
All columns in SQL are defined as fields in UniQuery at degisn-time. No display mask set for Columns Yevmiye, OnaylananYevmiye and Prim. There are display masks for columns 2,3,4,5.
Running application, I have following Grid displayed on screen. Please pay attention to bottom summary section. There is nothing displayed there.
However, I recognize that when I move my mouse pointer over that summary sections, I can see, just for the blink of an eye, numbers displayed. Then it is as in the picture above. What I suppose is grid re-drawing/painting itself with mouse moving over.
I also have same flickering at the title section of the Grid, too. Especially when Filter/Search bar is displayed that effect is easier to recognize. Not sure if that is by design or something that needs to be fixed.
I confirm that exactly same summary is displayed at design-time when UniQuery.Active = True. There is no flickering affect for both summary and title at design-time when I move my mouse pointer over.
I did not check if other summary properties (Avg, Min, Max, etc.) for Columns are same or not. I have a strong feeling that they will be same.
I appreciate if you can confirm that you are able to reproduce the problem.