Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Crazy mixed up Grid
Message
De
29/05/2002 17:17:24
 
 
À
29/05/2002 16:38:06
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00662722
Message ID:
00662743
Vues:
20
This message has been marked as a message which has helped to the initial question of the thread.
>I am using a grid class as paraphrased below:
>
>with logrid
>  .ColumnCount = 3
>  .RecordssourceType = 1
>  .Recordsource = 'SomeCursor'
>  .columns(i).ControlSource = 'SomeCursor.Field3'
>  .columns(2).ControlSource = 'SomeCursor.Field1'
>  .columns(3).ControlSource = 'SomeCursor.Field2'
>endwith
>
>...
>
>Function Form::Load
>  this.ViewRequery()
>
>
>function ViewRequery
>thisform.Grid1.recordsource = ''
>lcSql = 'select field1,field2,field3 from sometable into cursor SomeCursor'
>thisform.Grid1.recordsource = 'SomeCursor'
>
>
>
>After the first requery of the cursor all is well, however on subsequent requeries the columns revert to cursor field order. If I re-assign column controlsources after the requery all is well again. What am I missing?
>
>Glenn

Glenn,
Just a guess, but, how about rearranging the order of your fields in your select statement? Or put the column order at the top in your function.
HTH,
Winn Pauley
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform