Anyone familiar with TrueDBGrid 8 ?

[Tailgun]

Components One TrueDBGrid 8 question.

I need to somehow go thru all the rows in the grid and if any row containing certain 2 columns in that row that are = I need to change the background and disable another column in that same row.

So far with all the other requirements this grid seems to do what I need.

Hope someone can help.

Or is there another 3rd party grid that would be better for this?

Thanks

 

[BiggerBrother]

You could try using the msflexi grid. There is alot more help out there for this type of grid than most others. Try search this forum for that grid, and then see if it is possible to do what you want with it.

Good luck

BB

 

[guitarzan]

Heres code to get you started, though its for TDBGrid 7.0, don't know how diferent 8 is. This will allow you to change the bkgrnd colors on rows which have 2 specific columns equal.

Dim rsClone As ADODB.Recordset
Dim styHighlight As New TrueOleDBGrid70.Style

Private Sub Form_Load()
Set rsClone = rsMyRecordset.Clone()
Set styHighlight = TDBGrid1.Styles.Add("styHighlight&quot
styHighlight.BackColor = &H000000FF& 'red
TDBGrid1.FetchRowStyle = True
End Sub

Private Sub TDBGrid1_FetchRowStyle(ByVal Split As Integer, Bookmark As Variant, ByVal RowStyle As TrueOleDBGrid70.StyleDisp)
rsClone.Bookmark = Bookmark

If rsClone("column1&quot.Value = rsClone("column2&quot.Value Then
RowStyle = styHighlight
End If

End Sub

 

[Tailgun]

Thanks alot guitarzan I will give this a try.
Thanks again.

 

[Glasgow]

Also, ComponentOne offer free support. You can email them with queries.