>I have a set of records for a carrier that I display on a grid on a page of a pageframe. All kinds of issues using a filter - shouldn't use THISFORM, can't use a memory variable defined in the INIT, etc. How would I best handle the filter condition in a form, or, what would be the best way to use the resulting cursor from SQL run on a base table to update back to the base table? I don't care which at this point.
One way would be to use UPDATE FROM using your cursor to update records based on it.
I personally advise against using filters with grids having bad experience in the past.
If it's not broken, fix it until it is.
My Blog