>>>I am creating an application utilizing a connection string to a SQL Database. How can I manipulate the order of the fields from the SQL table into a Grid? Everything I try, I get the exact order of the fields from the SQL table in the grid.
>>>
>>>I have even tried hardcoding the format I want after the I perform the cursorfill() command.
>>>
>>>thisform._grid1.column1.hEADER1.Caption="Report #"
>>>thisform._grid1.column1.text1.ControlSource="OCA"
>>>thisform._grid1.column1.AutoFit
>>>
>>>Thanks much in advance
>>
>>You need to set each column's controlsource to the correct AliasName.FieldName. You can do it in design time (and adjust all headers) or in run-time (form's Init).
>
>
>Thank you. I got everything to work but the header adjustment. I am using:
>
>thisform._grid1.column1.autofit
>
>Any recommendations to make the grid column grow to actual size of the returned data?
I think you can run Grid.AutoFit() in form's Init.
If it's not broken, fix it until it is.
My Blog