>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).
If it's not broken, fix it until it is.
My Blog