setall columns sparse to .F. 1

[hoosier121]

Hi all,
Instead of doing this:
This.column1.Sparse = .F.
This.column2.Sparse = .F.
This.column3.Sparse = .F.
This.column4.Sparse = .F.
This.column5.Sparse = .F.

Is it possible to set all of these to .F. with either the setall command or a loop? If so, Tips would be appreciated.



John

Everything I needed to know I learned from Yoda.

 

[fluteplr]

this.setall('sparse',.f.)

assuming this is a reference to the grid

 

[hoosier121]

Thanks fluteplr,
I was trying to use the setall with the .column prefix in front of sparse and it wouldn't work for me.

I was also able to figure out how to do this with a loop construct but I like your approach better, it's less code.

WITH This
i = 0
FOR EACH oColumn IN .COLUMNS
i = i + 1
oColumn.Sparse = .F.
ENDFOR
ENDWITH John

Everything I needed to know I learned from Yoda.

 

[fluteplr]

Faster too, at least by a couple of milliseconds.



Your technique is great for setting properties to something that might be difference for each column.