Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Network:
Windows 2008 Server
>>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?
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement