>>>>I am looking for some kind of documentation on the Grid class in FoxPro 5.0. Specifically I am looking for some information on how to display a SQl SELECT result in a grid.
>>>>
>>>>Any ideas?
>>>
>>>
>>>AFTER following Jim' advice, you can display only a few of the columns from your SQL-SELECT cursor (or display them in a different order) by assigning the ControlSource of each column to the field you want to see displayed.
>>
>>Is there a reason for not setting the recordsourcetype 4 and then just use the sql as recordsource? I've used this a lot and had no problems. Am I missing something.
>>
>>
>>JEFF
>
>The common problem here is overriding the cursor. It works smoothly only if you have plainly designed grid, i.e. all column.controls are textboxes, no customized controlsources and etc. Having recordsource= alias, you may adjust these things, if they are more complicated, programmatically.


Thanks Ed

I've only ever used textbox because of all the problems I've had and seen here.

Jeff