delphi3000.com - the free delphi knowledge platform
delphi3000.com - the free delphi knowledge platform
Have a look at your member-status

connecting people's knowledge


  - Recent ArticlesRSS feed for Recent Articles on delphi3000.com
  - List of All Articles
  - Top Viewed Articles
  - Articles (+Attachem.)
  - Articles Of Interest
  - Categories
  - Top Uploader
  - Search
  - Index

  - My Home
  - Submit an Article
  - My Articles
  - My Personal Data
  - My Bookmarks
  - Activities
  - Login/Logout

  - Sign Up
  - Why Sign Up
  - Newsletter

  - Press
  - Advertise

  - Contact
  - Feedback



Community
Borland
ClubeDelphi
Dr. Bob
UK-BUG
Delphi Meetings
Planeta Delphi








Share this article with friendsShare this article with friends
Rate this articleRate this article - to keep the quality of delphi3000.com !
Comment this article or read through previous comments (0)


NULL Values in a DBGridFormat this article printer-friendly!Bookmark function is only available for registered users!
Product:
Delphi 3.x (or higher)
Category:
Database-VCL
Skill Level:
Scoring:
Last Update:
02/27/2002
Search Keys:
delphi delphi3000 article borland vcl code-snippet DBGrid NULL DrawColumnCell AutoEdit SelectedField
Times Scored:
3
Visits:
4145
Uploader: Andreas Schmidt
Company:
Reference: N/A
 
Question/Problem/Abstract:
How to display and modify NULL-Values in a DBGrid
Answer:



You have to write two event handlers to visualize and edit NULL values
in a DBGrid.

If the user want to reset a field to NULL, he must enter the field
and type Ctrl-0.

procedure TForm1.DBGrid1DrawColumnCell(Sender: TObject;
  const Rect: TRect; DataCol: Integer; Column: TColumn;
  State: TGridDrawState);
begin
   if not (gdFocused in State) then
   begin
      if Column.Field.IsNull then
      begin
         with TDBGrid(Sender).Canvas do
         begin
            Brush.Color := clDkGray;  // change color to your personal
                                      // prefs
            Pen.Color := clWhite;
            Rectangle(Rect);
         end;
      end;
   end;
end;

procedure TForm1.DBGrid1KeyDown(Sender: TObject; var Key: Word;
  Shift: TShiftState);
var
   TheGrid : TDBGrid;
begin
   // check for Ctrl-0  (zero, not uppercase Letter O)
   if (char(Key)='0') and (shift = [ssCtrl]) then
   begin
      TheGrid := (Sender as TDBGrid);
      if TheGrid.DataSource.AutoEdit then
         TheGrid.DataSource.Edit;
      TheGrid.SelectedField.Clear;
   end;
end;






Please rate this article!
Skill level:
BeginnerExpert

Useful:
No!Very!

Overall rating:
PoorExcellent



Comments to this article
Write a new comment













 
Sign up to consume product discounts for Bronze memberships !

read more


   


  Community Ad of
A. B. Talal
 
   














 







     
  Copyright © 2000 - 2007 delphi3000.com - All rights reserved. Terms of use. || Privacy
delphi3000.com is a service by bluestep.com IT-Services GmbH (Vienna)