Re: How to change row colour

[Jose Vazquez]

Hi there,

I am also developing in Borland C++, have you experienced a problem when using DBEDIT with a database textfield?. I cannot make my application work with a dbedit because it shows (memo) when I use a vachar(16) only the first time and when I try to insert something through the dbedit it will show an error saying "cannot access my_field as type text". The thing is that when I insert with a sql sentence it will allow me to do any insertion or deletion afterwards without any problem.

I have found a way of changing the odd color rows I bet that if you use the command FOCUSED you will get what you want.

here it goes:

void __fastcall TForm6::DBGrid1DrawColumnCell(TObject *Sender, <------ DBGRID EVENT
const TRect &Rect, int DataCol, TColumn *Column,
TGridDrawState State)
{
if(!DataSource2->DataSet->IsEmpty())
{

if(DataSource2->DataSet->RecNo % 2!=0)
{
DBGrid1->Canvas->Brush->Color=clGradientInactiveCaption;
DBGrid1->DefaultDrawColumnCell(Rect, DataCol, Column, State);
}
}
}