Devart Forums

I converted one of my small apps to sdac as a test.

It uses a single ado connection and a single adoTable and grid.

When converted to sdac, it would only retrieve one record. If I scrolled down the grid, it would retrieve more records. Even after I had scrolled through all 200 records, the grid wouldn't show a scroll bar.

Eventually, I fixed it by removing the fieldname from IndexFieldNames and placing it into OrderFields instead. However it is concerning as my main application has 70 ttable components to change and I don't want to have change each one.

Also, your help files don't work on Vista as it doesn't support winhelp. You will need to provide chm files instead.

Sean

Change the TMSTable.CursorType property value to ctDefaultResultSet. Local sorting is not compatible with CursorType = ctStatic.

Thanks. that fixed it.

As a suggestion, why don't you change the CursorType in the IndexFieldNames handler?

Sean

We are going to add an exception raising on setting the IndexFieldNames property with an incompatible cursor type.