>>Hello again
>>
>>i think the "select wantedfield1 .. " isn't possible due to i'm coloring the grids row's related to some fields that shouldn't be displayed, so if i leave them out .. the coloring shouldn't function anymore
>>
>>Christian
>
>Christian,
>You were early on timing :) It's possible. See NOTWANTEDBUTPKID field. You can have as many fields as you want there but not shown.
>Cetin
BTW Foxyclasses 2nd sample (Mselgrid) is a demonstration of this :
CSQL set as
company, contact, title, city, country FROM ("data\customer")
cOrgSource set as
customer
lKeepFormat true. Rest is at their default (except Columncount=5 and headers were formatted at design time).
No code in form except 2 commandbutton's click.
Cetin