I have an mshflexgrid in a vb6 project. Its data source is an adodc object. I use this app to look at a list of batch jobs for our system. The batch jobs can be cancelled, killed, queued, running, etc. If I double click on an item, I can get details of that job and everything works well (It works great when there is data to view). However, if the adodc object has no data for a specific status (for ex: no cancelled jobs) and then I change to look at jobs in a different status (say complete), the double click no longer works propertly. It is off by one row. Does anyone know how to fix this?
Well, I was too impatient to wait for someone to reply. Hopefully someone will have a better solution than the one I have. To work around the problem, I created another adodc recordset, clone the first to the second and if my search returns no data, close back the record set and tell the user that there was no data... return them to the previous record set.