My computer : Visual Basic 6 (SP3) & Win2K

This works:
  sSQL = ....
  set rs = new ADODB.recordset
  rs.open sSQL, cnn1, adOpenDynamic, adLockPessimistic, adCmdText
  DataGrid1.DataSource = rs
  ....

This doesn't work:
  sSQL = ....
  set rs = new ADODB.recordset
  rs.open sSQL, cnn1, adOpenDynamic, adLockPessimistic, adCmdText
  MSFlex1.DataSource = rs
  ....

generating run-time error 91 "Object variable or with block variable not set"

What the ... is this ? Do I need another patch or what ?
Thanks !

Mike

i think that flexgrid is designed only to be set to DAO connection, and can't be set to ADO , so if you need to populate flexgrid you with Ado recordset data you have to make that manually, filling the text value of the cells,

there is also one thing.. MSHFlexGrid control is a hierarchical flexgrid control could be used with ADO, this control could allow hierarchical view for data.

Ahmed Ali
Software Developer