I have found in VFP5 the following buggy behavior: RecordSourceType for the grid is Alias. I invoke some code during an event, such as a RightClick on an object in a grid column (e.g., a textbox). For example, the RightClick event might be:
-
DO SomeProc in SomeProcFile
-
Within SomeProc, the current workarea is saved and a SELECT statement is used to select a different work area. WON'T WORK! VFP changes the work area back to that of the Grid's alias immediately after the SELECT statement is executed.
-
However, if in the event code I programmatically change focus from the grid to some other object on the form, then invoke SomeProc as shown above, that everything works fine.
-
So, bottom line seems to be: During a grid-related event, VFP won't let you change workareas as long as the grid has focus.
-
Would love to know if anybody else has seen this behavior.