showing only some DB fields in flexgrid

Mike Poxon
10-14-2004, 03:59 PM
Hi. I have a flexgrid bound to a database. Even if I set the number of columns in the grid to (say) 8, it still shows all 12 of the database's fields.
My two questions are:
1) What's the point in writing
form.grid.cols=8
if more than 8 fields get shown?
2) Can you get the grid to display only those 8 fields and not the rest?

Thanks,
Michael

Shurik12
10-15-2004, 03:18 AM
Hi,

It's all about:

- returning a recordset with 8 fields only
or
- hiding the columns you don't want to be displayed


Regards,
Shurik.

Mike Poxon
10-15-2004, 05:28 AM
Dear Shurik,
Thanks for your quick reply, but, er... it doesn't get me very far!
Yes, I want to hide the columns I don't want displayed - my question is,
how do I do it?
Many thanks,
Michael

Shurik12
10-15-2004, 06:31 AM
To hide a column you simply set ColWidth property to 0

MSFlexGrid.ColWidth(i)=0


Shurik.

Mike Poxon
10-15-2004, 01:57 PM
Thanks! That of course did it (thumps own head and goes "duuurgh")
Many thanks,
Michael

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum