> I set a grid's RecordSourceType to 1 (alias) and the RecordSource to a name of a standalone table (MyTable.dbf). It works fine and the user can change values in the table for all columns with ReadOnly property set to .F.. Just like an old Browse command.
>
> Ok, now I want the user could filter the table in the grid. It could be done with SET FILTER command and refreshing the grid, but that's not the way I want to go, because of »set filter«'s slow performances.
> I'd like to make a SQL statement, put the results in the cursor and refresh the grid with RecordSource set to the name of the cursor instead of the master MyTable.dbf. Well, it would be ok, the only poblem is - if the user changes values in the grid it's not automatically stored in the master table (MyTable.dbf) as it was in the first solution without the cursor.
>
> I know it could be done with adding some »Save« button and running a procedure with Update statements, but I wonder if there is an easier way. I know also that using a view could be a solution, but since it is a standalone table without database, I don't know if it could be done.
>
> In past, I've already do something similary on SQL server - binding the cursor created with a SQL statement with a table from database connection, setting a couple of Cursorsetprop and it works. Now I can't do it in the simpler environment – or is it possible?

Have a look at CursorAdapter Class
Or use a regular cursor and use the GetFldState to see if anything changed in the data.

Mike Gagnon
Refox XI +(English version)