How do I control the column content in a grid when the grid recordsource is set to a SQL SELECT statement and the recordsourcetype is set to SQL. For example, statement retrieves 10 fields, but I only want to display 5 of the 10 on my grid, and be selective of which 5 I want to show, regardless of the order of the fields in the structure.
Note the SQL portion works great, but how can I select just the fields from the result cursor to show up in the grid. In Fox 2x you could browse for fields, field1, field5, field6, etc...
How do you accomplish this with the grid?
Thanks in advance.
Life's short, have fun!
Dan Madero