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