>When in grid design mode (VFP8 SP1) I often omit the 'cursor.' prefix in column.controlsource to give me the flexibility to change the recordsource without having to adjust column properties. I change the recordsource at design-time all column.controlsource values are lost, even though the same field is present in the new recordsource. Is there any way of preventing this?
>
>I have experimented with a grid property .ColumnSourceList which contains a comma-delimited list of fields in column-display order (ie. field1,field2,field3,...). This list is parsed in grid.init and each column.controlsource loaded as appropriate. This works fine until I want to use a function in the list, and the function includes commas to separate arguments (eg. field1,field2,IIF(condition1,1,2),field4), which throws the parsing out completely.
Then use something else for a separator - a semicolon or a bar.