General information
Category:
Forms & Form designer
Title:
Cannot re-populate a Grid
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only