Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Cannot re-populate a Grid
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Divers
Thread ID:
00669496
Message ID:
00669499
Vues:
14
I'm guessing the problem you're having is where the grid goes blank when you change the RecordSource. You need to change the RecordSource to "" when you rebuild the DETAILS alias, then set the RecordSource back to "Details" when you're done.

>Need anyone can help me.
>
>I populate a Grid with a free table in a form as follow:
>
>
>* Openning the free table
>if ! used ('DETALLES')
> use FILE_YYYY_MM in 0 alias DETAILS && A free table containing data with a specific
> && data of month determined by YYYY_MM
>endif
>select DETAILS
>*
>
>
>* Then populating a Grid *
>
> Thisform.GridLiquidac.RecordSource='DETAILS'
> Thisform.GridLiquidac.Cod_Item.ControlSource = 'DETAILS.Cod_Item'
> Thisform.GridLiquidac.Peso_uni.ControlSource = 'DETAILS.Net_weig'
> Thisform.GridLiquidac.Precio_uni.ControlSource = 'DETAILS.Unit_price'
> Thisform.GridLiquidac.cajas.ControlSource = 'DETAILS.Qty'
> Thisform.GridLiquidac.Total.ControlSource = 'DETAILS.Ext_price'
>
>
>Sometimes it´s necessary to change the free table for another one, changing the period (need to change the file month, but preserving the alias DETAILS, in order to REFRESH the grid with the current FILE_YYYY_MM.
>The Grid was pasted in the form from the bar , I mean it was not created by the way, I mean not with code.
>
>It seems that the Grid cannot open the alias again (I thinks because the file is another one). I tried closing the first FILE_YYYY_MM and then opening the next file FILE_YYYY_MM. But nothing. What can I do?. Any alternative?
>
>
>Thanks in advance.
>
>Carlos Burgos
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform