Column Visible in Grid  
Author Message
cwhetsel





PostPosted: Visual FoxPro General, Column Visible in Grid Top

Ok, I am creating a grid and I need to create a column called "ProvRecno" to use for a refrence pointer. I can make the column, and I can see all the info I need, however I want that column to be non-visible. I am not sure how to set this column to visible = .f.

The Grid is built from a SQL select, and I need some way to select the column titled ProvRecno so that I can set its visibility to .f.

Any Ideas



Visual FoxPro2  
 
 
CetinBasoz





PostPosted: Visual FoxPro General, Column Visible in Grid Top

Then in your select put that column in last position and in your grid set columncount to be less than field count.
 
 
Markish





PostPosted: Visual FoxPro General, Column Visible in Grid Top

Hi ,

You can try

Thisform.mygrid.columns(4).visible=.f.

If fourth coulmn is the above said pointer column.

Regards,

Markish



 
 
CetinBasoz





PostPosted: Visual FoxPro General, Column Visible in Grid Top

Probably he is asking for his version is old and doesn't support visible = .f. behavior as it does under VFP9 (wish posters always added the version number they're using). In older versions (ie: 7) end result was:

Column is still there and visible. Only content is 'empty'.


 
 
Markish





PostPosted: Visual FoxPro General, Column Visible in Grid Top

Hi Cetin,

Can we set the columns' width property to zero in case of older versions....

Regards,

Markish



 
 
CetinBasoz





PostPosted: Visual FoxPro General, Column Visible in Grid Top

No setting to 0 was also ill behaving. It was setting to columnwidth to 0 but gridline is there, making a thicker gridline (the more the invisible columns the thicker the line was). And using tab key or alike that column(s) is visited in between (user gets confused where the cursor is when that column gets focus).
 
 
Markish





PostPosted: Visual FoxPro General, Column Visible in Grid Top

Yes I agree with you...