>I have code in the DBLClick method of the textbox control in a grid. The data source of the grid is a cursor created by a paramaterized SQL Passthrough statement. The DBLClick method works until I re-issue the SQL Passthrough to get a different set of records in the cursor. What do I have to do to keep the DBLClick method working in this column?
I guess the problem arises when you change grid contents (grids don't like situations when underlying cusror is overwritten). If your cursor is not very big, then the appropriate solution is to have one more cursor permanently linked to the grid. When sqlcursor gets changed you ZAP gridcursor and append records from sqlcursor. If cursor is big then you may better restore grid properties (including e.g. Column.CurrentControl if it's the case) after sqlcursor changed.
Edward Pikman
Independent Consultant