Even when the RecordSource property of the grid is set back to itself, the custom settings of the columns and headers of the grid are lost. When this happens, the grid columns and headers are also cleared and then recreated. When you rebuild the cursor that the grid is based on with the SELECT-SQL command, the original cursor has to be destroyed before the new cursor can be created. ![]() For more information, please see the following article in the Microsoft Knowledge Base:ฤก31836 PRB: Grid Not Refreshing Displaying a Cursor from Query Cause Such customization could be headers with different names, longer column lengths, and code placed in the events of columns or headers. The following command will refresh the grid properly if a SELECT-SQL is run to rebuild the cursor, but if the column or header properties of the grid have been customized, these customized changes will be lost and the column and header properties of the grid will change back to their default settings: = ![]() RecordSource property is not set back to itself. In Microsoft Visual FoxPro, if the RecordSource property of a grid is set to a cursor, and then the SELECT-SQL command resets the cursor, the grid appears blank if the Original product version: Visual FoxPro Original KB number: 140653 Symptoms ![]() This article helps you resolve the problem where cursor-based grid is blank if the SELECT-SQL command resets the cursor in Visual FoxPro.
0 Comments
Leave a Reply. |